Dealing with time: An introduction to flags
To model anything, we have to answer two central questions: "How much?" and "When?"
Kenny Whitelaw-Jones
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