ExcelSmartTools Auditor was developed to help Microsoft Excel users audit and check spreadsheets and models. Many studies reports that spreadsheet errors are the rule, and for many spreadsheet models, Microsoft Excel Audit tools are not enough.
Auditing a spreadsheet can be done on a Cell-by-Cell basis or Group-by-Group Basis. The first requires users to check every cell, a lengthy and faulty process. The latter requires users to analyze a group of colored cells indicating different types of data.
The Microsoft Excel Audit tool works on a cell-by-cell basis. ExcelSmartTools Auditor works either on a cell-by-cell basis or group-by-group basis.
Features:
1 - Auditor Quick Info provides users information about workbook properties, active worksheet size and complexity, and potential problems and tips.
2 - Auditor Check Errors command can locate problematic and difficult errors, like numbers and formulas formatted as text and formulas that omit adjacent cells.
3 - Iterative Auditing: automatically draws precedents and dependents arrows for selected cells. Each time you select another cell, new arrows are designed.
4 - Mark Blocks of Data : this set of commands colors worksheet cells according different options, providing users a simple way to detect potential errors.
5 - Select Cells By set of commands allows users to select or scroll cells and analyze formulas, precedents and dependents cells to check if there are errors.
6 - Reports provides users information about Workbook size, worksheet cells, its formats, comments and dependency references in a new formatted worksheet.
7 - Compare Worksheet command lets users compare the differences between two worksheets, even on different workbooks. This command is normally used to compare worksheets updated on various time periods, or to compare worksheets saved on different locations (e.g. worksheets saved on Hard Disk and Server locations).
|
