• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Basic Calculations in Excel Spreadsheets

## Using Excel Formulas and Functions

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.

Ted French