Course curriculum
-
1
Introduction
-
Course introduction
FREE PREVIEW -
Course objectives
-
Downloadable files
-
Scenario analysis vs sensitivity analysis
FREE PREVIEW -
Interactive exercise 1
FREE PREVIEW
-
-
2
Scenario Analysis
-
Why perform scenario analysis?
-
Model layout and overview
FREE PREVIEW -
Designing the structure for scenarios
-
Creating switch for live case
-
Using CHOOSE function to build scenarios
-
Testing and analyzing the scenarios
FREE PREVIEW -
Preparing for sensitivity analysis
-
Interactive exercise 2
-
-
3
Sensitivity Analysis - Model Integration
-
Why perform sensitivity analysis?
-
Overview of integration methods
FREE PREVIEW -
Direct method
FREE PREVIEW -
Setting up the data table
-
Linking the data table
-
Indirect method
-
Setting up the data tables
-
Linking the data tables
-
Interactive exercise 3
-
-
4
Sensitivity Analysis - Analyzing & Presenting Results
-
Analyzing results
-
Gravity sort overview
-
Gravity sort linkup
FREE PREVIEW -
Tornado chart overview
-
Tornado chart linkup
-
Presenting results
-
Interactive exercise 4
-
-
5
Completed Model
-
Sensitivity analysis wrap up
-
Download completed sensitivity model
-
Summary
FREE PREVIEW
-
-
6
Qualified Assessment
-
Qualified assessment
-
Scenario & Sensitivity Analysis in Excel course evaluation
-