Auto Sum

A look at how to create formulas in Excel 2007. Save time and create powerful equations.

Apply a name to a range of cells

Use the IF function - A test which checks whether a certain condition is true or false, and will display a...

Apply a name to a range of cells which span multiple sheets

Manage the names you've applied to cell ranges

Using named ranges in formulas

View named ranges easily

Use the VLOOKUP function - Create a table which stores information and/or values, which will be applied to other cells

Easily watch selected cells no matter what you're currently looking at

How to edit equations you've created in Excel 2007.