Online Financial Modelling, Budgeting and Forecasting Course

Auditing a formula in financial models

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Another essential tool is the Formula Auditing tool. This tool allows you to see exactly where the formula comes from (or goes to!). We prefer it to the coloured boxes that appear when you click F2 or click in a cell because:

  • It can show you links to other sheets or spreadsheets (and you can go directly there)
  • You can just follow the line to the related cell instead of having to look in the formula bar
  • You can trawl through cells to find errors

To see the full course contents click here.

0 of 97 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop