• 1 year ago
Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.

In this video lesson, we will learn about Scenario Manager for What-If Analysis in Microsoft Excel

You can access the entire Microsoft Excel Course in the following playlist:
https://www.dailymotion.com/playlist/xa9hywmicrosoft

Category

📚
Learning
Transcript
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

Recommended