Use Excel scenarios to see what happens if ...
An Excel tutorial by Peter Kalmstrom
you are doing calculations in Excel you often want to know how results will
change when you change certain variables. Excel can display the outcome of
different scenarios and we recommend using the What-If feature to smoothly
change variables and show the results.
Different scenarios can be caculated by making copies of worksheets and changing
the figures on each one of them, but if you have more than 2–3 scenarios
there is a better option.
more powerful way of creating and displaying scenarios is the Scenario
Manager, which is reach from the "What-If-Analysis" button under the Data
tab in the Excel ribbon.
When you use the Scenario Manager you can keep all scenarios on the same worksheet
and quickly select different scenarios and look
at various options.
In the demo below Peter Kalmstrom demonstrates how the Scenario Manager works,
and he also shows the "copy worksheet" method.
Peter uses Excel 2013 for his demo, but the Scenario Manager is present in
earlier versions too.