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…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.