Latest / ModeLoop: Financial Modelling in Excel

Absolute vs Relative References in Excel ($A$1 vs A1) for Financial Models (P2E3)
Absolute vs relative cell references ($A$1 vs A1) is the single most important Excel concept for financial modelling. Get it wrong and formulas break silently when you copy them across. This lecture covers relative, absolute and mixed references, the F4 shortcut and the golden rule of locking assumptions.
In this episode:
Relative references (A1) and when to use them
Absolute references ($A$1) for fixed assumptions
Mixed references ($A1 and A$1) for time-series models
The F4 shortcut to cycle reference types
Using mixed references in sensitivity tables
📖 Full blog post…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.