Using 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