ExcelSmartTools Auditor

ExcelSmartTools Auditor
ExcelSmartTools DataClean was developed for helping users to edit, to correct and to clean spreadsheets, lists and reports importers from ERP (for instance AS400), web sites, and from other software packages

ExcelSmartTools Auditor ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets 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 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.


ExcelSmartTools Auditor

---

Auditor Quick Info provides users information about workbook properties, active worksheet size and complexity and potential problems and tips.

Auditor Check Errors command can locate some problematic and difficult errors, like numbers and formulas formatted as text and formulas that omit adjacent cells.

Iterative Auditing: automatically draws precedents and dependents arrows for selected cell. Each time you select another cell, new arrows are designed

Mark Blocks of Data: this set of commands colors worksheet cells according different options, providing users a simple way to detect potential error.

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.

Reports provides users information about Workbook size, worksheet cells, its formats, comments and dependency references in a new formatted worksheet.

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)

ExcelSmartTools Auditor Download Page

SQL Tester The SQL Tester is an interactive Query Tool (add-in) for retrieving data and displaying it on the screen in an ad hoc basis from almost all kinds...

Search From Office Productivity add-in that adds Internet search abilities to MS Office

Pages: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12)