Named Ranges in Formulas

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

Use the COUNT function - count how many numbers, words or specified words are in a selection

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

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