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
drive.google.com/file/d/1Ed5E...
* 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
chrismenardtraining.com/Files...
#msexcel #scenariomanager #excelscenariomanager #excelwhatifanalysis #chrismenardtraining
Websites:
Chris Menard's website: chrismenardtraining.com
Cristian's KZitem Channel: / @graphicious
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZitem keyword search - TubeBuddy - 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
Пікірлер: 14