Overview
Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it
Learn what-if scenario analysis techniques in Excel through this comprehensive video playlist covering essential methods for saving and managing different sets of formula inputs. Master the fundamentals of creating scenarios to test various business assumptions, explore advanced applications including cash flow and NPV calculations for financial analysis, and discover practical tricks like using Paste Special for scenario management. Gain hands-on experience building budgets with multiple scenarios, generating detailed scenario reports for comparison purposes, and customizing your Excel interface by adding scenario buttons to the Quick Access Toolbar or Ribbon for improved workflow efficiency.
Syllabus
Highline Excel 2013 Class Video 06: Scenarios To Save Sets Of Formula Inputs, Paste Special Trick
Slaying Excel Dragons Book #18: What If and Scenario Analysis in Excel
ACCTG 455: Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations
Excel Magic Trick 680: Add A Scenario Button To Toolbar or Ribbon Excel 2010
Highline Excel Class 22: Budgets, Scenarios & Scenarios Report
Taught by
ExcelIsFun