Scenario Analysis in Financial Modeling || What-if Analysis in Excel
This video describes how to create scenarios in Excel using the built-in scenario manager and formulas. The formula approach makes use of data validation and the combo box (commonly used for financial modelling).
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Content
00:00 Intro
00:49 Financial modeling and scenarios
02:16 Combo box approach
05:21 Data validation approach
06:21 Scenario manager
Connect with me on:
👉Instagram / youexceltutorials
👉Facebook / youexceltutorials
👉Twitter / youexceltutor
👉 TikTok / youexceltutor
👉LinkedIn / bunmi-sanusi
🎬Check these playlists:
Index-Match (Vertical & Wildcard match) • Vertical & Wildcard Match: XLOOKUP ||...
Index-Match (Multiple criteria) • Multiple Criteria: XLOOKUP || INDEX/M...
Index-Match • XLOOKUP || INDEX/ MATCH || INDEX/ XMA...
🔽Download the file here https://docs.google.com/spreadsheets/...
📢” God-of-the-Angel-Armies said then and says now: “‘Treat one another justly. Love your neighbors. Be compassionate with each other.” Zechariah 7:9 (MSG)
#msexcel, #scenarioanalysis, #financialmodeling, #youexceltutorials,
Watch video Scenario Analysis in Financial Modeling || What-if Analysis in Excel online without registration, duration hours minute second in high quality. This video was added by user YouExcel Tutorials 09 January 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,796 once and liked it 54 people.