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.