Microsoft Office Tutorials and References

In Depth Information

**Key points**

Key points

▪
You can add a group of cells to a formula by entering the formula, and then at the

spot in the formula in which you want to name the cells, selecting the cells.

▪
By creating named ranges, you can refer to entire blocks of cells by using a single

term, saving you lots of time and effort. You can use a similar technique with Excel

table data, referring to an entire Excel table or one or more table columns.

▪
When you write a formula, be sure you use absolute referencing ($A$1) if you want

the formula to remain the same when it’s copied from one cell to another, or use

relative referencing (A1) if you want the formula to change to reflect its new position in

the worksheet.

▪
Instead of entering a formula from scratch, you can use the Insert Function dialog box

to help you.

▪
With iterative calculations, you can manage formulas that have circular references.

▪
You can use array formulas to summarize ranges of values by creating a single

formula.

▪
You can monitor how the value in a cell changes by adding a watch to the Watch

Window.

▪
To find out which formulas refer to the values in the selected cell, use Trace

Dependents; if you want to find out which cells provide values for the formula in the active

cell, use Trace Precedents.

▪
You can step through the calculations of a formula in the Evaluate Formula dialog box

or go through a more rigorous error-checking procedure by using the Error Checking

tool.

3