v2.1.1
Excel CAAT Logo

Excel CAAT

Professional Audit Tools for Microsoft Excel

Download manifest.xml

📊 Data Profiling

Instantly analyze column statistics: Total, Count, Min, Max, Average, Median, Quartiles, and Data Type validation.

🔍 Find Duplicates

Quickly identify and list duplicate values in any selected range to ensure data integrity. Sort by value or frequency.

📉 Benford's Law

Detect anomalies in financial data using 1-3 digit analysis with automatic deviation highlighting and visual charts.

⛓️ Gap Analysis

Find missing sequential numbers (e.g., missing invoice numbers) in your datasets.

📉 Stratify Data

Analyze data distribution using Equal Intervals, Pareto (80/20) Analysis, or Custom Cut-offs to identify material items and anomalies.

How to Install

  1. Download the manifest.xml file using the button above.
  2. Windows: Copy the file to %LOCALAPPDATA%\Microsoft\Office\16.0\Wef\
  3. Mac: Copy the file to ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef/
  4. Excel Online: Go to Insert > Office Add-ins > Upload My Add-in and select the file.
  5. Restart Excel and look for Excel CAAT in the "My Add-ins" tab.