Excel Analyzer

ExcelAnalyzer is an add-in for Microsoft Excel that reviews workbooks for mistakes and risky constructions. It appears as an extra button in the Excel ribbon and replaces manual cell-by-cell checking. It is made by the company behind the Spreadsheet Software site, which also offers two companion tools.

Features

• Error scanning: finds formula errors, hardcoded values inside formulas and inconsistent formulas across a sheet.
• Link and structure checks: lists links between sheets and to external files, plus hidden columns, rows and tabs.
• Visual model review: maps how formulas relate so a modeller can explain a workbook to a colleague.
• ExcelCompare: a sister add-in that compares two workbooks and reports differences in formulas, values and text.
• ExcelScenario: a sister add-in for what-if and scenario analysis on chosen variables.

Clients

The maker says its add-ins are used by professionals in finance, healthcare, technology and education, including those who build or audit Excel models.

Key facts

• Platform: Microsoft Excel add-in
• Trial: a ten-day trial is offered
• Related tools: ExcelCompare and ExcelScenario