Decision Modeling and Risk Analysis with Excel

Decision Modeling and Risk Analysis with Excel, available at $89.99, has an average rating of 4.55, with 40 lectures, 6 quizzes, based on 2462 reviews, and has 8408 subscribers.

You will learn about 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 This course is ideal for individuals who are Entrepreneurs who wants to grow their businesses or People who want to learn more about Excel or Anyone who wants to analyze the uncertainties before making decisions or People who what to learn more about data analysis and modeling or People who what to learn more about statistics It is particularly useful for Entrepreneurs who wants to grow their businesses or People who want to learn more about Excel or Anyone who wants to analyze the uncertainties before making decisions or People who what to learn more about data analysis and modeling or People who what to learn more about statistics.

Enroll now: Decision Modeling and Risk Analysis with Excel

Summary

Title: Decision Modeling and Risk Analysis with Excel

Price: $89.99

Average Rating: 4.55

Number of Lectures: 40

Number of Quizzes: 6

Number of Published Lectures: 40

Number of Published Quizzes: 6

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 49

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Excel Essentials – Advanced Functions, What-if Analysis, Sensitivity Analysis

Lecture 1: Section Overview: Excel Basics

Lecture 2: Organize Your Data – VLOOKUP V.S. INDEX&MATCH

Lecture 3: Organize Your Data – INDEX&MATCH over VLOOKUP!

Lecture 4: Organize Your Data – SUMPRODUCT (& exercise answer)

Lecture 5: Organize Your Data – SUMIF(S), AVERAGEIF(S), COUNTIF(S)

Lecture 6: Organize Your Data – Pivot Table

Lecture 7: Data Analysis & Solver – Goal Seek

Lecture 8: Data Analysis & Solver – Solver

Lecture 9: Data Analysis & Solver – Data Table

Lecture 10: Sensitivity Analysis – Tornado Chart (no add-in)

Lecture 11: Sensitivity Analysis – Tornado Chart (with add-in)

Lecture 12: Sensitivity Analysis – Solver Sensitivity Report

Chapter 3: Decision Tree Modeling in Excel – Value of Information, Utility Theory

Lecture 1: Section Overview: Decision Tree in Excel

Lecture 2: Decision Tree Add-in Installation

Lecture 3: Decision Tree Basics

Lecture 4: Introduction – Case study: Rainbow in a cup

Lecture 5: VOI – Value of Information Basics

Lecture 6: VOI – Value of Perfect Information

Lecture 7: VOI – Value of Imperfect Information – Flipped Probability (Bayes' Theorem)

Lecture 8: VOI – Value of Imperfect Information – Flipped Probability (Tree Flipping)

Lecture 9: Utility Theory

Lecture 10: Exponential Utility Function

Lecture 11: Utility Theory in Decision Tree

Lecture 12: Introduction – Case study: Magic Beans

Chapter 4: Monte Carlo Simulation in Excel – Statistics, Decision Optimization, Correlation

Lecture 1: Section Overview: Monte Carlo Simulation in Excel

Lecture 2: Statistics Mini Series – Density & Cumulative Functions (PDF&CDF)

Lecture 3: Statistics Mini Series – Normal Distribution ad Confidence Interval

Lecture 4: Statistics Mini Serie – Standard Normal Distribution

Lecture 5: Statistics Mini Series – Stochastic Dominance

Lecture 6: Statistics Mini Series – Central Limit Theorem & First Simulation with XLRisk

Lecture 7: Statistics Mini Series – 8 Common Probability Distributions and Histogram

Lecture 8: Simulation Basics – Monte Carlo Simulation Theory (Overbooking Example)

Lecture 9: Simulation Basics – Monte Carlo Simulation without Add-in (Overbooking Example)

Lecture 10: Simulation Basics – Monte Carlo Simulation with XLRisk (Overbooking Example)

Lecture 11: Optimal Decision in Simulation (XLRisk) – Hiring Decision (Exercise Answer)

Lecture 12: Optimal Decision in Simulation (XLRisk) – Solver & Stochastic Dominance

Lecture 13: Optimal Decision in Simulation (XLRisk) – Utility Theory (Hiring Decision)

Lecture 14: Correlation in Simulation (XLRisk) – What is Correlation?

Lecture 15: Correlation in Simulation (XLRisk) – Hiring Decision Revisit

Instructors

Gancheng Sun
Excel Modeling Instructor

Rating Distribution

1 stars: 15 votes
2 stars: 23 votes
3 stars: 182 votes
4 stars: 816 votes
5 stars: 1428 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu