Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

What If Scenario Analysis in Excel

ExcelIsFun via YouTube

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

Reviews

Start your review of What If Scenario Analysis in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.