Why we use placeholders

Building a financial model is not a linear process.

How to navigate using links

We're about to jack up your modelling superpowers another notch.

What makes a poor row label

Clear labelling equals clear thinking. Clear thinking equals clear labelling.

Using the pyramid structure in calculation blocks

Listing the constants in your calculation block first is cleaner and easier to read.

Calculation blocks: Part 2

Calculation block components

Calculation blocks: Part 1

Why we use calculation blocks

How to navigate around your model

Keyboard shortcuts for efficient model navigation

How to ensure all worksheets have a consistent structure

Using a "Template sheet" in your model saves time when creating new sheet

Hiding unused columns at the end of the timeline

This gives a hard stop when copying across the timeline

Model structure 2: Worksheet level

Each column should have a purpose. That purpose should be the same across the workbook.