Highline Excel Class 22: Budgets, Scenarios & Scenarios Report

Create a Budget with Formula Inputs in an assumption area and formulas. Then do what if analysis by saving and showing scenarios. Save Variables for a Budget with Scenario Manager. Create Scenario Report based on a Result cell. Add Scenarios button to the Quick Access Toolbar QAT.
See other What If Analysis videos:
Excel Magic Trick 253: Data Table 1 Variable What If Analysis
Excel Magic Trick # 254: Data Table Creates 100 Formulas
Excel Magic Trick 255: Data Table 2 Variable What If Analysis
YTLE#103: Excel Goal Seek
Highline Excel Class 22: Scenarios & Scenarios Report
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Science & Technology

Tags:

• Excel
• Scenario
• Scenarios
• Report
• Result
• cell
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[aman1245singh]

Thanks again for the video. God bless you sir. :)

[ExcelIsFun]

You are welcome!

[erikmarius]

Another great educational vid! Have you thought about posting some about Oracle Crystal Ball? best

[ExcelIsFun]

I do not know Oracle Crystal Ball. Sorry.

[ExcelIsFun]

You are a smart Exceler - baby einstein - a wise Exceler! Yes, using your imagination to put the puzzle together is the key. It is also what makes Excel so much fun!

[chinchonchinchon]

@ExcelIsFun

Dear Mike, I guess I'm a baby einstein cause I can understand Mixed cell references much better now, almost no mistakes when I try them. Thanks for your wonderful lessons!

I find that the hardest thing, for me at least is how to use all we already know and to put together the "puzzle". Sometimes the solution is simple yet difficult to find. Imagination is a great asset to work with excel.

have a good night! :-)

[ExcelIsFun]

Shift + F11

[google2com]

what's the short cut for adding a tab again? thanks

[ExcelIsFun]

You are welcome!

[rmg101081]

i love u! You really make this fun and veeeerry easy to understand. You are by far the best excel teacher on youtube! Thank u for doing this. ::::appreciating::::