This Series of Excel Articles and Tutorials will teach you the fundamentals of using formulas and functions to perform basic calculations in Excel spreadsheets.
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.
This step by step tutorial shows you the steps for writing basic formulas in Excel 2010. The topics include using
to create formulas and how to copy formulas using the fill handle
This step by step tutorial shows you the steps for writing basic formulas in Excel 2007. The topics include using
to create formulas.
This step by step tutorial shows you the steps for writing basic formulas, using
to create formulas, how to use
and to edit the
The Excel SUM
is probably the most often used function in Excel spreadsheets. This tutorial covers how to use the SUM function in Excel 2010.
This tutorial covers how to use the SUM
in Excel 2007.
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.
"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions is very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.