Excel What-If Analysis - Scenario Manager

preview_player
Показать описание
Scenario Manager is a What-if Analysis tool available in excel. It help us visualize how a change in values influences the outcome of the sheet. Generate a scenario summary report to easily compare different outcomes side by side to make better, more informed decisions.
#msexcel

00:00 Introduction
00:57 What is Scenario Manager?
01:16 Understanding the dataset
03:00 Creating Named Ranges
04:08 Creating Scenarios
08:00 Showing Scenarios
08:29 Creating a Scenario Summary Report

****************************************************************************
DOWNLOAD the presentation here:

****************************************************************************

GEAR I use:
► SCREEN RECORDER: Camtasia
► CAMERA: iPhone 11 Pro
► MICROPHONE: Blue Yeti
► LIGHTS: Neewer Tabletop Ring Light
► LIGHTS: Neewer Professional Photography Softbox
► SOFTWARE: Fuse App for IOS. Teleprompter App for IOS.
► THUMBNAIL DESIGN: Canva Pro.

****************************************************************************
Connect with me on social:

****************************************************************************
► This description DOES NOT contain any affiliate links.
Рекомендации по теме
Комментарии
Автор

Just came across this video. You explained this Excel feature so very well, probably the best explanation I have come across in some time. Thank you! I recently subscribed to your YouTube channel and I have to say that your instructions are so very well done. It is a joy to learn from your expertise!

douglasbrown
Автор

Two things that I wished you would have covered as well is the difference between the Summary vs. Pivot Table and also, if it is possible to re-arrange the Scenarios or if it is dependent on the order of creation. I Finally, I feel that this is an under utilized tool in Excel.

mwferg
Автор

Thank you so much❤ I am learning a lot from you🤩

SiminLotfjou-em