Online Business Models in Excel Practical Guide
What you’ll 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
You will learn how to analyze strategies using business models in Excel, especially during management consulting projects
Requirements
Basic or intermediate Excel
Basic business knowledge
Description
Why have we decided to create this course?We work with startups on daily basis within our accelerator StartupAkademia and we have noticed that despite tonnes 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 a more or less clear business idea but quite often they do not know the business models they can choose and end up learning it the hard way, through their mistakes. Some of them have read Lean Analytics, Lean Startup, or Running Lean but even then they do not know exactly how to translate it into a 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 businessWhat will this course give you?The course is a practical, step-by-step guide loaded with tons of tips and tools that will help you significantly speed up 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:What your business model is about, what to concentrate on and what are the key KPIs for you?How you can translate it into Excel and evaluate your business?How to make conclusions on the basis of your business model presented in the form of ExcelIn this course, we concentrate only on online business modelsHow the course is organized?Currently, the course is divided into 5 sections:Introduction. In this section, I will give you a quick overview of the purpose and approach we will use in each and every sectionE-commerce business model. In this section, you will get insight t into the business model of different e-commerce companies. The E-commerce business group is very diversified so we will try to show the similarities and differences between concepts. You will learn here the definition of this business model, and see some examples of companies using this business model. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, 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 truly global players at a big scale. Here you will get insight into the business model of a 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. Afterward, 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 a relatively simple and cheap business model – a media site. You will learn the definition of this business, and see some examples of companies using this business model. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, 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 company. You will learn the definition of the business model, and see some examples of companies using this business model. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. In 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: the mobile application model and User Generated Content model. The price will increase as we develop further the courseYou will be able also to download many additional resourcesModels in Excel shown in lecturesLinks to books worth readingPresentations of different business modelsAt the end of my course, students will be able to…Pick the right business model for their business ideaYou will understand what is important in your businessYou will know what KPI you should look at and what are the benchmarksYou will be able to write down your business model in the form of an Excel model and draw conclusions from itGood luck with the course and if you have any questions please write to me or on the discussion panel
Overview
Section 1: Introduction Into the Course
Lecture 1 Introduction to business models
Lecture 2 Some thoughts on Excel models
Lecture 3 How to deal with Blurry image
Lecture 4 How to reach additional resources
Section 2: E-commere business models
Lecture 5 E-commerce business model – examples, KPIs, main issues
Lecture 6 E-commerce model in Excel
Section 3: 2-sided market business model
Lecture 7 2-sided market business model – examples, KPIs, main issues
Lecture 8 2-sided market in Excel
Section 4: Media site business model
Lecture 9 Media site business model explained – examples, KPIs, main issues
Lecture 10 Media site business model in Excel
Section 5: Saas business model
Lecture 11 SaaS business model explained – examples, KPIs, main issues
Lecture 12 SaaS in Excel
Section 6: Other Business models
Lecture 13 Other Financial Models
Lecture 14 Drivers & KPIs
Section 7: Conclusions
Lecture 15 Bonus Lecture
Small and medium business owners,Startup founders,Startup employees,Business analyst,Financial Analyst,Market Researchers,Business Consultants,Students considering joining Management Consulting
Course Information:
Udemy | English | 1h 56m | 542.01 MB
Created by: Asen Gyczew
You Can See More Courses in the Business >> Greetings from CourseDown.com