| Home > Excel Business Solutions > Excel Productivity > Navigation and Auditing > Data Integrity Analysis | Share |
Excel Data Integrity Analysis | Rate this solution: (2/5 from 4 votes) |
|
The Data Integrity Analysis add-in for Excel is a very powerful tool for analyzing spreadsheet integrity within Microsoft Excel 97 software onwards. Excel Data Integrity Analysis is most likely to be used for two main purposes: 1. To assist in checking a workbook for integrity and for errors in logic and content, and 2. To help a user understand and find their way around a workbook created by a different author. The Excel Data Integrity Analysis add-in is essentially a tool that runs across worksheets and changes the appearance of each cell based on its contents. This allows you to see at a glance whether cells contain a formula, text, or a number, or result in an error (this default option can be switched off). So it is easy to understand how a worksheet is constructed, irrespective of the actual values displayed. The Excel Data Integrity Analysis add-in consists of two basic tools:
You can clearly see which cell is a number and should be a formula since it is colored as the other numbers (yellow = text, blue = number, green = formula). FACT: Users believe that there is only an 18% chance that their completed spreadsheets contain errors, but 86% actually did contain errors. [Panko R & Halverson R 1996 'Spreadsheets on Trial: A Survey of Research on Spreadsheet Risks']. | |
Related Excel Solutions for Data Integrity AnalysisData Manipulation ToolsData Management Convert 2007 VersionConverting and Integrating |
| Share your thoughts and opinion with other users: Create Review |
Browse Main Excel Solution CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity |