Excel What-If Analysis: How to Use the Scenario Manager

[@Eric-dk6hl]

Wow i’ve learned more in 13 mins from this video than I have in 4 classes of a college course. My professor loves making us learn by reading a book, I cannot learn that way. Thank you for this video!

[@brendanfish7622]

Good explaination. Thank you. You can name cells so that when you are in the scenario manager it doesn't just say Cell B4 etc. Select the cell you want to name and to the left of the formula bar highlight the cell number present in the box and type in your value. No spaces. Must use underscores etc.

[@milansharma7914]

thanx perfectly worked for my 10th IT practical

[@TheWinswill]

I have spent many videos to understand but to be very honest, this is "the best" explained video. Thanks a ton!

[@pravin8419]

The way you broke down 'Scenario' to is components is simply brilliant. Great video. Thanks.

[@sao_rav]

There is a way to add labels. Select the columns containing item name and values and then Go to "Formulas" and look out for "Create from Selection" beside Name Manager. Job done.

[@DomJLva]

Indeed atleast someone knows.

[@zunnunmishri5585]

Ctrl+Shift+F3 to create name from selection

[@robinfoster1608]

Your video is so helpful, I'm certifying (Excel Expert) and had no idea these functions, facets, etc in Excel existed. I will make use of this later on when I'm done with several other certificates and ready to return to work for a better position. Thank you so much for your video!

[@akramathamnia4540]

Good evening Robin, I just saw this video and read your comment which called out to me. I also wish to pass MOS Expert Excel 2016 but I do not know where to begin nor if this certification is difficult. Could you enlighten me on this?

[@ridhozulfikar4175]

thanks, this is better than courses who i paid

[@angeloa.paladinoiii1827]

Thank you very much for creating this video Good Sir. I am currently an graduate student in an MSRED program and am working on my capstone project, which looks at real estate development cycles across different economic conditions, this let me compare easily and made a clean chart for the presentation!

[@alfredwuhk]

Very Helpful Demo

[@lmcastellvi]

Well explained: Two improvements: if you name your scenario cells with meaningful EXCEL NAMES such as TOTAL_REVENUE, the panel becomes more readable. Dynamic computation should also be explained.

[@papaasare8366]

This is very important to share it as thanks for sharing

[@jayasreecarey7843]

Thanks, Very Informative !

[@praveenvasudevan997]

Thanks, Bob for the nice simple explanation.

[@slayersaurabh]

Thanks your teaching method is clear

[@bano7398]

Thanks a lot this really helped me with one of my assignments.

[@lameiraangelo]

5:00 Excel can show you the names, if you first "Define the names" for the cells you want to change, under "Formula / Define Name", then you will see the name of the cell that you want to change the value.

[@sarfrazalibhanbhro8796]

Wowww! It was a really great lecture. So easily Explained. Thank you so much!

[@jenniferdelacruz1570]

Great video! Thank you! :-)

[@brahimeljaidi6229]

Hello to all; I thank you for your clarity it is really very rich I am a student and I am working on my final year project, I am working on the opportunity of adopting "economic xx" policies in a context of crisis. I seek through this subject to study on the one hand the performance of these policies and on the other hand predict its adoption in Morocco I would like to know, can I use this method of waht if style to analyze the said subject? I would like to know if I can use this waht if method to analyze the subject? I need your help Thank you very much for you and for all

[@jumanarimawi1332]

I really love it simple and helpful!

[@vinayazzie4409]

Very cool, good job of explaining. My reading material sucks. It does not explain nothing and it doesn't even go with my assignments. Which makes it very confusing. Thank you.

[@Mr.RobertsonCABT]

I'm wondering if this could be close-captioned? I'd love to use this in my classroom!

[@envatotuts]

There is closed captioning - just click the CC button in the video player. Hope that's helpful.

[@Mr.RobertsonCABT]

@@envatotuts Thanks for the reply! Auto-captioning is not accurate enough to be in compliance with accessibility law, and therefore cannot be shared in my California community college coursework. If accurate captions are ever added, please let me know, my students and I would greatly appreciate it 😊

[@envatotuts]

@@Mr.RobertsonCABT Interesting. We do add captions to all our longer courses and we are working towards captioning everything. Thanks for letting us know.

[@katheineyoung8647]

Really useful, but Carl+～doesn’t work , when I press these two screen swift to another window

[@salahaddin2009]

Just a suggestion, if you select the values adjacent to the figures aswell scenario manager will let you define them as labels so no need to guess from cell b4 what it is. I.e ticket 1,000 select both cells which contain description and amount.

[@Wicklonious]

about the problem of xl showing the cell instead of the label mentioned at 6 min, that is fixed by defining a name for the cell

[@masifhossain9656]

Thank you. This is going to help me in a course assignment.

[@cra7x]

Hey, great video, you can actually give name to the input parameters by using Named ranges before creating the Scenarios; just posting this in case someone find it useful.

[@bm-ye1jj]

Better then my professor

[@rockywoof7475]

Is there a way to have this scenario summary dynamic where i can change the inputs of numbers?

[@martinpinto3214]

Is there a way to put multiple values in a changing cell??

[@longjohnsilverin2468]

Thanks, it was of use.

[@abigaildavis5068]

I've got a large budgeting workbook with multiple sheets to help me evaluate the effectiveness of marketing activities. All of these sheets pull data from an Assumptions sheet. I wanted to have multiple scenarios for my assumptions and be able to switch between them and then go to the other sheets to see results -- so not a summary and not a pivot table. Is that possible?

[@dsulvadarius]

Double thumbs up!

[@mohammedasadi]

Great lesson, thanks man!

[@kirant9305]

We can select the description along with the values and then go to "Formulas" - Create from the selection so that the names are automatically defined...

[@raya2705]

Thanks Bob, keep posting more videos!

[@Berghiker]

Just what I was looking for. Thanks.

[@northernerland8419]

what ef analysis, in northern erland

[@danicequeabeah7856]

Thank you very much for this epic video. It's a whole new lesson for me and I understood every step.

[@ashleyingraham7477]

Excellent video, thank you for helping me create an interactive and educational lesson for my students!

[@marksummers463]

Reasonably good vid but would have preferred a simpler example.

[@ahmedadly6066]

I cant see the added value from it ? I can do this manually in less time , so can you explain more what is the benefit of it , great tutorial btw

[@grzesiekmalanowski6834]

Interesting lesson. Thank you very much. But dont you think that keeping all the scenarios in separate sheet (similar to Scenario Summary) and refere to them based on some cell value (eg. Scenario: [1-5]) would give you similar effect but a bit more controll and flexibility?>

[@slwarm]

Name the cells with the values so that the changing cells in the Scenario Summary will show the cell names rather than cell locations.

[@akharits47]

This is very helpful, thank you so much.

[@quliang7955]

i am interested in how did you make the “DYMO Label“ on top of the menu bar...what do you do with it ?

[@michaelboerman2851]

It is a plug in to support DYMO label printers. Has no purpose outside of those printers.

[@ankitkumarsingh8016]

thank you for this lesson. it was very helpfull

[@Rok_Piletic]

You have to name cells so names could appear in the solution (scenario summary): kzbin.info/www/bejne/p17Fm2yNgMqcmNU

[@samuelmeende2325]

Thanks for the link. it really helped me

[@gabrielabrahampuliran7345]

Thanks, mate! Really useful. :p

[@WafaPRO]

That was really easy, tnx

[@irenemurimi6657]

Thank You very much!!! God Bless

[@drallisimo34]

cool tutorial!!!

[@kppphd]

Thanks for the demonstration. Could you also explain how to do the same with panel data (i.e. variables are running over many years)?

[@watef7286]

Wat ef anilyses

[@pachibling4156]

great

[@dymesmimi]

Thank-you!

[@schymi841]

It seems to me that Scenario Manager is completely unnecessary tool... Or maybe I'm missing something. But as the author said at the end of the video, you could just input those values in seperate columns and have the same result. I don't think that limited space on the sheet would stop you from doing that. You can always hide and unhide the extra columns if you need to.

[@Rose9427]

super sir ....

[@rashedrwaished5681]

thank you

[@gepzene1]

Unfortunately this tool can only handle 32 cells total

[@RBAFleet]

thenks , god bless

[@saidabdullahi1077]

great.

[@YouGotPropofol]

Excel has so many built in features, but the implementation is horrible. I mean, that scroll down list of 1-5 that remains 1-5 when you scroll down, that is a HUGE flaw and will most likely never get fixed. The thing with Excel is it has not polish, which speaks volumes as to who is behind the design and organization of Excel.

[@servermyself1354]

I always always contemplate bad scenarios like if I was Vader or so and so I would of did things differently

[@cv5330]

Thank you