
Hidden rows and totals in financial models
Review hidden rows, filters and subtotals in Excel financial models. Use worked examples to find excluded costs, double counting and misleading report totals.
Read articleFinancial model guides
Practical explanations and worked examples for reviewing the Excel files behind forecasts, budgets and financial reports.
Choose your next step
Move from understanding Excel errors to checking the assumptions and logic behind the numbers.
Start with the signals in a saved workbook.
Follow references, assumptions and error handling.
Check the model beyond its saved Excel errors.

Review hidden rows, filters and subtotals in Excel financial models. Use worked examples to find excluded costs, double counting and misleading report totals.
Read article
Check dates and monthly timelines in Excel financial models. Find text dates, skipped periods and shifted cash flows with worked examples and review steps.
Read article
Investigate rounding differences in Excel financial models. Compare stored and displayed values, reconcile allocations and set an explained review tolerance.
Read article
Check Excel lookup errors in financial models. Use worked examples to find missing IDs, duplicate keys, approximate matches and hidden cost assumptions.
Read article
Check revenue forecasts in Excel with worked examples for volume, price, discounts, seasonality and collection timing, plus a practical review checklist.
Read article
Review capex and depreciation in Excel with a worked asset schedule, useful-life and start-date checks, and links between cash, profit and asset balances.
Read article
Check whether a financial model's balance sheet balances. Follow a worked Excel example through cash, debt, fixed assets and retained earnings.
Read article
Check receivables, inventory and payables in an Excel financial model. Use a worked example to trace working capital movements into the cash flow forecast.
Read article
Review a debt schedule in Excel with a worked example covering opening debt, new borrowing, repayments, interest and links to the cash flow forecast.
Read article
Check a financial model's cash flow with a worked example. Reconcile opening and closing cash, review payment timing and separate profit from cash receipts.
Read article
Review named ranges in an Excel financial model. Check their worksheet scope, source cells and period coverage with worked examples and a review checklist.
Read article
Test scenarios and sensitivities in a financial model with worked examples. Check that changed assumptions reach the intended profit and cash outputs.
Read article
See how IFERROR can hide missing costs, undefined margins and broken references in Excel financial models, with worked examples and safe review steps.
Read article
Use a practical checklist to hand over an Excel financial model: document assumptions, dependencies, input tests, review limits and the exact file version.
Read article
Investigate circular references in Excel financial models. Distinguish accidental loops from intentional debt-and-interest calculations before changing formulas.
Read article
Catch unit, sign and timing mistakes in Excel financial forecasts. Work through examples of currency scales, cash-flow signs, annual rates and period alignment.
Read article
Review formulas in a monthly Excel financial forecast. Use worked examples to check copied references, overwritten calculations and incomplete subtotal ranges.
Read article
Understand common Excel and financial model errors, from broken references and workbook links to cash-flow and balance-sheet checks that need manual review.
Read article
Review saved #DIV/0!, #REF! and #N/A errors in Excel financial models. Find the cause, inspect the formula and understand the limits of saved results.
Read article
Find and review links to other Excel workbooks in a financial model. Check the source and decide what to retain or change while preserving original formulas.
Read article
Review hardcoded numbers inside Excel financial model formulas. Use a worked example to distinguish changing assumptions from intentional numeric constants.
Read articleFrom reading to review
Run the supported saved-evidence checks, or explore the example report first. Excel is not recalculated.