Hour 16. Auditing and Validating Your Work
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 ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
