Advanced Leadership and Management Science using MS Excel Training-Workshop | August 13 to 15, 2025 via ZOOM
Embedded Files
Description: Make data-driven decisions, optimize operations, and accurately forecast outcomes. Equip yourself with tools like linear programming, simulation, and regression to solve complex problems efficiently.
Day 1: Optimization and Decision Modeling
Day 1: Optimization and Decision Modeling
Introduction to Management Science and Excel’s Analytical Capabilities
Linear Programming (LP) using Excel Solver
Resource allocation models
Production scheduling
Integer and Binary Programming
Investment decisions
Capital budgeting
Goal Programming for Multi-objective Decision Making
Sensitivity Analysis and Scenario Manager
Day 2: Forecasting and Predictive Models
Day 2: Forecasting and Predictive Models
Time Series Forecasting Techniques
Moving average
Exponential smoothing
Trend and Seasonal Models
Using Excel’s Forecast Sheet
Regression Analysis in Excel
Simple and multiple regression
Interpreting R² and coefficients
Correlation and Covariance Analysis
Data Validation and Cleaning for Forecasting
Decision Trees using Excel
Day 3: Risk Analysis and Simulation
Day 3: Risk Analysis and Simulation
Payoff tables
Expected Value of Perfect Information (EVPI)
Introduction to Monte Carlo Simulation using Excel (with or without add-ins)
Random variable generation
Profit risk modeling
Scenario Analysis with What-If Tools
Using Data Tables for Risk Comparison
Basic VBA for Automating Models
Page updated
Google Sites
Report abuse