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

[Eric-dkhl]

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!

[brendanfish]

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.

[pravin]

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

[danicequeabeah]

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

[angeloa.paladinoiii]

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!

[TheWinswill]

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

[ashleyingraham]

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

[ankitkumarsingh]

thank you for this lesson. it was very helpfull

[raya]

Thanks Bob, keep posting more videos!

[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.

[masifhossain]

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

[akharits]

This is very helpful, thank you so much.

[milansharma]

thanx perfectly worked for my 10th
IT practical

[robinfoster]

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!

[bano]

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

[praveenvasudevan]

Thanks, Bob for the nice simple explanation.

[sarfrazalibhanbhro]

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

[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.

[ridhozulfikar]

thanks, this is better than courses who i paid

[crax]

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.