## About this lesson

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

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Formula Auditing.xlsx11.4 KB Formula Auditing - Extra Practice.xlsx

15.2 KB

## Quick reference

### Topic

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

### When to use

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
- On the FORMULAS tab, click 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
- On the FORMULAS tab, click 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
- On the FORMULAS tab, click Evaluate
- As you click Evaluate, Excel will evaluate the underlined portion of the equation
- Notice that Excel follows the Order of Operations (BEDMAS, BODMAS, PEMDAS or whichever acronym you may know it by)

Lesson notes are only available for subscribers.