Two excellent tools in Excel to conveniently perform scenario analysis are Option Buttons and the WhatIf Scenario Manager Scenario analysis in Excel involves switching different sets of input values into the same set of formulas to compare the differences in outcome The classic example is the Best CaseExpected CaseWorst Case set of scenariosScenario manager in Excel is a great tool when you need to do sensitivity analysis You can create the summary report in excel instantly to compare one plan with the other and decide the best alternative plan to get a better outcome Scenario Manager in Excel Example #2 Take the below data and create new scenariosA Scenario is a set of values that Excel saves and can substitute automatically on your worksheet You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results
Excel What If Analysis How To Use The Scenario Manager
