Financial model review guides for Excel users

These financial model review guides answer one question each, with the native Excel method first and the CalcoraSuite method second. Every native step was checked against Microsoft's own documentation on the date shown, and the sources are linked on the page.

The guides

  • How to audit a financial model in Excel

    To audit a financial model in Excel, use the Inquire tab: Workbook Analysis reports formulas, cells, ranges and warnings for the whole workbook. Then check hardcoded constants with Go To Special and trace the key totals with Trace Precedents. The findings still need a reviewer's judgement.

    Checked 16 November 2026 · 5 steps

  • How to compare two Excel workbooks

    To compare two Excel workbooks, open both, then use the Inquire tab and choose Compare Files. Spreadsheet Compare shows the differences cell by cell, colour-coded by kind, and can export the result. Microsoft documents it for Excel for Windows in Microsoft 365 Apps for enterprise plans.

    Checked 16 November 2026 · 5 steps

  • How to find hardcoded numbers in Excel

    To find hardcoded numbers in Excel, press Ctrl+G, choose Special, then select Constants and clear the text and logical options so only numbers are selected. Excel highlights every typed number in the range, which is where a review usually starts.

    Checked 16 November 2026 · 5 steps

  • How to link an Excel chart to PowerPoint

    To link an Excel chart to PowerPoint, copy the chart in Excel, paste it on the slide with Ctrl+V, then open Paste Options and choose Keep Source Formatting and Link Data. The chart stays tied to the workbook and updates when the source data changes.

    Checked 16 November 2026 · 5 steps

  • How to link Excel to Word

    To link Excel to Word, copy the range in Excel, paste it into Word with Ctrl+V, then open Paste Options and choose Link and Keep Source Formatting. The table stays tied to the worksheet and updates when the source data changes.

    Checked 16 November 2026 · 5 steps

  • How to trace dependents in Excel

    To trace dependents in Excel, select the cell and use Formulas, then Formula Auditing and Trace Dependents. Arrows point from your cell to every formula that reads it. Click again to go further. Excel beeps when every level is traced, or when the cell cannot be traced at all.

    Checked 16 November 2026 · 5 steps

  • How to trace precedents across sheets in Excel

    To trace precedents across sheets, select the formula cell, open Formulas, then Formula Auditing and click Trace Precedents. Arrows appear for references on the same sheet. For a reference on another sheet, double-click the black arrow to open the Go To dialog, then pick the reference.

    Checked 16 November 2026 · 6 steps

1 further guide is held back as a draft until its native steps can be verified; drafts are noindex and stay out of the sitemap.

See the method in the product

Each guide links to the feature it belongs to, and every feature page states its build status.