XL-Addin: Workbook analyzer
XL-Addin offers two very useful tools for auditors, managers and
workbook owners to evaluate the complexity and the correctitude of
Excel workbooks: Workbook analyzer and Worksheets compare. The first tool very useful for auditing is the <Workbook analyzer>. It works like a spreadsheet auditing tool, with its data all available in comprehensive reports.
The unique features from workbook analyzer module allow auditors and managers to evaluate the performance and complexity of any workbook regardless workbook size, number of worksheets or code complexity. In a few seconds, a very complex evaluation report is automatically generated.
User could select the items to be included in the evaluation report; there are 14 options available:
1. Analyze code;
2. Formulas;
3. Data validation;
4. Links;
5. OLE objects;
6. Charts;
7. Defined names;
8. Errors;
9. Constants;
10. Conditional formatting;
11. Hyperlinks;
12. Shapes;
13. Pivots;
14. Comments;
Key benefits:
- Workbook analyzer; automatically generates a complete inventory of the analyzed workbook; identify all objects, shapes, pivots, charts, links (internal and external) and hyperlinks, formulas and constants and errors. All workbook properties, sheets elements and properties and all code elements could be added in evaluation report;
- The report is generated in Microsoft Excel, allowing user to process the results in a very easy way; the report could be generated also in HTML format. The charts and pivots automatically generated allow user to better understand the evaluation report and to build scores. The reports are simple to understand and simple to use. The report has hyperlinks to analyzed items allowing auditor/user to quickly navigate to each item.
- Very fast: the differences report is generated in seconds or minutes, not hours or days.
- Very easy to use: single form interface with all options in this form; almost all settings are already defined; with a few clicks of mouse the differences report is automatically generated. The report is very easy to follow, with a content sheet and links in each sheet to the content sheet.
- Fully customizable: user could select which items to be analyzed; for each item analyzed, one or more worksheets are created in the report; items with 0 records are excluded automatically from the report.
- The results are also consolidated by worksheets and by items.
- Very comprehensive code analyzer: complete statistics for procedures, declarations and modules; list all references
- The entire code is also included in analyze report into a single worksheet, allowing auditors/workbook owners to compare the code with old versions or identify the problems.
- Identify all formulas errors and allows auditors or workbook owner to correct the errors.