skinny.

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…

Log in to save or queue this episode.

The skinny

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