Excel for Decision Making Course Syllabus
Introduction 0:11:26
| Introduction to Decision Making Under Uncertainty | 0:02:31 | |
| Introducing Excel Tools for Sessions | 0:08:55 |
Session 1: Simulations0:33:02
| 1.01 | Dice Simulation | 0:05:40 |
| 1.02 | Uniform Simulation | 0:04:12 |
| 1.03 | Discrete Simulation | 0:06:53 |
| 1.04 | Normal Simulation | 0:05:46 |
| 1.05 | Business Plan Case Study Part 1 | 0:05:21 |
| 1.06 | Business Plan Case Study Part 2 | 0:05:10 |
Session 2: Tree Plan 0:18:55
| 2.00 | Introduction to Decision Trees | 0:02:59 |
| 2.01 | Tree Plan Case 1 | 0:07:40 |
| 2.02 | Tree Plan Case 2 | 0:03:14 |
| 2.03 | Tree Plan Case 3 | 0:07:40 |
Session 3: Forecasting 1:10:12
| 3.01 | Introduction to Forecasting | 0:02:08 |
| 3.02 | Moving Average | 0:04:12 |
| 3.03 | Exponential Smoothing | 0:06:38 |
| 3.04 | Forecasting with Trend Lines | 0:07:31 |
| 3.05 | Forecasting Using the Data Analysis Tool | 0:08:33 |
| 3.06 | Forecasting Apartment Prices Case Study | 0:15:24 |
| 3.07 | Forecasting Practice Question 1 Answers | 0:06:34 |
| 3.08 | Forecasting Practice Question 2 Answers | 0:04:28 |
| 3.09 | Forecasting Cyclical Data - Coca Cola | 0:07:40 |
| 3.10 | Cyclical Data Practice Question Answer | 0:07:04 |