Excel Analyzer

Excel Analyzer is an Excel add-in designed to assist users in reviewing and correcting spreadsheets. According to the vendor, it offers extensive formula analysis, error detection, and a comprehensive understanding of even the most complex Excel models. This software solution is intended for companies of all sizes, ranging from small businesses to large enterprises. It caters to professionals in various fields, including financial analysts, accountants, data analysts, business consultants, and auditors.

Key Features

Highlighting Unique Formulas: Excel Analyzer is said to highlight all unique formulas in a worksheet, aiding in the identification of inconsistencies when formulas differ from each other. This feature is intended to help users quickly understand how the worksheet was built and locate formulas that require attention.

Formulas Report: According to the vendor, Excel Analyzer generates a formula report that lists all unique formulas in the spreadsheet. The report is designed to assist users in detecting inconsistent formulas and provides a link for easy navigation and correction of formula issues. Each formula in the report is color-coded for improved readability.

ExcelAnalyzer Does Far More Than Just Checking Formulas: According to the vendor, Excel Analyzer goes beyond formula checking and aims to provide a comprehensive analysis of the spreadsheet. It examines various aspects of the spreadsheet, including formulas, VBA code, tables, pivot tables, charts, conditional formats, validation cells, names, hidden columns and rows, intersheet connections, comments, objects, hyperlinks, and more. This extensive analysis is intended to help users identify and mitigate potential risks in their Excel models.

Extensive Formula Analysis: Excel Analyzer is claimed to perform an extensive analysis of formulas in the spreadsheet, ensuring accuracy and identifying potential errors. According to the vendor, users can rely on this feature to validate formulas and ensure the integrity of their calculations.

Inconsistent Formulas: Excel Analyzer is designed to detect and highlight inconsistent formulas in the spreadsheet. This feature is intended to assist users in identifying formulas that may have been copied or entered incorrectly and require correction.

Formulas with Constants: According to the vendor, Excel Analyzer can identify formulas that contain constants, allowing users to review and validate these formulas.

Reporting all Excel errors: Excel Analyzer is said to report all errors found in the spreadsheet, providing users with a comprehensive overview of potential issues. This feature is intended to help users identify and rectify errors to ensure the accuracy of their data and calculations.

Intersheet and External Formulas: Excel Analyzer is claimed to scan the spreadsheet for intersheet and external formulas, assisting users in locating and validating these formulas.

Array Formulas: According to the vendor, Excel Analyzer can identify array formulas in the spreadsheet, enabling users to review and validate their usage.

Nested IF Formulas: Excel Analyzer is designed to detect and report nested IF formulas, making it easier for users to review and validate complex logic, as per the vendor's claims.