• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Analyzing Your Data > Auditing and Validating Worksheets

Chapter 19. Auditing and Validating Worksheets

by Bruce Hallberg with Joyce Nielsen

  • Using Excel's auditing tools

    Excel provides tools for error-checking worksheets on the Auditing toolbar. These tools enable you to trace formula precedents and dependents, find cells that contribute to error results, and display the formulas in a worksheet.

  • Validating user input

    You have to allow for mistakes in workbooks you create. Excel's data validation features make checking for errors during data entry quick and easy.

  • Using names in Excel to improve worksheet accuracy

    Cell or range names that you define are generally easier for you to remember and type in formulas than obscure cell references. Therefore, using names whenever possible can help reduce the number of errors in your worksheets.

  • Working with cell comments

    Wouldn't it be nice if you could attach yellow sticky notes to your worksheets? With Excel's cell comments, you can do just that. Use cell comments to document individual cells in ways that make your worksheets more understandable.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint