skinny.

Latest / ModeLoop: Financial Modelling in Excel

P2E13: Named Ranges in Excel for Financial Models - Formulas That Read Like English

Named ranges in Excel for financial models turn cryptic cell coordinates into formulas that read like English: =CFADS/Debt_Service instead of =F45/$D$18. Easier to read, easier to audit and harder to break.

In this episode:

Three ways to create names, including Create from Selection (Ctrl+Shift+F3)

Where names earn their place: global inputs, drop-down lists, lookup tables and key outputs

Dynamic names with Excel Tables and spill ranges, and why to avoid volatile OFFSET

Cleaning up with the Name Manager: #REF! names, duplicates and hidden external links

📖 Full blog post…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.