MANAGERS STRATEGIC DECISION ANALYSIS WITH MICROSOFT EXCEL

Live-Online Training: N210,000
Classroom Training: N280,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount

(Available also for Customised Training by Duration, Venue & Fee)

Course Contents

DAY ONE

• Decision Analysis
• • Making the best decision by simulating the results in Excel
  • Modelling your business problem in Excel
  • What-If Analysis

1. 1. 1. 1. Scenario Manager
         2. Goal Seek
         3. Data Table

• Solver

• • Setting the business objective

1. Knowing whether to use minimize (e.g for cost)
2. Knowing whether to use maximize (e.g. profit)
3. Knowing whether to set a specific value (e.g. target)
4. Setting the decision parameters and constraints
5. Choosing the solution method

                i.  Simplex Linear program solution method

                ii.  Nonlinear program solution method

1. 1. 1. 1. 1. GRG Nonlinear
            2. Evolutionary

DAY TWO

• Statistical Analysis that are Relevant to Business
• • Correlation
  • Covariance
  • Exponential Smoothing
  • Moving Average
  • Regression

1. 1. Reading a Regression analysis result
   2. Knowing whether the result is useable or not

• • Real business examples and solution

DAY THREE

• Data for Business Strategy
• 1. Understanding the value of Data
  2. Big Data vs Small Data
  3. Using data to build strategy
  4. KPIs and Balanced Scorecards
  5. 1. What are KPIs
     2. Picking the right KPIs
     3. Numeral vs Text KPIs
• Operational Dashboards

1. 1. Executive Dashboards
   2. Operational Dashboards
   3. Practical Scenarios