MP9002: Desktop Computing - Validating and Auditing Data > Excel 2000 MOS Expert

This course shows users how validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell. 

Topics:
Validating Data
Using the Auditing Toolbar
Tracing Precedents and Dependents

Objectives:
Validate data
Use the Auditing toolbar
Trace cells referenced in a formula (precedents)
Trace formulas that depend on contents of a cell (dependents)

Duration:
2 Hours