Excel - Scenario Manager / What-if Analysis

Excel's Scenario Manager is part of What-if Analysis in Excel. It is on the Data tab. The Scenario Manager allows you to easily save and substitute values on your worksheet. This is a huge time saver. Instead of creating different worksheets or cell ranges, you keep the initial data and just substitute scenarios. I use this for budgeting and forecasting, and in this video, I'll use a Loan Amortization worksheet. One great advantage of the Scenario Manager is I can create a Summary worksheet with the Scenario Manager. All my relevant cells and data end up on one worksheet.

Screenshot of where the Scenario Manager is located in Excel
https://drive.google.com/file/d/1Ed5EYgjriJwL25i1OhmOsyjdCCnMk4G-/view?usp=drivesdk

* Base-case: Your most realistic estimate of what will happen (my original data)
* Best-case: Scenarios that are more optimistic but less probable
* Worst-case: Scenarios that are more pessimistic but less probable

Chapters:
0:00 Intro
0:35 Loan amortization template
1:30 House loan
2:55 Input & dependent cells
4:10 Add Scenarios
6:50 Show scenarios
8:10 Summary worksheet

In this specific video example, I use a loan amortization schedule template from Microsoft. I use scenario manager to look at the different loan amounts for a house, at different interest rates, and terms in years (15 years fixed vs. 30 years fixed).

File Download location
https://chrismenardtraining.com/Files/DownloadFile.aspx?FUID=312bf3dc-ea7c-4fe1-9248-36bb4ba4f9cd

#msexcel #scenariomanager #excelscenariomanager #excelwhatifanalysis #chrismenardtraining
Websites:
Chris Menard's website: https://chrismenardtraining.com
Cristian's YouTube Channel: https://www.youtube.com/channel/UCvn7oUZPytubATC8Sx_DXOw

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Видео Excel - Scenario Manager / What-if Analysis канала Chris Menard