How this course will be organized? 
 
How to deal with Blurry image 
 
How to reach additional resources 
 
How to find information and ask questions 
 
Why we have decided to create this course
 
 
Basic tools - Introduction 
 
What you can use the bottom-up approach 
 
Estimating the costs of a wedding - case introduction 
 
Estimating the costs of a wedding - partial solution 
 
Estimating the costs of a wedding - Excel Part 1 
 
Estimating the costs of a wedding - Excel Part 2 
 
Average salaries in other department – Case Introduction 
 
Average salaries in other department – Solution 
 
Average salaries in other department – Excel Basic 
 
Average salaries in other department – Excel Go Seek function 
 
Top-down approach used in Business 
 
Chicken Producer - Top-down approach - Introduction 
 
Chicken Producer - Top-down approach - Tips how to do it 
 
Chicken Producer - Top-down approach - Solution 
 
When can I retire - introduction 
 
When can I retire – No passive income – Excel Basic 
 
When can I retire – No passive income – Go seek function 
 
When can I retire – With passive income 
 
Backward logic based decisions – Case Introduction 
 
Backward logic based decisions – Solution 
 
Backward logic based decisions – When it makes sense to use it 
 
Reading skills – Introduction 
 
Reading skills – End year 
 
Reading skills – By weeks result 
 
Issue tree - introduction 
 
Issue tree – Overview of case studies 
 
Issue tree example for a FMCG firm 
 
Issue tree for John's flat – Introduction 
 
Issue tree for John's flat – Solution 
 
Benchmarks – external and internal 
 
Low hanging fruits used in Business 
 
Quick wins for cost reduction 
 
Quick wins for cost reduction – Remarks on Pontetial Savings 
 
Quick wins in Drugstore – Case Introduction 
 
Quick wins in Drugstore – Cost Structure 
 
Quick wins in Drugstore – Cost Reduction 
 
Quick wins in Drugstore – Summary 
 
KPIs and business drivers – Introduction 
 
KPIs for cinema – case to be solved 
 
KPIs for cinema – solution 
 
KPIs for cinema – Power Point 
 
KPIs for marketplace – Problem 
 
KPIs for marketplace – Solution 
 
KPIs for marketplace – Alternative Solution 
 
Examples of SaaS businesses 
 
Personal KPIs – Introduction 
 
Personal KPIs – Solution Part 1 
 
Personal KPIs – Solution Part 2 
 
Rent or buy a house – Introduction 
 
Rent or buy a house – Rentig cost 
 
Rent or buy a house – The loan 
 
Rent or buy a house – Buying the apartment 
 
Rent or buy a house – Comparison 
 
Make it or buy it – Introduction 
 
Delegating some work to others – Case Introduction 
 
Delegating some work to others – Analysis of activities 
 
Delegating some work to others – Summary 
 
Make-or-buy courses - case introduction 
 
Make-or-buy course - Make option 
 
Make-or-buy course - Buy option 
 
Make-or-buy course - Comparison 
 
Make it or buy it – When to make even if it is more expensive
 
 
How to expand the brand – Introduction 
 
How to expand the brand – Solution – Part 1 
 
How to expand the brand – Solution – Part 2 
 
Rankings used to select the potential targets for M&A 
 
Milk Producer – Selecting Targets – Case Introduction 
 
Milk Producer – Selecting Targets – Available Data 
 
Milk Producer – Selecting Targets – Ranking Creation 
 
Milk Producer – Selecting Targets – Ranking Analysis 
 
Milk Producer – Selecting Targets – Threshold Analysis 
 
Milk Producer – Selecting Targets – Threshold Analysis – Comments 
 
Rankings – Other examples 
 
Scenario analysis – Introduction 
 
Scenario analysis – Case Studies 
 
Car vs Uber – Introduction 
 
Car vs Uber – Cost of own car basic 
 
Car vs Uber – Comparison of costs 
 
How to motivate not yours sales reps – Case Introduction 
 
How to motivate not yours sales reps – Trainings 
 
How to motivate not yours sales reps – Contests 
 
How to motivate not yours sales reps – Incentive trips 
 
How to motivate not yours sales reps – Loyalty program 
 
How to motivate not yours sales reps – Summary and Comparison in Excel 
 
How to motivate not yours sales reps – Solution in Power Point 
 
How much is MBA worth – Introduction 
 
How much is MBA worth – the Loan 
 
How much is MBA worth – Pessimistic scenario 
 
How much is MBA worth – Optimistic & Realistic 
 
How much is MBA worth – Comparison 
 
Scenario Analysis – Other Examples 
 
Representative element analysis – Introduction 
 
How long will it take to prepare the presentation – Introduction 
 
How long will it take to prepare the presentation – Time needed 
 
How long will it take to prepare the presentation – Deadline 
 
Decision Tree Analysis – Introduction 
 
Decision Tree Analysis – Solution 
 
How big house should I build – Introduction 
 
How big house should I build – Small House 
 
How big house should I build – Big House 
 
How big house should I build – Power Point 
 
What happens with Jorge time – Introduction 
 
What happens with Jorge time – Data for the case 
 
What happens with Jorge time – Analysis of data 
 
What happens with Jorge time – OLE & Improvements 
 
Theory of constraints and bottlenecks 
 
Content marketing agency – Introduction 
 
Content marketing agency – Solution 
 
Decomposition of effects analysis – Introduction 
 
LFL analysis – Introduction 
 
LFL analysis – Solution – Part 1 
 
LFL analysis – Solution – Part 2 
 
LFL analysis – Solution – Power Point 
 
Simulation analysis – Introduction 
 
What will be the effect of the price increase – Introduction 
 
What will be the effect of the price increase – Solution – Impact on coffee only 
 
What will be the effect of the price increase – Solution – Full impact
 
 
10 x current solution using first principles – Introduction 
 
10 x current solution using first principles 
 
Reduce water using 10x framework – Case Introduction 
 
Reduce water using 10x framework – Drivers 
 
Reduce water using 10x framework – Current Consumption 
 
Reduce water using 10x framework – Options 
 
Reduce water using 10x framework – Summary 
 
Decrease cost using 10x framework – Case Introduction 
 
Decrease cost using 10x framework – Drivers 
 
Decrease cost using 10x framework – Current Level 
 
Decrease cost using 10x framework – Options 
 
Decrease cost using 10x framework – Summary 
 
What tool should you use? 
 
How to scale up a business using theory of constraints - best practices