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
- Scenario Manager
- Goal Seek
- Data Table
- Solver
- Setting the business objective
- Knowing whether to use minimize (e.g for cost)
- Knowing whether to use maximize (e.g. profit)
- Knowing whether to set a specific value (e.g. target)
- Setting the decision parameters and constraints
- Choosing the solution method
i. Simplex Linear program solution method
ii. Nonlinear program solution method
- GRG Nonlinear
- Evolutionary
DAY TWO
- Statistical Analysis that are Relevant to Business
- Correlation
- Covariance
- Exponential Smoothing
- Moving Average
- Regression
- Reading a Regression analysis result
- Knowing whether the result is useable or not
- Real business examples and solution
DAY THREE
- Data for Business Strategy
- Understanding the value of Data
- Big Data vs Small Data
- Using data to build strategy
- KPIs and Balanced Scorecards
- What are KPIs
- Picking the right KPIs
- Numeral vs Text KPIs
- Operational Dashboards
- Executive Dashboards
- Operational Dashboards
- Practical Scenarios