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

Chapter 19. Outlining, Subtotaling, and ... > Validating and Auditing Data Entry

Validating and Auditing Data Entry

Somewhere along the line, the data in every Excel workbook came from a human being. The process may have included typing data directly, downloading from a network or the Internet, importing from a database or data warehouse, and so on, but every bit of data can eventually be traced back to someone "filling in the blanks." Everyone makes mistakes at least occasionally, and the most complex formula is useless if its source data is wrong. On the other hand, accurate source data isn't very helpful if the formulas aren't constructed in a way that returns appropriate results. How can you prevent data errors and incorrect formulas from creeping into your Excel workbooks?

Excel offers some special features for dealing with the possibility of error within a workbook:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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