Auditing a spreadsheet can be made on a Cell-by-Cell basis or Group-by-Group Basis. The first requires users to check every cell, a lengthy and fault process.

The later requires users to analyze a group of colored cells indicating different type of data.

Microsoft Excel Audit tools 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 some 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 cell. 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 error.

5 - Select Cells By set of commands allows users to select or scroll cells and analyze formula, precedents and dependents cells to check if there are no 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).

ExcelSmart Tools Auditor

$35.00 Purchase Now