Home >Tips >Excel Scenarios kalmstrom.com site map icon Site map  

Use Excel scenarios to see what happens if ...

An Excel tutorial by Peter Kalmstrom

Excel iconWhen 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.

What-If-Analysis buttonA 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.

Excel recommended charts


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.

Also refer to the kalmstrom.com blog post about Excel scenarios




Learn more



---------------------------------------------------------------------------------------







Always the latest news in the kalmstrom.com blog



Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!