On-line Business Models in Excel - Practical Guide
4.6 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
810 students enrolled
Wishlisted Wishlist

Please confirm that you want to add On-line Business Models in Excel - Practical Guide to your Wishlist.

Add to Wishlist

On-line Business Models in Excel - Practical Guide

Learn on-line business models (SaaS, marketplace, media site, e-commerce) and see how to build their models in Excel.
4.6 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
810 students enrolled
Created by Asen Gyczew
Last updated 3/2017
English
Current price: $25 Original price: $45 Discount: 44% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Pick the right business model for their business idea
  • You will understand what is important in your business
  • Model your business in Excel
  • Estimate the value of your businees
  • You will know what KPI you should look at and what are the benchmarks
View Curriculum
Requirements
  • Basic or intermediate Excel
  • Basic business knowledge
Description

Course summary

Why we decided to create this course?

We work with startups on daily basis within our accelerator StartupAkademia and we have noticed that despite tones of very good books on lean methods (i.e. Lean Analytics, Running Lean etc.) startups as well as small / medium businesses have problems with applying this knowledge in practice. We have noticed that, especially first time startups, do not really understand their business model (which is totally understandable). That's why, it is very difficult for them to know what they should concentrate on. Most entrepreneurs / startups have more or less clear business idea but quite often they do not know the business models they can chose and end up learning it the hard way, through their mistakes. Some of them have read the Lean analytics, Lean Starup or Running Lean but even then they do not know exactly how to translate it into coherent Excel model. A business model in the form of Excel is very important for evaluating your business, seeing how much cash you need and how your hypothesis and KPIs are translating into the business

What will this course give you?

The course is a practical, step by step guide loaded with tones of tips and tools that will help you significantly speed up with your business, especially if you are a startup or a small / medium business. There is little theory – mainly examples, a lot of tips from our own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:

  1. what your business model is about, what to concentrate on and what are the key KPIs for you?
  2. How you can translate it into Excel and evaluate your business?
  3. How to make conclusions on the basis of your business model presented in the form of Excel

In this course we concentrate only on on-line business models

On top of that every moth we organize office hours for 5 startups (first come first served bases) during which startups get 30 minutes to ask as directly (phone, Whatsapp or Skype) for advices.

How the course is organized?

Currently the course is divided into 5 sections:

  • Introduction. In this section I give you quick overview of the purpose and approach we will use in each and every section
  • E-commerce business model. In this section you will get insight t into the business model of different e-commerce companies. E-commerce businesses group is very diversified so we will try to show the similarities and the differences between concepts.. You will learn here the definition of this business model, see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect. Afterwards, I will show you how you can build the model in Excel and what conclusions can you draw from it.
  • 2-sided market business model. This business model has been very popular over the last 5-years and successful companies in this model can grow to be true global players at big scale. Here you will get insight into the business model of 2-sided market, especially marketplaces. You will learn not only the definition of this business model but you will have also the opportunity to see some examples of companies using these models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect. Afterwards, I will show you how you can build the model in Excel and what conclusions can you draw from it.
  • Media site business models. Here you will have a look at relatively simple and cheap business model – media site. You will learn the definition of this business, see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect. Afterwards, I will show you how you can build the model in Excel and what conclusions can you draw from it.
  • SaaS business models. Here you will get insight into the business model of Software as a Service companies. You will learn the definition of the business model , see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect. At the end, I will show you how you can build the model in Excel and what conclusions can you draw from it.

We will be adding another 2 business models: mobile application model an User Generated Content model. The price will increase as we develop further the course

You will be able also to download many additional resources

  • Models in Excel show in lectures
  • Links to books worth reading
  • Presentations of different business models

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

  1. Pick the right business model for their business idea
  2. You will understand what is important in your business
  3. You will know what KPI you should look at and what are the benchmarks
  4. You will be able to write down your business model in the form of an Excel model and to draw conclusion out of it

Good luck with the course and if you have any question please write to me or in the discussin panel

Who is the target audience?
  • Small and medium business owners
  • Startup founders
  • Startup employees
  • Business analyst
  • Financial Analyst
  • Market Researchers
  • Business Consultants
Curriculum For This Course
Expand All 16 Lectures Collapse All 16 Lectures 03:19:11
+
Introduction Into the Course
3 Lectures 05:24

Here we will explain the basic rules used to build he business models in Excel. Modelling in Excel can be very easy and worthwile if you follow some rules we will present you in this leture

Preview 01:47

+
E-commere business models
3 Lectures 30:09

In this lecture you will get insight t into the business model of different e-commerce companies. E-commerce businesses group is very diversified so we will try to show the similarities and the differences between concepts.. You will learn here the definition of this business model, see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect.

Preview 20:58

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

Preview 09:11

Slides showing E-commerce business model
19 pages
+
2-sided market business model
3 Lectures 24:31
This business model has been very popular over the last 5-years and successful companies in this model can grow to be true global players at big scale. Here you will get insight into the business model of 2-sided market, especially marketplaces. You will learn not only the definition of this business model but you will have also the opportunity to see some examples of companies using these models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect. Afterwards, I will show you how you can build the model in Excel and what conclusions can you draw from it.
2-sided market business model - examples, KPIs, main issues
14:49

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

2-sided market in Excel
09:42

We show here the slides presenting in details the business model, KPIs, important aspects, how we translated it into Excel and what you should concentrate on

Slides showing 2-sided market business model
18 pages
+
Media site business model
3 Lectures 23:19

Here you will have a look at relatively simple and cheap business model – media site. You will learn the definition of this business, see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect

Media site business model explained - examples, KPIs, main issues
18:26

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

Media site business model in Excel
04:53

We show here the slides presenting in details the business model, KPIs, important aspects, how we translated it into Excel and what you should concentrate on

Slides showing Media Site business model
20 pages
+
Saas business model
3 Lectures 27:14

Here you will get insight into the business model of Software as a Service companies. You will learn the definition of the business model , see some examples of companies using this business models. You will also understand what really matters in this sort of business, what KPIs you should look at and what values you can expect

SaaS business model explained - examples, KPIs, main issues
19:08

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

SaaS in Excel
08:06

We show here the slides presenting in details the business model, KPIs, important aspects, how we translated it into Excel and what you should concentrate on

Slides showing SaaS business model
17 pages
+
Conclusions
1 Lecture 00:44
Bonus Lecture: What's next for you?
00:44
About the Instructor
Asen Gyczew
4.3 Average rating
557 Reviews
13,875 Students
18 Courses
Expert in performance improvement, turnaround and startups

Expert in performance improvement, startuping and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 40 million) as well as startups.

Specialties:

Functional experience: performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence;

Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing)

Countries: Poland, Serbia, Russia, Ukraine