Overview

A typical model consists of several worksheets - Inputs, Revenues, Opex, Capex etc.

Imagine as well your model has three scenarios - Base, Upside and Downside which you can switch from and to on the Inputs sheet.

You set your model to Base scenario and start walking through it. At Capex sheet, you decide you want to look at it under the Upside scenario and wish there was a way to switch between scenarios on every worksheet.

The attached file explains how to do this.

Share
Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Dates and Timelines in Excel
128
2
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
Charts and Dashboards in Excel (full version)
246
0
The attached file: - defines key chart elements and explains how to edit them - demonstrates how to deal with…
Charts and Dashboards in Excel (short version)
254
25
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…
Analysing sensitivities with indifference curves (unlocked)
235
0
This is an unlocked version of the same utility published on my page. In this version you can access and…
Analysing sensitivities with indifference curves
238
23
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Predictive statistics in financial modeling
474
45
In this publication I will explain:   - how to build trends and why commonly used CAGR rarely gives reliable…
See All