Decision Modeling and Risk Analysis with Excel

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

Ratings 4.57 / 5.00
Decision Modeling and Risk Analysis with Excel

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

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 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

TAKE THIS COURSE

Tags

  • Data Analysis
  • Decision Making
  • Excel Modeling
  • Statistical Modeling

Subscribers

6593

Lectures

40

TAKE THIS COURSE



Related Courses