This Series of Excel articles and tutorials will teach you the fundamentals of using formulas 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 tutorial covers how to write basic formulas in Excel 2010. This tutorial includes a step by step example of creating basic formulas in Excel 2010.
This step by step tutorial shows you the steps to follow to write basic formulas in Excel 2007.
This step by step tutorial shows you the steps to follow to write basic formulas in Excel 2003.
These articles cover how to carry out basic math operations using formulas in Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these articles will show you how.
Cell references describe the location of a cell in an Excel spreadsheet. These cell references can be used in formulas. Excel will calculate the answer for the formula using the data located in the referenced cell.
Show formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas.
"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.
A name can be given to a range
of cells. Using this range name in formulas can not only make it easier to create the formula, but it can also make it easier to copy the formula to other cells in the worksheet
This tutorial covers the mathematical operators and the order of operations used in Excel formulas. Mathematical operators tell Excel which operation, such as addition, subtraction, multiplication, or division, the formula is to perform. The order of operations tells Excel which of these operations it is to carry out first.