Excel Scenario Manager

Please sign up for the course before starting the lesson.

The Excel scenario manager allows you to store multiple scenarios and switch them on and off when required. It is ideal when you have entirely different cases (e.g. optimistic, realistic and pessimistic) that involve changing a number of variables.

So in the mini model below, we have a purchase of equipment but we can't agree on the key inputs. We can run multiple scenarios based on our assumptions or the offers made by various suppliers.

excel-scenario-manager

To see the full course contents click here.

Back to: Online Financial Modelling, Budgeting and Forecasting Course > Running What Ifs