00:00so over here you can see that I have this particular table right here where the price
00:10is 100 quantity is 50 as you can see and total sales is 5,000 but based on different scenarios
00:17I may want different prices let's say for example for particular services in that case I can go
00:24ahead and change around these let's say for example data right here as I want but I may have certain
00:32data set that I want right here that I can choose from in that case I can actually go ahead and
00:38utilize something called the scenario manager in what if analysis so to do that I need to go around
00:46over here onto data and then go to what if analysis and here you can see that scenario manager is an
00:53option so I can go ahead right here let's say for example select these two cells right here
00:58go to a scenario manager right here and click on add once you do that you can see that I can give
01:05a scenario name let's say for example I can go ahead and say like this is the base price let's say for
01:11example and press ok so this is 150 so let's just go ahead and add it right here just like this
01:17so now this is what you have so 150 is already there let me just go ahead and add in another
01:24one add in let's say for example uh base and I'm going to say medium right here press ok for medium
01:31let's say for example it is going to be the price is going to be 200 for 75 quantity right here just
01:39like this and then I'm going to add in a premium as well so let's just go around over here and say
01:45premium right here and for this one let's say it's going to be 500 for let's say for example
01:5230 quantity right here just like this so now what I can actually do is click on premium click on show
01:58and then the scenario changes out go around over here and show and the scenario changes out go around
02:04over here and show and scenario changes out so as I were to close the scenario and if I were to go again
02:11it is still there as you can see so I can access it whenever I want and I can choose a particular
02:16scenario click on show and the particular data right here will change out accordingly as you can
02:23see so that is how you can go ahead and utilize some scenario manager in what if analysis inside of
02:31microsoft excel so hope you found this video useful be sure to hit the like button don't forget to share
02:38this out with your friends and family and for more contents like these do follow simple tutorials