In this course lesson we introduce a few ideas and thoughts about how to switch sections of a model on and off, building in flexibility.
The big mistake we’ve seen people make is building individual If formulas into cells or lines in a model. That means every cell that could be on or off contains an If formula. That adds to complexity and the potential for error.
In this lesson we make sure you know how to construct those switches a little more simply and effectively and that you’re firmly in advanced modelling territory.
We also suggest that good modelling practice would have you centralising any switches and placing them in a really obvious place in your model, most commonly in a line along the top of a key tab.
What we’re trying to build here is a model that can be flexed/ switched on or off in as simple a manner as possible – so we’ve got a few clues for you about that.
Model switches are sometimes given the jargon term “timing flags” so that’s what our lesson on model switching is all about.
Take the Excel formulas course
This course covers all the most important Excel formulas you need for financial modelling – for free.