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

Part V: Analyzing the Worksheet > Auditing Workbooks and Worksheets

Chapter 30. Auditing Workbooks and Worksheets

  • Troubleshoot error messages

    If you make a mistake, Excel displays an error message which helps you pinpoint the problem.

  • View cell information

    View formulas rather than results to make a printed backup of your worksheets.

  • Use Excel's auditing tools

    Use the auditing tools to check formulas and find errors.

  • Check spelling

    To avoid embarrassing spelling errors, check the spelling in your workbook.

  • Add comments to the worksheet

    Use comments to document the worksheet. You can make them display automatically when a pointer moves over their cell.

Surveys show that 30 percent of all computer worksheets contain errors. This statistic can be terrifying but believable when you consider that most users receive little or no training, and few are trained in designing or auditing worksheets. Few companies have policies for auditing or documenting worksheets.

Correct worksheets require careful planning and execution. Always be sure that you cross-check and review a new worksheet before using it for a critical decision. Excel has built-in commands, macros, and error values to help you discover trouble spots in your worksheets.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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