Decision Modeling and Risk Analysis with Excel
- Offered byUDEMY
Decision Modeling and Risk Analysis with Excel at UDEMY Overview
Duration | 6 hours |
Total fee | ₹399 |
Mode of learning | Online |
Credential | Certificate |
Decision Modeling and Risk Analysis with Excel at UDEMY Highlights
- 30-Day Money-Back Guarantee
- Certificate of completion
- Full lifetime access
- Learn from 96 downloadable resources and 2 articles
Decision Modeling and Risk Analysis with Excel at UDEMY Course details
- 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
- 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!
Decision Modeling and Risk Analysis with Excel at UDEMY Curriculum
Introduction
Introduction
Excel Essentials - Advanced Functions, What-if Analysis, Sensitivity Analysis
Section Overview: Excel Basics
Organize Your Data - VLOOKUP V.S. INDEX&MATCH
Organize Your Data - INDEX&MATCH over VLOOKUP!
Organize Your Data - SUMPRODUCT (& exercise answer)
Organize Your Data - SUMIF(S), AVERAGEIF(S), COUNTIF(S)
Organize Your Data - Pivot Table
Organize Your Data
Data Analysis & Solver - Goal Seek
Data Analysis & Solver - Solver
Data Analysis & Solver - Data Table
Data Analysis Toolpak
Sensitivity Analysis - Tornado Chart (no add-in)
Sensitivity Analysis - Tornado Chart (with add-in)
Case study: FGC Income Statement
Sensitivity Analysis - Solver Sensitivity Report
Decision Tree Modeling in Excel - Value of Information, Utility Theory
Section Overview: Decision Tree in Excel
Decision Tree Add-in Installation
Decision Tree Basics
Introduction - Case study: Rainbow in a cup
VOI - Value of Information Basics
Perfect and Imperfect Information
VOI - Value of Perfect Information
VOI - Value of Imperfect Information - Flipped Probability (Bayes' Theorem)
VOI: Bayes' Theorem
VOI - Value of Imperfect Information - Flipped Probability (Tree Flipping)
Case study: Rainbow in a cup
Utility Theory
Exponential Utility Function
Utility Theory
Utility Theory in Decision Tree
Introduction - Case study: Magic Beans
Case study: Magic Beans
Monte Carlo Simulation in Excel - Statistics, Decision Optimization, Correlation
Section Overview: Monte Carlo Simulation in Excel
Statistics Mini Series - Density & Cumulative Functions (PDF&CDF)
Statistics Mini Series - Normal Distribution ad Confidence Interval
Statistics Mini Serie - Standard Normal Distribution
Statistics Mini Series - Stochastic Dominance
Statistics Mini Series - Central Limit Theorem & First Simulation with XLRisk
Statistics Mini Series - 8 Common Probability Distributions and Histogram
Statistics Mini Series
Simulation Basics - Monte Carlo Simulation Theory (Overbooking Example)
Simulation Basics - Monte Carlo Simulation without Add-in (Overbooking Example)
Simulation Basics - Monte Carlo Simulation with XLRisk (Overbooking Example)
Optimal Decision in Simulation (XLRisk) - Hiring Decision (Exercise Answer)
Optimal Decision in Simulation (XLRisk) - Solver & Stochastic Dominance
Optimal Decision in Simulation (XLRisk) - Utility Theory (Hiring Decision)
Correlation in Simulation (XLRisk) - What is Correlation?
Correlation in Simulation (XLRisk) - Hiring Decision Revisit
Decision Modeling and Risk Analysis with Excel at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?