MANAGERS STRATEGIC DECISION ANALYSIS WITH MICROSOFT EXCEL

Registrations are closed

Live-Online Training: N145,125
Classroom Training: N 220,375
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. 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. GRG Nonlinear
          2. Evolutionary

DAY TWO

  • Statistical Analysis that are Relevant to Business
    • Correlation
    • Covariance
    • Exponential Smoothing
    • Moving Average
    • Regression
    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
      1. What are KPIs
      2. Picking the right KPIs
      3. Numeral vs Text KPIs
  • Operational Dashboards
    1. Executive Dashboards
    2. Operational Dashboards
    3. Practical Scenarios
Date & Time
Monday
January 15, 2024
Start - 8:30 AM
Wednesday
January 17, 2024
End - 3:00 PM Africa/Lagos
Location

Tom Associates Training

5/7, Alade Lawal Street, Opposite Anthony Police Station, Off Ikorodu Road, Anthony Village,
NG-LA
Nigeria
+234 817 859 1654
+234 809 276 3968 | +234 810 365 2225
tomassociatestraining@yahoo.com | info@tomassociatesng.com
Get the direction
Organizer

Tom Associates Training

+234 817 859 1654
+234 809 276 3968 | +234 810 365 2225
tomassociatestraining@yahoo.com | info@tomassociatesng.com