Locked lesson.

## About this lesson

Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.

## Quick reference

### Topic

Formula auditing.

### Description

Working with formula auditing tools including tracing precedent cells, dependent cells, and stepping through formula evaluation.

### Where/when to use the technique

These tools are incredibly useful for debugging spreadsheets that have errors, or trying to understand the business logic that someone built in the file.

### Instructions

#### Tracing precedents

- Select a cell with a formula in it
- Select FORMULAS then Trace Precedents
- Arrows will be drawn on the worksheet showing all ranges that feed into that cell.

#### Tracing dependents

- Select any cell on the worksheet
- Select FORMULAS then Trace Dependents

- Arrows will be drawn on the worksheet showing all cells that rely on the selected cell.

#### Formula evaluation

- Select a cell with a formula in it
- Select a cell reference and press F9

- Notice that Excel follows the Order of Operations (BEDMAS, BODMAS, PEMDAS or whichever acronym you may know it by.)
- DO NOT PRESS ENTER when you are done, as this will commit the number (not the formula) to the cell. (Press ESC instead.)

Lesson notes are only available for subscribers.