Decision Modeling with Spreadsheets
Master the art of data-driven decision-making using spreadsheets: build, analyze, and optimize models for real-world business challenges.
...
Share
Fundamentals of Decision Modeling and Spreadsheet Essentials
Unit 1: Introduction to Decision Modeling
What is DM?
DM in Business
Key Model Components
Model Building Process
Examples of DM Models
Unit 2: Spreadsheet Essentials for Decision Modeling
Basic Functions
Logical Functions
Lookup Functions
Data Formatting
Data Validation
Building Deterministic Decision Models
Unit 1: Introduction to Decision Modeling
What is DM?
DM with Spreadsheets
Building Blocks
Formulating Models
Model Assumptions
Unit 2: Linear Programming Models
Intro to LP
LP Formulation
Solver Setup
Interpreting Results
LP Example
Unit 3: Sensitivity Analysis and What-If Scenarios
Sensitivity Analysis
Sensitivity Reports
What-If Analysis
Scenario Manager
Goal Seek
Incorporating Uncertainty and Risk Analysis
Unit 1: Understanding Uncertainty in Decision Models
Sources of Uncertainty
Quantifying Uncertainty
Probabilistic Thinking
Sensitivity Analysis
Scenario Analysis
Unit 2: Using Probability Distributions
Discrete Distributions
Continuous Distributions
Distribution Fitting
Correlated Variables
Custom Distributions
Unit 3: Monte Carlo Simulation
Monte Carlo Intro
Building the Model
Running Simulation
Analyzing Results
Validating the Model
Unit 4: Risk Analysis and Decision Making
Risk Metrics
Decision Trees
Optimization
Real Options Analysis
Communicating Results
Advanced Decision Modeling Techniques and Applications
Unit 1: Multi-Criteria Decision Making
Intro to MCDM
Weighting Criteria
Pairwise Comparison
Scoring Alternatives
Calculating Overall Scores
Unit 2: Time Value of Money
TVM Principles
Present Value
Future Value
Net Present Value
Internal Rate of Return
Communicating Model Results and Real-World Applications
Unit 1: Visualizing Model Outputs
Chart Selection Basics
Creating Charts in Excel
Advanced Charting
Interactive Dashboards
Effective Chart Design
Unit 2: Presenting and Documenting Decision Models
Structuring Presentations
Effective Slide Design
Delivering Presentations
Documenting Models
Report Writing