Use of tutorials and guides that provide helpful instructions can help you learn to create Excel formulas, and practicing these spreadsheet tools reinforces the knowledge. Use a guide to Excel spreadsheet equations, such as that provided by About.com, to understand each step thoroughly.
Tutorials provide a helpful way to learn Excel formulas, with guides available for both simple and complex problems that arise when putting together a spreadsheet. Tutorials are also available to help a user troubleshoot problems along the way and explain what the components of a formula are for.
One source for Excel tutorials is Excel-Easy.com, an Excel-centric site that provides instruction on the basic functions found in the program and how they are used. This website provides instructions through picture examples and covers everything from the functions of the program itself to basic formulas, all the way up to Visual Basic for Applications functions.
The Microsoft Office website (office.com) offers an index of the different components of Excel formulas. Each component and its interactions within a formula are explained in great detail. This website is a good place to return to for reference if a formula's function is unclear at any point during the learning process.