How we write keyboard shortcuts
A quick guide to notation
Topic
Financial Modelling Handbook
How to build a three statement financial model from scratch.
The importance of keyboard shortcuts
Our conscious cognitive bandwidth is narrower than we think.
The benefits of working in manual calculation mode.
There are good reasons not to stick to the Excel default calculation mode.
Three quick changes in your Excel environment that will make you a more productive modeller.
I'm sure you're keen to get into the real meat of model building. However, it's worth taking 20 seconds to change a couple of the default settings in Excel, which are not helpful for modellers.
1 Maximise screen real estate.
Control+F1 will hide
The power of checklists in financial modelling
Checklists are an excellent way of ensuring that we don't forget anything. They are especially helpful when we're in a rush or stressed.
Using a start model
How to get started quickly without building everything from scratch
Output sheet structure
The Output sheet is the most useful sheet in the financial model.
Using a Standard Monetary Unit
Ensuring unit consitency througout the model
Managing inputs - Part 4: Input sheet mechanics
Using the INDEX function to acheive case selection
Managing inputs - Part 3: Running scenarios
Running a scenario involves changing some but not all the base case assumptions.