Excel Forum

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

Got a Question? Ask it Here in the Forum.