![tool data analysis excel 2007 tool data analysis excel 2007](https://helpdeskgeek.com/wp-content/pictures/2010/04/2-ExcelWhatIfAnalysisScenarioManager.png)
Scenario manager in Excel is a great tool when you need to do sensitivity analysis. Instantly a new tab is created with the summary of all the three scenarios. Also specify the Result cells (the cell where you have the output of this calculation B6 in this example) After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. In the Scenario Summary dialogue box, select Scenario Summary or Pivot Table (these are the 2 ways to show summary). Click Add-Ins, and then in the Manage box, select Excel Add-ins.Click on the Summary button in the Scenario Manager dialogue box.As you double click, the values would change based on that scenario.Īdditionally, you can also create a summary of all the scenarios. Once you have created all the scenarios, you can view the result from each of the scenarios by simply double-clicking on any of the scenarios. You can similarly follow these steps and create multiple scenarios (for example, Worst Case, Realistic, Best Case). This creates the Worst Case scenario for this data set. Click OK (Click on Add if you want to add another scenario).If you create names for each cell, that name is visible instead of the cell address: In the Scenario Values dialogue box, fill in the following values (since this is the worst case scenario, enter the values accordingly).This opens the Scenario Values dialogue box. Comment: Any comment you wish you add.Changing cells: $B$2,$B$3,$B$5 (you can also select it by pressing the CONTROL button and using mouse left-click).In the Add Scenario dialogue box, fill in the following details:.
![tool data analysis excel 2007 tool data analysis excel 2007](https://cdn.ablebits.com/_img-blog/excel-solver/excel-options.png)
In the Scenario Manager dialogue box, click on Add.Go to Data Tab –> Data Tools –> What-If Analysis –> Scenario Manager.But if you have 3 or variables that can change then scenario manager is the way to go. The idea is to see how this final result changes when we change these dependent variables.Īs shown in the first 2 articles of this series, if you only have one or two variables changing, you can create one variable or two-variable data table. Here is the formula I have used to calculate the profit: =B2*B3-B4-B5*B2 The Profit value is dependent on 3 variables – Sale Quantity, Price per Unit, and the Variable Cost per Unit. Suppose you have a dataset as shown below and you want to calculate the profit value: Scenario Manager in Excel can be the tool of choice when you have multiple variables, and you want to see the effect on the final result when these variables change.