This Series of Excel Articles and Tutorials will teach you the fundamentals of using formulas and functions to perform basic calculations in Excel spreadsheets.
1) Why Use Formulas in Excel?
Excel formulas are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you.
2) Basic Excel 2010 Spreadsheet Tutorial
This step by step tutorial shows you the steps for writing basic formulas in Excel 2010. The topics include using cell references, pointing to create formulas and how to copy formulas using the fill handle.
3) Excel 2007 Step by Step Formula Tutorial
This step by step tutorial shows you the steps for writing basic formulas in Excel 2007. The topics include using cell references and pointing to create formulas.
4) Using Formulas in Excel 2003
This step by step tutorial shows you the steps for writing basic formulas, using cell references and pointing to create formulas, how to use formula operators and to edit the data in formulas.
5) Excel 2010 SUM Function Tutorial
The Excel SUM function is probably the most often used function in Excel spreadsheets. This tutorial covers how to use the SUM function in Excel 2010.
6) Excel 2007 SUM Function Tutorial
This tutorial covers how to use the SUM function in Excel 2007.
7) IF Function Step by Step Tutorial
One of the most useful functions in Excel is the IF function. The IF function works by testing to see if a certain condition is true. If it is, the function enters one result in a specific cell, if it is not, it enters a different result in that cell.
