Hour 16. Auditing and Validating Your WorkThe topics of this hour include the following:
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. |