|Home > Excel Business Solutions > Excel Productivity > Navigation and Auditing > Data Integrity Analysis||Share|
Excel Data Integrity Analysis
Rate this solution:(3/5 from 2 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 AnalysisConditional Row DeletionTime Saving Convert 2007 VersionConverting and Integrating Data Manipulation ToolsData Management
|Share your thoughts and opinion with other users: Create Review|
Browse Main Excel Solution CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity