Scenarios To Save Sets Of Formula Inputs, Paste Special Trick

Topics: Formula Elements, Formula Types and Cell References, Assumption Tables/Formula Elements, and Scenario Manager

 

 

Topics in this video:
1. What If Analysis (00:15 min)
2. Add Formula Inputs As A Scenario using Scenario Manager (01:10 min)
3. Alt keyboard for Scenario Manager: Alt, T, E (02:29 min)
4. Budget Paste Special Trick : Paste Special Operations and Values to increase all percentages in Budget by 10% (03:25 min)
5. Add Scenario button to Quick Access Toolbar (QAT) (04:55 min)

Questions