What You’ll Learn

📊 Module 1 – Foundations of Business Analytics & Excel Modeling

• Introduction to management science methods
• Spreadsheet modeling fundamentals
• Building your first mathematical model for business decision-making

📌 Includes: 3 videos, 6 readings, 1 assignment, 1 discussion prompt

📈 Module 2 – Advanced Excel Techniques for Business Modeling

• Review of essential and advanced Excel functions
• Data structuring & visualization for analysis
• Using Excel tools for real-world business challenges

📌 Includes: 2 videos, 5 readings, 4 assignments, 1 discussion prompt

📉 Module 3 – Regression Analysis & Predictive Modeling

• Curve fitting & regression analysis for estimating relationships between variables
• Choosing the right regression models
• Defending models with mathematical analysis

📌 Includes: 2 videos, 6 readings, 5 assignments, 1 discussion prompt

⚙️ Module 4 – Linear Programming & Optimization Techniques

• Introduction to spreadsheet optimization & linear programming (LP)
• Applications in labor scheduling, finance, inventory management, and transportation
• Modeling real-world business problems in Excel using LP

📌 Includes: 4 videos, 7 readings, 5 assignments, 1 discussion prompt

🚚 Module 5 – Transportation & Assignment Problem Solving

• Optimizing supply chain and logistics using linear programming
• Assigning resources, staff, and equipment efficiently
• Using Solver to develop cost-effective solutions

📌 Includes: 4 videos, 4 readings, 3 assignments, 1 discussion prompt

🔢 Module 6 – Integer, Binary & Nonlinear Programming

• Integer & binary programming for real-world business constraints
• Nonlinear models for advanced business problem-solving
• Real-world applications of advanced Excel models

📌 Includes: 5 videos, 10 readings, 5 assignments

Why Take This Training?

✅ Develop real-world analytics skills that can be applied directly at Standard Berkeley Limited ✅ Master Excel modeling for complex business decision-making ✅ Optimize operations & solve business problems using data-driven frameworks ✅ Gain an edge in industries like banking, airlines, and tech where analytics drive success

Program Details

📍 Duration: 8 Weeks  
📍 Mode: Online & In-person (Hybrid)  
📍 Investment: Shs.300,000