Home

All courses

Decision Modeling and Risk Analysis with Excel

Excel Modeling

Business

Business Analytics & Intelligence

Decision Modeling and Risk Analysis with Excel

Decision making using sensitivity analysis, decision tree, utility theory, Bayesian statistics, Monte Carlo simulation.

4.6

(3061)

10947 enrolled on this course

Last updated 11/2021

Gancheng Sun

₹ 3499.0

₹ 4999.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

We all have one thing in common – we don’t know what will happen tomorrow. Living together in this world full of uncertainties, some decisions are rather difficult to make:
I want to save some money for my future, but how should I allocate my investment?
I want to invest a lot in this new product, but will the market react to it well enough, to justify my investment?
I want to hire more employees, or increase my production, but what if the market demand drops?
The global pandemic has not ended, should I buy that cheap plane ticket?
This course will give you directions at these crossroads. We will use sensitivity analysis, decision tree, and Monte Carlo simulation to better understand this uncertain world, and ourselves.
Even better, we can achieve all of these in Excel, and you don’t need to be an advanced Excel user to benefit from this course. We will start from the basics, and go from zero to hero!
This course is for anyone who wants to make informed decisions, or just wants to learn more about Excel, or statistics in general. After this course, you will be well-equipped to use Excel to help you tackle real-world puzzles!
Who this course is for:
Entrepreneurs who wants to grow their businesses
People who want to learn more about Excel
Anyone who wants to analyze the uncertainties before making decisions
People who what to learn more about data analysis and modeling
People who what to learn more about statistics

What you'll learn

Excel

Uncertainty Modeling

Decision Analysis

Data Analysis

Goal Seek

VLOOKUP

Pivot Table

Data Analysis Toolpak

Solver

Sensitivity Analysis

Tornado Chart

Treeplan

Decision Tree

Value of Information

Monte Carlo Simulation

XLRisk

Utility Theory

Utility Function

Exponential Utility Function

Statistics

Central Limit Theorem

Probability Distribution

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction

2-Excel Essentials - Advanced Functions, What-if Analysis, Sensitivity Analysis

2.1-Section Overview: Excel Basics

2.2-Organize Your Data - VLOOKUP V.S. INDEX&MATCH

2.3-Organize Your Data - INDEX&MATCH over VLOOKUP!

2.4-Organize Your Data - SUMPRODUCT (& exercise answer)

2.5-Organize Your Data - SUMIF(S), AVERAGEIF(S), COUNTIF(S)

2.6-Organize Your Data - Pivot Table

2.7-Organize Your Data

2.8-Data Analysis & Solver - Goal Seek

2.9-Data Analysis & Solver - Solver

2.10-Data Analysis & Solver - Data Table

2.11-Data Analysis Toolpak

2.12-Sensitivity Analysis - Tornado Chart (no add-in)

2.13-Sensitivity Analysis - Tornado Chart (with add-in)

2.14-Case study: FGC Income Statement

2.15-Sensitivity Analysis - Solver Sensitivity Report

3-Decision Tree Modeling in Excel - Value of Information, Utility Theory

3.1-Section Overview: Decision Tree in Excel

3.2-Decision Tree Add-in Installation

3.3-Decision Tree Basics

3.4-Introduction - Case study: Rainbow in a cup

3.5-VOI - Value of Information Basics

3.6-Perfect and Imperfect Information

3.7-VOI - Value of Perfect Information

3.8-VOI - Value of Imperfect Information - Flipped Probability (Bayes' Theorem)

3.9-VOI: Bayes' Theorem

3.10-VOI - Value of Imperfect Information - Flipped Probability (Tree Flipping)

3.11-Case study: Rainbow in a cup

3.12-Utility Theory

3.13-Exponential Utility Function

3.14-Utility Theory

3.15-Utility Theory in Decision Tree

3.16-Introduction - Case study: Magic Beans

3.17-Case study: Magic Beans

4-Monte Carlo Simulation in Excel - Statistics, Decision Optimization, Correlation

4.1-Section Overview: Monte Carlo Simulation in Excel

4.2-Statistics Mini Series - Density & Cumulative Functions (PDF&CDF)

4.3-Statistics Mini Series - Normal Distribution ad Confidence Interval

4.4-Statistics Mini Serie - Standard Normal Distribution

4.5-Statistics Mini Series - Stochastic Dominance

4.6-Statistics Mini Series - Central Limit Theorem & First Simulation with XLRisk

4.7-Statistics Mini Series - 8 Common Probability Distributions and Histogram

4.8-Statistics Mini Series

4.9-Simulation Basics - Monte Carlo Simulation Theory (Overbooking Example)

4.10-Simulation Basics - Monte Carlo Simulation without Add-in (Overbooking Example)

4.11-Simulation Basics - Monte Carlo Simulation with XLRisk (Overbooking Example)

4.12-Optimal Decision in Simulation (XLRisk) - Hiring Decision (Exercise Answer)

4.13-Optimal Decision in Simulation (XLRisk) - Solver & Stochastic Dominance

4.14-Optimal Decision in Simulation (XLRisk) - Utility Theory (Hiring Decision)

4.15-Correlation in Simulation (XLRisk) - What is Correlation?

4.16-Correlation in Simulation (XLRisk) - Hiring Decision Revisit

Course Categories

Popular Courses

Decision Modeling and Risk Analysis with Excel

Description

What you'll learn

Requirements

Course Content

You May Like