Highline Excel 2013 Class Video 06: Scenarios To Save Sets Of Formula Inputs, Paste Special Trick

Download workbook: people.highline...
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
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)

[@madhur2212]

This channel has been my go to ever since i started learning the very basics. It is absolutely the best and the explanations cannot be any better. A huge thanks to you!

[@excelisfun]

Glad to help, Madhu R!!!!

[@kamranb1369]

Amazing video Mike

[@excelisfun]

Glad you like it, K B!!!

[@ammylove123]

another helpful tutorial! thankyou exelisfun!

[@markmoscosa2371]

Thanks for the new trick man! Happy New Year 2016!

[@Luciano_mp]

Mais um vídeo sensacional, muito bom Mike, obrigado..

[@faizaashfaq9377]

Another great video...

[@hatimnoli]

Wow! amazing stuff. I was wondering have you created a playlist for "what if analysis"? If there is one please let me know. Thanks very much

[@aditya9873027697]

You are good!!

[@kamranb1369]

Hi Mike, when I run scenarios through the scenario manager they run fine. But when I added the scenario button on my QAT so that it is easier to run scenarios, it comes up. with popup message " Redefine scenario based on current cell values" Any idea what is causing this behaviour. It is happening both in office 365 & office 2016.

[@hazemali382]

♥