Excel - AI Audit
AI Audit automatically reviews your Excel spreadsheets for errors, inconsistencies, and best practices. Catch issues before they become problems.
Overview
Financial models and data spreadsheets can contain hidden errors that are difficult to spot manually. AI Audit scans your workbook and highlights potential issues with actionable recommendations.
What AI Audit Checks
- Formula errors - #REF, #VALUE, circular references
- Inconsistent formulas - Formulas that break patterns in a range
- Hardcoded values - Numbers embedded in formulas that should be references
- Formatting inconsistencies - Mixed number formats, date formats
- Data validation - Values outside expected ranges
- Best practices - Naming conventions, structure recommendations
How to Use
Running an Audit
- Open your workbook - The workbook you want to audit
- Open Arclen - Click the Arclen button in the ribbon
- Select audit type - Choose full audit or specific checks
- Run audit - Click "Start Audit"
- Review findings - Navigate through issues in the panel
Understanding Results
Audit findings are categorized by severity:
Errors that will cause incorrect calculations or broken references
Potential issues that may indicate problems or inconsistencies
Suggestions for best practices and improvements
Audit Types
Full Audit
Comprehensive review of the entire workbook. Best for final review before sharing or after major changes.
Quick Check
Fast scan for critical issues only. Useful for regular check-ins during development.
Custom Audit
Select specific checks to run. Ideal when you know what you're looking for.
Fixing Issues
For each finding, you can:
- Navigate - Click to jump to the cell
- Auto-fix - Apply suggested fix (when available)
- Ignore - Mark as intentional (won't flag again)
- Learn more - See detailed explanation of the issue