The topics of this hour include the following:

How to audit formulas

How to validate data

How to circle invalid data

How to use constants and formulas

How to define label ranges

In this hour, you learn auditing terms, use the Formula Auditing toolbar, check and review worksheet data, learn how values are determined, and track problems in formulas. You'll also use the Data Validation command to validate the data in your worksheets and circle any invalid data so that you can make the corrections.

When this hour ends, you'll be auditing and validating the data in your own worksheets to catch errors. By doing the exercises in this hour and using Excel's formula auditing and validation tools, you'll discover how quick and easy it is to audit and validate your work.