Before an important decision is made, all available information should be comprehensively considered. This includes simulating a number of different scenarios, if possible with actual numbers. Creating and adjusting these scenarios doesn’t have to be time-consuming and complicated. In this Special Topic we will introduce the scenario manager, an Excel tool that lets you save different groups of values as scenarios and then switch between these scenarios in order to compare the outcomes instantly. We would like to show you exactly how this is done.

Published on: 09.04.2019

To acces the videos for this Special Topic you must have subscribed to Excel !


Excel 2016

Working with Scenarios:  
"Best case","Worst case" and "Base case". Use scenarios to run certain calculations within different starting values and to compare the results. (6 Min.)



Excel 2013

Working with Scenarios:  
"Best case","Worst case" and "Base case". Use scenarios to run certain calculations within different starting values and to compare the results. (6 Min.)



Excel 2010

Working with Scenarios:  
"Best case","Worst case" and "Base case". Use scenarios to run certain calculations within different starting values and to compare the results. (6 Min.)



Excel 2007

Working with Scenarios:  
"Best case","Worst case" and "Base case". Use scenarios to run certain calculations within different starting values and to compare the results. (6 Min.)