Offline Business Models in Excel Practical Guide

Offline Business Models in Excel – Practical Guide, available at $49.99, has an average rating of 4.45, with 73 lectures, based on 125 reviews, and has 3608 subscribers.

You will learn about Create business models in Excel Analyze offline business models in Excel You will understand what is important in your business You will know what KPI you should look at and what are the benchmarks You will learn how to analyze strategies using business models in Excel, especially during management consulting projects This course is ideal for individuals who are Management Consultants interested in modeling or Business Analysts or Operations Directors in Retail or Investment Directors in Private Equity or Controllers or Startup founders or Small and medium business owners It is particularly useful for Management Consultants interested in modeling or Business Analysts or Operations Directors in Retail or Investment Directors in Private Equity or Controllers or Startup founders or Small and medium business owners.

Enroll now: Offline Business Models in Excel – Practical Guide

Summary

Title: Offline Business Models in Excel – Practical Guide

Price: $49.99

Average Rating: 4.45

Number of Lectures: 73

Number of Published Lectures: 73

Number of Curriculum Items: 73

Number of Published Curriculum Objects: 73

Original Price: $79.99

Quality Status: approved

Status: Live

What You Will Learn

Create business models in Excel

Analyze offline business models in Excel

You will understand what is important in your business

You will know what KPI you should look at and what are the benchmarks

You will learn how to analyze strategies using business models in Excel, especially during management consulting projects

Who Should Attend

Management Consultants interested in modeling

Business Analysts

Operations Directors in Retail

Investment Directors in Private Equity

Controllers

Startup founders

Small and medium business owners

Target Audiences

Management Consultants interested in modeling

Business Analysts

Operations Directors in Retail

Investment Directors in Private Equity

Controllers

Startup founders

Small and medium business owners

What is the aim of this course?

This course will help you drastically improve your knowledge and skills in creating business models in Excel for traditional offline businesses such as Retail, B2C services, and products, and B2B services, and products. It is designed for those who want to become consultants, business analysts, and people who need to be able to analyze any business in Excel. In the course you will learn 4 things:   

1. What your business model is about, what to concentrate on and what are the most important KPIs for you?   

2. How to translate your business model into Excel and evaluate it?   

3. How to draw conclusions using your business model in Excel?   

4. Estimate  the impact of specific changes that you may consider in your business 

This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 224 000 students including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

I teach through case studies, so you will have a lot of lectures showing examples of analyses, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.

Why have I decided to create this course?   

Most consultants and business analysts struggle with building business models in Excel as it requires a mixture of knowledge about the business, some fluency in simplification, and presentation in Excel of the logic behind the business. By training in modeling your business in Excel, you gain in-depth knowledge about your business and you can spot faster the links between seemingly unrelated issues. This course is designed to fill in the gaps and turn you into an expert in business modeling. I strongly recommend this course to people who want to be in charge of their business as it will empower you to move your business forward.   

To sum it up, I believe that if you want to build or to find improvements in any business you should master techniques related to modeling the business in Excel. That is why I highly recommend this course not only to consultants or business analysts who have to advise their customers but also to owners, founders of businesses as well as investment directors.   

In what way will you benefit from this course?   

The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you analyze and create business models in Excel. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:   

1. How to build the model in Excel for your business   

2. How to identify important issues for your business and how to reflect them in Excel   

3. How to find ways in which you can significantly increase the value of the business   

4. How to calculate the impact of proposed changes in Excel   

You can also ask me any question either through the discussion mode or by messaging me directly.   

How the course is organized?   

The course is divided currently into the following sections:   

Introduction.We begin with a little intro into the course as well as some general info on production   

Retail.In the second section, I will discuss the business model of Retailers. I will show you the main challenges they are facing, KPIs that matter in Retail, and examples of companies. Since more and more Retailers operate also online I will also show you the details of the e-commerce business model. I will show you how to model traditional retail as well as e-commerce in Excel   

B2C  Services.In this section, I will discuss the business model of B2C services i.e. hairdressers, restaurant chains, plumbers, electricians, etc. I will show you the main challenges they are facing, the KPIs that matter in B2C service, and examples of companies. We will go into more detail when it comes to restaurant chains and I will show you how to model them in Excel.   

B2B Services. Next, we will move on to the business model of B2B services. They behave a little bit differently than the B2C service. I will show you the main challenges they are facing, the KPIs that matter in B2C service, and examples of companies. In the end, I will show you how to model a consulting business in Excel.   

FMCG. In this section, we will move to products. The first one to be discussed is FMCG products. I will show you the main challenges they are facing, the KPIs that matter in B2C service, and examples of companies. As an example, I will show you how to model in the Excel Cosmetics business.   

Commodity. On the other scale are products for which the brand is not that important and that are simply selling well-known,  not differentiated products. I will show you the main challenges they are facing, the KPIs that matter in B2C service, and examples of companies. As an example, I will show you how to model in Excel production of plywood 

I will be adding new sections and lectures in the coming months       

You will be able also to download many additional resources   

1. Models in Excel shown in lectures   

2. Links to books worth reading   

3. Presentations of different business models   

4. Links to additional presentations and movies     

At the end of my course, students will be able to   

Pick the right business model for their business idea

You will understand what is important in your business

You will know what KPI you should look at and what are the benchmarks

You will be able to write down your business model in the form of an Excel model and draw conclusions from it

Who should take this course? Who should not?   

Management Consultants

Business analysts

Investment Directors

Small and medium business owners

Startups founders

Controllers

What will students need to know or do before starting this course?

Basic or intermediate Excel

Basic knowledge of economics or finance

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: About me

Lecture 3: How to deal with Blurry image

Lecture 4: How to reach additional resources

Chapter 2: Retail Business Model

Lecture 1: Introduction to retailer business model

Lecture 2: Main challenges in Retail

Lecture 3: Business model of Retail – main drivers

Lecture 4: Business model of Retailer in Excel – transaction version – 1 store

Lecture 5: Business model of Retailer in Excel – transaction version – retail chain

Lecture 6: Business model of Retailer in Excel – sq m version

Lecture 7: E-commerce business model – intro

Lecture 8: E-commerce business model – Excel example

Chapter 3: B2C Services Business Model

Lecture 1: Introduction to the B2C Services Business Model

Lecture 2: Things that matter in hairdressers, beauty salons etc.

Lecture 3: Things that matter in other B2C Services Business Model

Lecture 4: Introduction to modeling B2C Services in Excel

Lecture 5: Business model of a restaurant in Excel – basic model

Lecture 6: Business model of a restaurant in Excel – advanced model

Lecture 7: Restaurant chain – how to model it in Excel?

Chapter 4: B2B Services Business Model

Lecture 1: Introduction to the B2B Services Business Model

Lecture 2: Things that matter in B2B Services Business Model

Lecture 3: Introduction to modeling B2B Services in Excel

Lecture 4: General thoughts on B2B Services

Lecture 5: Mechanics of business model for a consulting firm

Lecture 6: The business model of a consulting firm in Excel – Capacity and revenues

Lecture 7: The business model of a consulting firm in Excel – costs and profit & loss

Chapter 5: FMCG Business Model

Lecture 1: Introduction to the FMCG Business Model

Lecture 2: Things that matter in FMCG Business Model

Lecture 3: Introduction to modeling FMCG in Excel

Lecture 4: Drivers for FMCG business model

Lecture 5: FMCG business model in Excel – Basic assumptions and Sales

Lecture 6: FMCG business model in Excel – Fixed and Variable Production Costs

Lecture 7: FMCG business model in Excel – Gross Margin

Lecture 8: FMCG business model in Excel – Cost of sales and marketing and Net Margin

Lecture 9: FMCG business model in Excel – Net Margin

Lecture 10: FMCG business model in Excel – Head Office costs

Lecture 11: FMCG business model in Excel – P&L

Chapter 6: Commodity Business Model

Lecture 1: Introduction to the Commodity Business Model

Lecture 2: Things that matter in Commodity Business Model

Lecture 3: Drivers for Commodity business model

Lecture 4: Commodity business model in Excel – Basic assumptions and Sales

Lecture 5: Commodity business model in Excel – Fixed and Variable Production Costs

Lecture 6: Commodity business model in Excel – Gross Margin

Lecture 7: Commodity business model in Excel – Cost of sales and marketing

Lecture 8: Commodity business model in Excel – Net Margin

Lecture 9: Commodity business model in Excel – Head Office costs

Lecture 10: Commodity business model in Excel – P&L

Chapter 7: SMCG business model

Lecture 1: Introduction to the SMCG Business Model

Lecture 2: Things that matter in SMCG Business Model

Lecture 3: Drivers for SMCG business model

Lecture 4: SMCG business model in Excel – Modeling in Exel – traditional approach

Lecture 5: SMCG business model in Excel – Basic assumptions

Lecture 6: SMCG business model in Excel – Sales

Lecture 7: SMCG business model in Excel – Fixed and Variable Production Costs

Lecture 8: SMCG business model in Excel – Gross Margin

Lecture 9: SMCG business model in Excel – Cost of sales and marketing

Lecture 10: SMCG business model in Excel – Net Margin

Lecture 11: SMCG business model in Excel – Head Office costs

Lecture 12: SMCG business model in Excel – P&L

Lecture 13: SMCG business model in Excel – Working Capital

Lecture 14: Modeling SMCG business model as a service business – Introduction

Lecture 15: From SMCG to service – Introduction – Part 1

Lecture 16: From SMCG to service – Introduction – Part 2

Lecture 17: From SMCG to service – Case Introduction

Lecture 18: From SMCG to service – If sold as a product

Lecture 19: From SMCG to service – If sold as a service – Part 1

Lecture 20: From SMCG to service – If sold as a service – Part 2

Lecture 21: From SMCG to service – Comparison

Lecture 22: From SMCG to service – Solution in Power Point

Lecture 23: Modeling SMCG business model as a service business – General Remarks

Lecture 24: Modeling SMCG business model as a service business – Head Office costs

Lecture 25: Modeling SMCG business model as a service business – Profit & Loss

Chapter 8: Conclusions

Lecture 1: Bonus Lecture

Instructors

Asen Gyczew
Expert in performance improvement, turnaround and startups

Rating Distribution

1 stars: 4 votes

2 stars: 2 votes

3 stars: 20 votes

4 stars: 42 votes

5 stars: 57 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!