Use Excel scenarios to see what happens if ...
An Excel tutorial by Peter Kalmstrom
When
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.
A
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.
|