Watching Cells

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

Helpful Links

Get Microsoft Office Excel 2007Get Office 2007 for Home/StudentsGet Office 2007 Pro Edition

Watching Cells

Software/Hardware used : Microsoft Office 2007

Views: 9327

Create a Formula

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

COUNT

Use the COUNT function - count how many numbers, words or specified words are in a selection
Define Name for Cell Ranges

Apply a name to a range of cells
IF Function

Use the IF function - A test which checks whether a certain condition is true or false, and will display a...
Define Multi-Sheet Cell Range Names

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

Manage the names you've applied to cell ranges
Named Ranges in Formulas

Using named ranges in formulas
View Named Ranges

View named ranges easily
VLOOKUP

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