Guides to auditing Excel models.
Honest, step-by-step guides. Native Excel first, then the faster way with Formula Audit XL.
How to Audit a Financial Model in Excel
How to audit a financial model in Excel, step by step: circular references, errors, precedent tracing, external links, consistency and version checks.
Read the pillar guideHow to Find Circular References in Excel
How to find, fix and remove a circular reference in Excel: the Error Checking menu, the status bar, trace arrows, iterative calculation and a free finder.
Trace Dependents in Excel: Shortcut & Other Sheets
Trace dependents in Excel in one click or with Alt+M,D. See every formula that uses a cell, follow dotted arrows to other sheets; Ctrl+] jumps on-sheet.
Trace Precedents in Excel: Location & Shortcut
Trace Precedents sits on Formulas > Formula Auditing (Alt+M,P). See which cells feed a formula, follow arrows to other sheets, and jump with Ctrl+[.
How to Break External Links in Excel
Break external links in Excel with Data > Edit Links, then find the hidden links it misses: names, charts, data validation and conditional formats.
Excel Formula Auditing: Complete Guide
Excel formula auditing: Trace Precedents and Dependents, Show Formulas, Evaluate Formula, Error Checking and a workflow for large financial models.
How to Show All Formulas in Excel
How to show all formulas in Excel with Ctrl+` or the Formulas ribbon: printing formulas, spotting hardcodes and the limits of formula view on big models.
How to Find Errors in Excel Spreadsheets
How to find errors in Excel with Error Checking, Show Formulas and Evaluate Formula: #REF!, #DIV/0!, #VALUE!, and the logical errors that show no code.
Inconsistent Formula in Excel: Meaning & How to Fix
The green-triangle inconsistent formula warning means a cell differs from its neighbours. Check, fix or ignore it, and scan a whole model with an add-in.
Excel Trace Dependents & Precedents Shortcuts
The Excel shortcut to trace dependents is Alt+M,D and to trace precedents Alt+M,P. Ctrl+] and Ctrl+[ jump to the cells; Alt+M,A,A clears the arrows.
Enable Iterative Calculation in Excel
Turn on iterative calculation in Excel for Windows and Mac, set Maximum Iterations and Maximum Change, and learn when a circular model is safe to run.
Stop eyeballing models. Start auditing them.
For Microsoft Excel on Windows, Mac and the web · No data leaves your machine