What you'll learn:
- You should learn practical tools for evaluating business strategies
- You should learn methods to quantify the business strategy decision
- You should learn tools for testing strategic scenarios
- You should learn how to use Quantitative Strategic Planning Matrix and SWOT analysis
- You should learn about Analytical Hierarchical Process in Excel
- You should learn how to use Monte-Carlo Simulations for business decisions in Excel
This course uniquely combines business strategy scenarios, metrics, advanced analytic approaches, and the simplicity of Excel examples for real-world applications.
The course covers Strategic Metrics, Strategic Scenarios, and Strategic Decision Models with downloadable examples in Excel. You should learn techniques and practical tools for selecting the most effective strategic option for your business. You should learn how to quantify your business strategy decision. You should learn how to test strategic scenarios for your business and test various market conditions. You should learn how to construct a Monte-Carlo model in Excel to predict business outcomes in uncertain environments. You should learn the most commonly used strategic metrics and the formulas behind them.
The course consists of 23 lectures + bonus, split into three chapters.
Chapter 1. Strategic Metrics
You should learn:
9 sets of commonly used strategic metrics
Monetary and non-monetary metrics classification
Formulas behind the strategic metrics
Business areas of use for each strategic metric
Chapter 2. Strategic Scenarios
You should learn:
3 fundamental business scenarios
Strategic approaches for each scenario
Strategic models for each strategic approach
Chapter 3. Strategic Decision Model
You should learn:
3 types of strategic decisions
Decision models for each type of strategic decision
Quantitative Strategic Planning Matrix and SWOT analysis
Analytical Hierarchical Process
Monte-Carlo Simulations
Downloadable Excel spreadsheet examples for each decision model
This course has downloadable Excel files with examples that you can use for practice.
