 Sometimes you want to be able to show someone the results of your what-if analysis and you can do that using a tool called scenario manager. I've set up some scenarios here one two and three and in those scenarios we're going to change the selling price R the demand D and the amount he buys Q to these different values and one of the things you need to do to make your report really look as good as it should is to use the name manager to name these cells. You can click on a cell and type in a name in this name box up there. I prefer to use the define name tool and here it looks in an adjacent cell for a text value in this case it sees selling price R. Note that it does not allow you to have spaces so it puts an underscore there. I like to only put my names on one page or one worksheet so I'm going to select my scenario worksheet here and click okay. So now I've named that and if you look at name manager here you can see I've named the other four components that we want to show up in the scenario manager. So let's look at scenario manager. Here's our scenarios we go to data what if analysis again scenario manager and we need to add a scenario. I've already set up two and three here but I'll show you how you add it. I'm going to click on add the name in this case is one and I'm going to get rid of those cells. The changing cells we're going to change R D and Q so I want to click on R which is B5. Now because these other two cells are not adjacent I can't drag that down but what I can do is just go down to the other cell hold down the control key and it click and it adds that cell. I'll go down to the Q cell control click and it adds that cell as well and click okay. Now it asks me what prices what values are in each of those cells so I'm going to put in 15 cents 0.15 and then it's 3800 and 3900 and I click okay. Now I've got these scenarios set up and we can show the results. I'm going to click on scenario three there and click on show and it changes over here and you can see the values. If I click on one and click on show it automatically changes everything for me and I can look at the changes on my profit and click on show again and I can see those values. Now I can use something called a summary report to capture these scenarios in one place and it's really easy to do. We go back to data what if analysis scenario manager again and I just if I've got these set up I can just click summary and it asks me which results cell am I interested in. It is in my profit cell B17 and I just click okay to get the scenario summary. We're not going to talk about the pivot table report in this course. I'm going to click okay and it inserts my summary report. You can see with the name cells it makes it very easy to read there. These are the three scenarios it's out of order because I entered the first scenario last but it shows the values and it shows the profit. Obviously there's a bust. You can see that instead of 20 cents I entered $20 and that's the reason the profit jumped up to $77,000. So anyway that's how to use scenario summary manager and hopefully you won't make a type of when you enter your values.