From the Scenario Manager dialogue box, click the Summary button to see the following dialogue box:.From the What if Analysis menu, click Scenario Manager.On the Data Tools panel, click What if Analysis.Locate the Data Tools panel (Forecast panel in Excel 2016).To create a report from your scenarios, do the following: How to Create a Report from a ScenarioĪnother thing you can do with a scenario is create a report. So a Scenario offers you different ways to view a set of figures, and allows you to switch between them quite easily. The first values will be displayed!Ĭlick the Close button on the dialogue box when you're done. The image below shows what it looks like in the spreadsheet:Ĭlick on the Original Budget to highlight it. The values in your spreadsheet will change, and the new budget will be calculated. With Budget Two selected, click the Show button at the bottom. This time, you'll have two scenarios to view:Īs you can see, we have our Original Budget, and Budget Two. Click OK and you'll be taken back to the Scenario Manager. Enter the same ones as in the image below: This time, we do want to change the values. You will be taken to the Scenario Values dialogue box again. The Changing Cells area should already say B7:B9. Type a new Name, something like Budget Two. You'll get the Add Scenario dialogue box back up. This is where we'll enter some new values - our savings.Ĭlick the Add button again. Now that we have one scenario set up, we can add a second one. You will be taken back to the Scenario Manager box. We don't want any values to change in this first scenario, so just click OK. So in the Changing Cells box, enter B7:B9ĭon't forget to include the colon in the middle! But your Add Scenario box should look like this:Ĭlick OK and Excel will ask you for some values: These are in cells B7 to B9 in our spreadsheet. Let's try to reduce the Food bill, the Clothes Bill, and the Phone bill. But we still need to specify which cells will be changing. In this first scenario, nothing will be changing (because it's our original). Call it Original Budget.Įxcel now needs you to enter which cells in your spreadsheet will be changing. First, type a Name for your Scenario in the Scenario Name box. The J22 in the image is just whatever cell you had selected when you brought up the dialogue boxes. You'll then get another dialogue box popping up: When you click Scenario Manager, you should the following dialogue box: Click on the What if Analysis item, and select Scenario Manager from the menu:.On the Data menu, locate the Data Tools panel (Forecast panel in Excel 2016).From the top of Excel click the Data menu.We'll create a scenario to see what effect the various budgets cuts have. With only 46 pounds spending money left each month, clearly some changes have to be made. The figure in D13 is how much you have left after you deduct all your debts. The figure in D3 is how much you have to spend each month (not a lot!). The figure in B12 above is just a SUM function, and is your total debts (=SUM(B3:B10). We'll see how they work now, as we tackle a family budget. You can then make changes to individual amounts, like food, clothes, or fuel, and see how these changes effect your overall budget. For example, What if I reduce the amount I'm spending on food? How much will I have left then? Scenarios can be saved, so that you can apply them with a quick click of the mouse.Īn example of a scenario you might want to create is a family budget. They are similar to tables in that you are changing values to get new results. Scenarios come under the heading of "What-If Analysis" in Excel.