Course curriculum

  • 1

    Introduction

    • Course introduction

    • Course objectives

    • Downloadable files

    • Scenario analysis vs sensitivity analysis

    • Interactive exercise 1

  • 2

    Scenario Analysis

    • Why perform scenario analysis?

    • Model layout and overview

    • Designing the structure for scenarios

    • Creating switch for live case

    • Using CHOOSE function to build scenarios

    • Testing and analyzing the scenarios

    • Preparing for sensitivity analysis

    • Interactive exercise 2

  • 3

    Sensitivity Analysis - Model Integration

    • Why perform sensitivity analysis?

    • Overview of integration methods

    • Direct method

    • 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

    • Tornado chart overview

    • Tornado chart linkup

    • Presenting results

    • Interactive exercise 4

  • 5

    Completed Model

    • Sensitivity analysis wrap up

    • Download completed sensitivity model

    • Summary

  • 6

    Qualified Assessment

    • Qualified assessment

    • Share Your Feedback

    • Course Completion