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

Office 365 from Scratch cover SharePoint Online from Scratch cover SharePoint Online Exercises cover
SharePoint Workflows from Scratch cover Excel 2016 from Scratch cover SharePoint Flows from Scratch cover

Always the latest news in the kalmstrom.com blog

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

Products Buy FAQ Services Tips Services Books Contact About Us Blog

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved