1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Basic Calculations in Excel Spreadsheets

Using Excel Formulas and Functions

By

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.

8) "What If" Questions in Excel

"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.

©2014 About.com. All rights reserved.