560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Using Scenarios in Microsoft Excel
Part two of a two-part series of blogs
Scenarios are incredibly useful when performing "what-if analysis". They allow you to quickly swap a range of input values to test different possibilities without having to retype any values. Read on to find out how they work!
Once you have created scenarios in a worksheet you'll want to be able to view them. This part of the series explains how to switch between different scenarios and how to modify a toolbar to create a quick way to do this.
The standard way to view a scenario is to use the Scenario Manager dialog box. To do this:
Use this dialog box to view different scenarios. The numbered steps are described below.
When you click the Show button the input cells will change to the values saved in the selected scenario.
The only downside to the above method of viewing scenarios is that you must have the Scenario Manager dialog box open in order to do it. A more convenient solution is to add the Scenario tool to one of the toolbars. To do this:
The image shown here is taken from Excel 2010, but you can do the same thing in Excel 2007.
Follow the numbered steps as described below.
Once you've added the Scenario tool to the toolbar you can use it to switch between different scenarios.
Click the Scenario tool to see a list of available scenarios and then click on the one you want to see.
Rather than viewing one scenario at a time, you might want to see a side-by-side comparison of the scenarios in a sheet. To do this:
You should be looking at the now-familiar Scenario Manager dialog box.
Use this dialog box to set up the summary report. The numbered steps are described below.
A scenario summary report. The advantage of using range names is again quite obvious!
The summary report will appear on a separate worksheet and show a side-by-side comparison of the scenarios. The values in the summary are not linked to any other values, so if you change anything on the original worksheet you'll need to run the summary report again.
|Parts of this blog|
Some other pages relevant to the above blogs include:
25 Aytoun Street