Courses

A practical guide for Business Analysts and Management Consultants with exercises in Excel What you'll learn: Kill any discussion with solid data analysisDo any business analysis 10x faster than your colleaguesStructure complex problems and solve them in ExcelPerform any business analysis in a very effective mannerUnderstand the main challenges in analyzing different aspects in sales, marketing and operationsBuild business models for e-commerce, service companies and B2C servicesYou will get ready made examples of complex analyses from top-notch consulting companiesLearn top techniques and frameworks used in management consulting What is the aim of this course?This course will help you drastically improve your knowledge and skills in business analysis through a series of practical cases. It is designed for people who want to become business analysts or management consultants, work in management consulting, or do a lot of business analysis at their work. It is based on my 14years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement, and turn-arounds in the biggest companies from the FMCG, SMG, and B2B sectors that I worked for. On the basis of what you will find in this course, I have trained over 100 business analysts and management consultants who are now Investment Directors, Senior Analysts, Directors in Consulting Companies, Board Members, etc.On top of that, my courses on Udemy have already been taken by more than 315 000 students.I teach through cases, so most of the lectures will be case studies showing some business problems solved in Excel. I will also show you the main techniques used by Management Consultants to properly structure the business analysis. To most lectures, you will find attached (in additional resources) the Excel shown in the Lecture, 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 in your work. Why have I decided to create this course?The companies I have worked with so far as a Board Member (I am usually, Chief Restructuring Officer, VP responsible for Strategy and Development) still have a huge problem with properly analyzing intermediate and advanced issues – they are usually preoccupied with current activities and have close to no time for analysis and strategic decisions. Moreover, they do not know how to approach many subjects from an analytical point of view to make sure that they are making the right decision. Therefore, quite often they hire consultants who, in turn, lack the practical knowledge and experience. This course is my small contribution to improving both consulting as well as operational and strategic analyses in FMC, SMCG, and B2B companies, including also online models like e-commerce, SaaS, and marketplaces. 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 do the analyses, as well as the quality of the conclusions coming out of the available data in your company. 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: How to structure business analysis so you get the right results fast? How to analyze different aspects of sales, marketing, and operations? How to draw conclusions from those analyses – both for current operations as well as strategic ones? How to be efficient in your work as a business analyst or management consultant? How to build Excel files and PowerPoint presentations so that it is understandable for you and your team, even after some time? You can also ask me any questions either through the discussion mode or by messaging me directly. How is the course organized? The course is currently divided into the following sections: Introduction. We begin with a little intro into the course as well as some general info on the role of business analyst – what skills, education, and knowledge are required from you, and what are the available career paths for you How to create a top-notch business analysis in 8 steps. In this section, I will show you how to structure a business analysis so you get the results you want fast. Ceramic tiles market estimation - example of business analysis. In section 3, I will again show slowly 1 example of business analysis from the beginning to the end Improving the results of a cinema - example of business analysis - example of business analysis. In this section, I will again show slowly 1 example of business analysis from the beginning to the end Tools. In the second section, we briefly go through the main tools and concepts for business analysts. We devote some time to the most popular ones: Excel and PowerPoint Sales & Marketing. Analyzing the market, sales activities, and efficiency, and the potential for expansion are some of the most typical tasks set for business analysts. Here, I provide you with plenty of practical, real-life examples of problems and solutions Business modeling - example of analysis. On some occasions, you analyze the whole business to see what the logic behind it is. Here, we show how to do it for some of the business models Operations. Quite often, business performance depends on Operational Excellence. In this section, we will show you examples of analysis from logistics, production, production planning, and other supply chain issues. Cases for training analytical skills - Market Estimation. This section will help you train your analytical skills using the market estimation cases Cases for training analytical skills - Sales and Marketing. This section will help you train your analytical skills using the sales and marketing cases Cases for training analytical skills - Strategy. This section will help you train your analytical skills using strategic cases Cases for training analytical skills - Operations. This section will help you train your analytical skills using operational cases We will be adding new sections in the coming months You will also be able to download many additional resources Excel files with the analyses shown in the course Presentation of slides shown in the course Links to additional presentations and movies Links to books worth reading

A practical guide on how to analyze segments of customers during consulting projects What you'll learn: What segmentation techniques you can useWhen to use a specific segmentation technique?Crucial Excel formulas you will need to do segmentationHow to do simple segmentations in Excel using internal or external dataHow the B2B segmentation differs from B2C segmentationHow to use the Jobs-to-Be-Done frameworkHow to segment the market using external data What is the aim of this course?If you are participating in a consulting project devoted to Sales & Marketing or Strategy most likely you will have to either do segmentation or analyze existing segments of customers. You will try to achieve it on the basis of internal data, market research, and other external data. This course will teach how to rapidly and efficiently segment customers and analyze existing segments during consulting projects.In the course you will learn the following things: How you can segment customers? When to use a specific segmentation technique?Crucial Excel formulas you will need to do segmentationHow to do simple segmentations in Excel using internal or external dataHow the B2B segmentation differs from B2C segmentationThis 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, 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?During many projects, you will have to segment customers to be able to do more advanced analyses. This will be especially true during strategic projects and projects devoted to marketing or sales. Some consulting firms, don’t give you the full toolbox that you need to do simple segmentations during consulting projects. This may lead to huge frustration during consulting projects and a lot of inefficiencies.Therefore, I have decided to create this course to help students understand or refresh the segmentation techniques they may need during consulting projects. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects. You will master how to analyze data and draw conclusions from the analyses.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of segmentation. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that want to specialize in strategy, sales, and marketing. The course will help you become an expert in segmentation on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:How you can segment customers? When to use a specific segmentation technique?Crucial Excel formulas you will need to do segmentationHow to do simple segmentations in Excel using internal or external dataHow the B2B segmentation differs from B2C segmentationYou can also ask me any question either through the discussion field 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 introduction to the course as well as some general info on how the course is organizedEssential Concepts in B2C Segmentation. Segmentation is vital for every business. It helps you make decisions on strategy, products, and branding. In this section, we will have a look at essential methods used to segment the B2C market.Essential Concepts in B2B Segmentation. In this brief section, we are going to explore some methods of segmentation that can be used in B2B markets.Essential Excel for Segmentation. One of the most often used tools for segmentation is Excel. In this section, I will show you the essential formulas that will help you segment customers and analyze them.Segmentation Case Studies. In this section, we will look at more case studies that will be devoted to segmentation.Segmentation using external data. In some cases, you have no access to internal data, and you have to attempt to segment customers just by looking at external data. Let’s have a look at how it can be done in practice.Segmentation for Restaurants. Let’s now have a look at segmentation for restaurants. We will also talk about things that you should do before you start the segmentation.Jobs to be done framework. The Jobs to Be Done concept is a great tool to find a way to improve your business or create a new business. That’s why we will discuss it in this sectionYou will be able also to download many additional resourcesUseful frameworks and techniquesAnalyses shown in the courseAdditional resourcesLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…What segmentation techniques you can useWhen to use a specific segmentation technique?Crucial Excel formulas you will need to do segmentationHow to do simple segmentations in Excel using internal or external dataHow the B2B segmentation differs from B2C segmentationHow to use the Jobs-to-Be-Done frameworkHow to segment the market using external dataWho should take this course? Who should not?Management ConsultantsBusiness AnalystsStartup FoundersManagersInvestment AnalystsAnalysts working in Sales or Marketing Department

Top advices from consulting practice with examples and case studies What you'll learn: How to formulate a successful business strategyPick the right strategy for your businessHow to analyze strategic choices in ExcelIncrease the value of your business or the businesses belong to your customersHow to structure complex issuesHow to define key steps needed to achieve the selected strategyEstimate the impact of strategic option you have chosen What is the aim of this course?Strategy is one of the most dreaded subjects in any business. There are so many conflicting frameworks that is difficult to decide what to choose. In this course, you will learn a framework that will help you formulate and execute the strategy for your businesses on the level of top consulting firms i.e. McKinsey, BCG, Bain, PwC, and EY. You will also see how others are implementing their strategic choices. This course will help you drastically improve your knowledge and skills in creating as well as executing a strategy for your business (or your customers’ businesses). It is designed for people who want to become management consultants, business analysts, or work on creating and implementing the strategy inside the business. In the course you will learn 3 main things: What strategic choices do you have and how to choose the optimal one? How to calculate the impact of the chosen strategy or tactic? How to implement the strategy and how others are doing it?The course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, improvement, and turn-arounds in the biggest companies in the Retail, FMCG, SMG, and B2B sectors that I worked for. I have carried out or supervised over 90 different performance improvements and strategic projects in different industries that generated a total of 2 billion in additional EBITDA. On many occasions, I had to not only formulate the strategy but also make sure that it was implemented.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 CEOs, Board Members, Operational Directors, COOs, Investment Directors, Directors in Consulting Firms, etc. On top of that my courses on Udemy were already taken by more than 300 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 cases so most of the lectures are case studies showing some business problems solved in Excel. In this way, you get a lot of practical insight into how to calculate the impact of strategic changes or how to decide which strategic option is useful. These skills will come in handy during consulting projects. To every lecture, you will find attached (in additional resources) the Excel files shown in the lecture, so as part of this course, you will also get a library of ready-made analyses that can, with certain modifications, be applied by you in your work. Why have I decided to create this course? Most consultants and business analysts are a bit lost during strategic projects. On one hand, you have a business you don’t quite understand as it is new to you. On the other hand, you have a multitude of frameworks that are conflicting with each other and quite often not practical enough. To make matters worse the customer - the business you are working for has problems understanding what you are trying to convey with your thick presentations and thousands of Excel files. Therefore, I have gathered all my experience into one framework that is easy to follow not only for you but also for your customers. I believe in the power of data. That is why, I will show you also how to prove, using hard data and calculation in Excel, that a certain strategic choice is good or bad. In order to make certain strategies easier to understand I have also added plenty of examples of businesses using specific strategies. To sum it up, I believe that if you want to find a way to grow a business you have to become an expert in formulating and executing a proper strategy for this business. This course has all the materials you need to become one. That is why, I highly recommend this course not only to consultants or business analysts that have to advise their customers but also to owners, founders of businesses as well as board members. In what way will you benefit from this course? The course is a practical, step-by-step guide loaded with tons of examples, analyses, tricks, and hints that will significantly improve the speed with which you formulate a strategy. 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: What strategic choices do you have and how to choose the optimal one? How to calculate the impact of the chosen strategy or tactic? How to implement the strategy and how others are doing it? What are the consequences of a specific strategic choice for your business? You can also ask me any question either through the discussion field or by messaging me directly. How is the course organized? The course is divided into the following sections: Introduction. We begin with a little intro into the course as well as some general info on production Do what you do but better. In the second section, I will discuss the basic things you can do to improve its profitability without much growth or expansion. This strategic direction is the best for people who are satisfied with the current size of their business Expand your business. In this section, I will show you different ways in which you can grow your business or your customers’ businesses in size. This strategic choice is perfect for those businesses that have a winning business model and a lot of room to grow. As always there will be loads of case studies, practical knowledge of how to do in practice the necessary calculations in Excels Go niche. In the 4thsection, I will show you how you can protect your business by going into a niche. I will devote a lot of time to the Blue Ocean Strategy and Low-Cost Strategy – 2 very powerful strategic concepts that have been disrupting many markets Transform. In the 5th section, I will show you how you can transform your business from your current vulnerable position into a better place with better margins and more room to grow. Disrupt Yourself. In this section, I will show you the last strategic option you may consider. Here you decide to look for ways to disrupt yourself before somebody else does it. I will discuss ways in which you can do it and I will show you plenty of examples of successful execution of this strategy You will also be able to download many additional resources Excels with analyses shown in the course Presentation of slides shown in the course Links to additional presentations and movies Links to books worth reading At the end of my course, students will be able to… How to formulate a successful business strategyPick the right strategy for your businessHow to crunch data in ExcelEstimate the impact of the strategic option you have chosenIncrease the value of your business or the businesses that belong to your customersHow to structure complex issuesHow to define key steps needed to achieve the selected strategyWho should take this course? Who should not? Management ConsultantsBusiness AnalystsSmall and medium business ownersStartups foundersControllersEnjoy the course and if you have any questions or requests just let me know

A practical guide on how to come up with killer business ideas for Management Consultants & Managers What you'll learn: How to come up with a killer ideaInnovate your product and business modelFind ways to create a product 10x better than the current solutionsBuild a new business on top of existing businessesDisrupt othersApply Blue Ocean framework What is the aim of this course?To build a business, you need a good idea that you can explore and develop. Unfortunately, coming up with a good business idea is not easy. Most firms and universities don’t show how to come up with business ideas. They concentrate on teaching you how to run existing businesses. Luckily, there are a lot of proven methods to find interesting business ideas. If you are a Management Consultant, you can use them during consulting projects to help your customers grow their businesses. If you are a manager or startup founder, they will prove priceless in your quest to discover new business opportunities. In this course, I will show you different methods to come up with killer business ideas. In the course, you will learn the following things: How to come up with business ideas by improving existing products, solving existing problemsWhen specific methods of business idea generation can be appliedHow specific business methods should be appliedHow to find ways to 10x existing solutionsHow to innovate your product and your business modelHow to build an add-on business using your current businessThis 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 the 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 are now 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 315 000 students, including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Napers, 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 Excel 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 firms and universities don’t show how to come up with business ideas. They concentrate on teaching you how to run existing businesses. However, coming up with new business ideas is required if you want to grow the business. At some point, the small improvements and organic growth will not suffice. New business ideas not only help you grow the business but also help you make it more durable and sustainable. New business ideas will help you come up with new ways to change your business model and adjust to new trends.This course will help you become an expert in business idea generation. This skill will prove very useful not only in consulting but also later on when you become a director or you move on to build your own business. By giving you exposure to real-life cases and analyses, I want to improve your skills in business idea generation. Thanks to this course, you will know what and how to do it during strategic consulting projects devoted to creating new businesses. We want to provide you with frameworks that will open your eyes to new opportunities.To sum it up, the course will help you become an expert in business idea generation on the level of McKinsey, BCG, Bain, PwC, Deloitte, EY, and other top consulting firms. That is why I highly recommend this course to Managers, Management Consultants, as well as Investment Directors working for PE, Directors, and owners/founders of businesses.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 generate new business ideas. 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 learn:How to come up with business ideas by improving existing products, solving existing problemsWhen specific methods of business idea generation can be appliedHow specific business methods should be appliedHow to find ways to 10x existing solutionsHow to build an add-on business using your current businessYou can also ask me any questions either through the discussion field or by messaging me directly.How is the course organized?The course is currently divided into 4 sections. Currently, you will find the following sections:Introduction. We begin with a little intro to the course, as well as some general info on how the course is organizedImproving existing things. In the second section, I will show how to come up with business ideas if you don’t have an existing business and you want to improve something that already exists. In this section, we will discuss methods like Solving your own problem, Carving out existing businesses, Cloning businesses, and ideas, Blue Ocean, 10 x current solutions using first principles, From Free to Paid, Riding a trend, Disrupting othersJobs to be done. In this section, I will show a powerful framework that can be used to understand the role that the product plays in the life of a customer. This will help you innovate, find new business ideas, and most of all, identify the right competitor landscape from the point of view of the customers.Build on existing business. In the 4th section, I discuss a situation when you already have an existing business and you want to build an add-on business using your current business as a starting point. We will discuss numerous methods in this section as well: Going up or down the Value Chain, Vertical Consolidation via M&As, Build add-on businesses, Build entirely new businesses, Enabling Investments, Expanding the brand into new categories, Disrupting yourself, Using existing assets in a new way, Experiment with different sales channels & revenue streams, Turn failure into success, Repurpose a product / Find the new application to a productYou will also be able to download many additional resourcesUseful frameworks and techniquesSelected analyses shown in the courseLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will learn to…How to come up with a killer ideaInnovate your product and business modelFind ways to create a product 10x better than the current solutionsBuild a new business on top of existing businessesDisrupt othersApply the Blue Ocean frameworkWho should take this course? Who should not?Management Consultants and Business AnalystsManagersAnalysts working in Strategic DepartmentsStartup FoundersInvestment DirectorsWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics or finance

A practical guide how to analyze & model subscription businesses in Excel What you'll learn: How to model in Excel subscription businessesHow to analyze whether the switch to a subscription businessWhat are the main challenges in subscription businesses?How to calculate customer acquisition costsHow to reduce customer acquisition costsHow to increase the value of customersHow to model e-commerce, streaming business and SaaS business in Excel What is the aim of this course?More and more firms are switching from transaction-based businesses to subscription businesses. This business model requires a different approach when it comes to analyzing it in Excel. During some consulting projects, you may be asked to analyze or model subscription business models in Excel and advise firms on the best course of action. In this course, I will teach how to model fast and efficiently subscription businesses in Excel and how to analyze them during consulting projects.In the course you will learn the following things:How to model different subscription businesses in ExcelHow to analyze whether the switch to a subscription model makes sense or notHow to analyze customer acquisitionThis 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, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, McKinsey, 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?Subscription businesses are not the dominant form in most industries. Many people struggle with capturing the complexity of such businesses in Excel. Subscription businesses also require a totally different approach to customer acquisition and retention. Most universities are not addressing this sort of business. Also, some consulting firms don’t provide their consultants with enough opportunities to understand and learn how subscription businesses work.Therefore, I have decided to create this course that will help students understand or refresh their knowledge of subscription businesses. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects devoted to subscription businesses. You will master the modeling of subscription businesses in Excel and analyze whether the switch to such a model will make sense. On top of that, you will learn how to approach customer acquisition and retention.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of subscription businesses. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish business school or Economics. The course will help you become an expert in subscription businesses on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:1. How to model different subscription businesses in Excel2. How to analyze whether the switch to a subscription model makes sense or not3. How to analyze customer acquisitionYou can also ask me any question either through the discussion field 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 to the course as well as some general info on how the course is organized.Essential Concepts. We will start by explaining some essential concepts that later we will use to describe and show you the differences between subscription businesses. I will explain what we mean by subscription businesses, churn rate, MRR, and MRR churn. I will also provide examples of firms using a subscription model.Modeling Subscription Businesses in Excel. Modeling Subscription Businesses in Excel requires a bit different approach than transaction-based businesses. We will show you in this section how to do it. I will start with transaction-based e-commerce, after which we will show you how to model e-commerce as a subscription. Later on, we will also model the streaming businesses.SaaS. A lot of SaaS businesses run as subscription businesses. We will discuss what SaaS is, what KPIs you should pay attention to, and how to model them in Excel.Customer Acquisition. Without customer acquisition, you will not enjoy much growth. In e-commerce, you will spend a lot of time optimizing and finding more optimal ways to acquire customers. In this section, we will discuss how to calculate customer acquisition costs, how to lower them, and how to increase the value of the customer.You will be able also to download many additional resources1. Useful frameworks and techniques2. Models & Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth readingAt the end of my course, students will be able to…How to model in Excel subscription businessesHow to analyze whether the switch to a subscription businessWhat are the main challenges in subscription businesses?How to calculate customer acquisition costsHow to reduce customer acquisition costsHow to increase the value of the customerHow to model e-commerce, streaming business, and SaaS business in ExcelWho should take this course? Who should not?Management Consultants and Business AnalystsManagersFinancial ControllersInvestment AnalystsStartup FoundersProject ManagersManagers responsible for Acquisitions and MergersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

A practical guide how to analyze pricing and find optimal solutions during consulting projects What you'll learn: What pricing techniques you can useHow to implement value-based pricingHow to define the right level of pricesHow to estimate in Excel the impact of changes in pricingWhich approach to pricing you should use in a specific situation What is the aim of this course?Consulting firms sometimes help optimize pricing. You have to be very careful in this sort of project because a small change may have a huge impact both on the top-line and the bottom-line. Analyzing changes in pricing is not easy as you have to take into account the relations between the products and the long-term impact on customer behavior. In this course, I will teach how to perform fast and efficiently different types of analyses related to pricing.In the course you will learn the following things:Essential Concepts used in PricingWhat Price Setting Techniques firms can useHow to set the prices for a productWhat is Price Perception and how you can impact it without changing the prices?How pricing is done in consumer goods, retail, and B2B ServicesHow to analyze the impact of planned pricing policy changes in ExcelThis 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. There will also be additional resources that will help you learn a lot of things beyond the scope of this course.Why have I decided to create this course?Most people who start working in consulting have limited knowledge of how pricing works in practice and how to analyze potential changes in Excel. On top of that, pricing will differ greatly in many industries.. This may lead to huge frustration during consulting projects and a lot of inefficiencies.Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools related to pricing that they need during consulting projects. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects devoted to pricing analysis. You will master how to analyze data and draw conclusions from the analyses. On top of that, you will also master the essential information related to pricing.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of pricing techniques and analyses done during projects devoted to pricing. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish business school or Economics. The course will help you become an expert in pricing analyses on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:Essential Concepts used in PricingWhat Price Setting Techniques firms useHow to set the prices for a productWhat is Price Perception and how you can impact it without changing the prices?How pricing is done in consumer goods, retail, and B2B ServicesHow to analyze the impact of planned pricing policy changes in ExcelHow the course is organized?The course is divided into the following sections:Introduction. We begin with a little introduction to the course as well as some general info on how the course is organizedEssential Concepts in Pricing. We will start by discussing the essential concepts that we will use later on for analyzing pricing.Price Setting Techniques. In this section, I will show you, using a lot of examples, different pricing techniques.Price Perception. In many cases, it is more important to manage price perception rather than real prices. We will discuss in this section what price perception is and how to use it to your advantage.Pricing in Consumer Goods & Retail. In this section, we will have a look at some issues related to the pricing of consumer goods. We will also have a look at some more advanced case studies.Pricing in B2B Services. The pricing of B2B services drastically differs from the pricing of consumer goods. In B2B the buyer is more rational and has a much bigger knowledge of the market. In the last section, we will have a look at how pricing is addressed in B2BAs a part of this course, you will getUseful frameworks and techniquesAnalyses shown in the courseAdditional resourcesLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…What pricing techniques you can useHow to implement value-based pricingHow to define the right level of pricesHow to estimate in Excel the impact of changes in pricingWho should take this course? Who should not?Management Consultants and Business AnalystsManagersFinancial ControllersInvestment AnalystsStartup FoundersControllersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

A practical guide on how to scale businesses in practice fast and efficiently What you'll learn: How firms like Tesla, Amazon have scaled their businessHow to scale different areas of the firmHow to identify the biggest bottlenecks preventing you from scalingHow to estimate the speed of scalingHow to design your scaling processScale fasterScale successfully Sales, Operations, and RecruitmentDisrupt others by blitzscalingScaling consulting business What is the aim of this course?If you have managed to build a successful business that is also profitable, at some point you will start thinking about scaling your business and drastically growing its size and profits. This will require a different approach than the everyday management of the business. You need different frameworks to scale fast & efficiently the business. In this course, I will teach you how to find ways to scale the business fast & efficiently. I will also show you how to prepare the organization for scalingIn the course you will learn the following things:How firms like Tesla, and Amazon have scaled their businessHow to scale different areas of your firmHow to identify the biggest bottlenecks preventing you from scalingHow to estimate the speed of scalingHow to design your scaling processScale fasterScale successfully Sales, Operations, and RecruitmentThis 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, 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?Scaling businesses is one of the most difficult things that you may have to do. Quite often what made the business successful at a smaller scale will not be sufficient to scale the business fast. Many consulting firms, don’t give you the full toolbox that you need to successfully scale a business. This may lead to huge frustration during consulting projects and a lot of inefficiencies.Therefore, I have decided to create this course that will help students master techniques, tools, and frameworks useful in scaling businesses, especially during consulting projects. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects devoted to scaling businesses. You will master how to analyze data and draw conclusions from the analyses. On top of that, you see how other firms like Tesla or Amazon have scaled their businesses.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of scale businesses. That is why, I highly recommend this course to Management Consultants, especially those that want to become CEOs or start their own business. The course will help you become an expert in scaling businesses on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:How firms like Tesla, and Amazon have scaled their businessHow to scale different areas of your firmHow to identify the biggest bottlenecks preventing you from scalingHow to estimate the speed of scalingHow to design your scaling processScale fasterScale successfully Sales, Operations, and RecruitmentYou can also ask me any question either through the discussion field 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 introduction to the course as well as some general info on how the course is organizedWhat scaling means. Scaling can mean a lot of things. For some, it is simply growing sales. For others, it will be around scaling profit. In this section, we will discuss what we mean by scaling the business.Process of scaling. In this section, I will show you what process you can use to scale your business more efficiently.Scaling Sales & Margin. In this section, we will discuss how you can Scale Sales & Marketing. You will also see how famous firm like Amazon has scaled their business.Scaling Operations. In many cases, the firms have to be very creative when it comes to Scaling Operations. In this section, we will look again at frameworks and case studies.Scaling Recruitment & Training. Let’s have a look at what the process of Scaling Recruitment & Training should look like.Useful supporting techniques. In scaling 2 nice techniques can prove very useful: 10x using first principles and Enabling Investment. We will discuss them in this section.Scaling Consulting Business. Let’s now have a look in more detail at how we can scale a consulting business.Scaling Training in Consulting Firm. Recruitment & Training are much more important in the consulting business than in consumer goods or retail. Training has a huge impact on your product and ability to deliver projects.You will be able also to download many additional resources1. Useful frameworks and techniques2. Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth readingAt the end of my course, students will be able to…How firms like Tesla, and Amazon have scaled their businessHow to scale different areas of your firmHow to identify the biggest bottlenecks preventing you from scalingHow to estimate the speed of scalingHow to design your scaling processScale fasterScale successfully Sales, Operations, and RecruitmentDisrupt others by blitzscalingScaling consulting businessWho should take this course? Who should not?Management ConsultantsCEOManagersInvestment AnalystsStartup FoundersManagers responsible for Acquisitions and MergersDirectors responsible for StrategyWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics

A practical guide on how to change & innovate the business, disrupt incumbent players like Amazon, Tesla, Google, Apple What you'll learn: How to Innovate the Business ModelUnderstand the Business Model CanvasDesign Innovative Business ModelMaster Different Types of InnovationHow to estimate in Excel whether the innovation makes senseHow Tesla, Disney, Apple, Google have innovatedCreate Innovative Revenue StreamsDeliver Innovative Value PropositionPractical Strategies that will accelerate the growth of your businessApply in practice the Blue Ocean Strategy What is the aim of this course?Consulting firms are hired very often to help to change the Business Model. Those projects are difficult as you have to generate innovation and convince the firm to change. There is no one recipe for how to innovate. However, there are some proven techniques, frameworks, and approaches that will help you find a way to innovate the Business Model. In this course, I will teach you how to pick the right Business Model Innovation technique during consulting projects.In the course you will learn the following things:What frameworks, tools techniques you can use to Innovate your Business ModelHow others have implemented the InnovationHow to estimate the potential impact of the Business Model Innovation in ExcelThis 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 181 000 students including people working in EY, 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?Business Model Innovation is extremely hard. You not only have to come up with a good business idea but also it has to make economical sense. On top of that, you have to convince the customer to sacrifice short-term profits for the long-term perspective. Most consulting firms, don’t give you the full toolbox that you need. This may lead to huge frustration during consulting projects and a lot of inefficiencies.Therefore, I have decided to create this course that will help students understand the main methods to innovate. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects, devoted to business model innovation. You will master how to generate potential innovations, analyze data and draw conclusions from the analyses. On top of that, you see how other famous firms have used the tools that we will talk about.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of business model innovation. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who want to specialize in strategy or develop their own business. The course will help you become an expert in business model innovation on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:What frameworks, tools techniques you can use to Innovate your Business ModelHow others have implemented the InnovationHow to estimate the potential impact of the Business Model Innovation in ExcelYou can also ask me any question either through the discussion field 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 introduction to the course as well as some general info on how the course is organizedThe Business Model Canvas. To describe business models, you can use many tools. One of the most popular ones is the so-called Business Model Canvas. We will discuss it in this section.Innovation in Customer Segments. One of the biggest sources of innovation is to play with customer segments. In this section, we will discuss techniques that you can use to innovate in customer segments.Value Proposition Innovation. Another great source of innovation is to work on the Value Proposition. We will discuss in this section, what techniques you can use to innovate the Value Proposition.Modeling the Business in Excel. During M&A projects you will quite often have to create a model of the business in Excel. I will show you how to do that using a few examples.Valuation. During consulting projects, especially devoted to M&A or due diligence you will have to evaluate a specific business. In this section, I will show you examples of how to do it in practice.Innovation in Key Resources. Some firms resort to Innovation in the Key Resources department. We will discuss in this section how you can beat your competition by innovating in this area.Innovation in Key Activities. You can also look at Key Activities and innovate in this area as well. In this section, we will see how you can do that in practice.Innovation in Cost Structure. Firms, unfortunately, overlook innovations that can be done on the cost side. In this section, we will see what techniques can be used in this area and what have done some bold firms in this area.Innovation in Revenue Streams & Sales channels. Fast effects can be achieved by innovating Revenue Streams or playing with the Sales Channels. In this section, we will look at examples of techniques and case studies.Innovation in Key Partners. Some industries require you to innovate also in the area of Key Partners. Thanks to that you can build a powerful competitive advantage. In this section, we will look at some examples.Innovation in Customer Relationship. In many industries, we have seen many innovations in Customer Relationships. In the last section, we will look at some examples and techniques that may prove useful.You will be able also to download many additional resourcesUseful frameworks and techniquesAnalyses shown in the courseAdditional resourcesLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…How to innovate the business modelUnderstand the Business Model CanvasHow to estimate in Excel whether the innovation makes senseDesign Innovative Business ModelsHow Tesla, Disney, Apple, and Google have innovatedMaster Different Types of InnovationCreate Innovative Revenue StreamsCreate Innovation on the Cost SideDeliver Innovative Value PropositionCreate Innovation related to Key Resources & Key PartnersPractical Strategies that will accelerate the growth of your businessApply the Blue Ocean StrategyWho should take this course? Who should not?Management Consultants and Business AnalystsManagersStartup FoundersInvestment AnalystsManagers responsible for Acquisitions and MergersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

A practical guide on how to analyze marketplaces during consulting projects What you'll learn: Understand how the marketplaces business model worksAnalyze the performance of a marketplace in ExcelCreate a financial model of a marketplace in ExcelDefine the optimal strategy for starting and scaling a marketplaceOptimize the customer & supplier acquisition costs What is the aim of this course?More and more firms decide to build a marketplace on top of their existing businesses. Even with sufficient money, this is a pretty difficult undertaking. That is why they hire consultants to help them with this sort of project and build a successful marketplace.In the course you will learn the following things:What are the main drivers and challenges in the marketplace business modelHow to create a marketplaceHow to model the marketplace model in ExcelWhat kind of analyses you may have to do during consulting projectsHow to perform analyses fast and efficiently during consulting projectsHow to scale marketplacesHow to acquire customers and suppliers cost-efficientlyThis 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 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 220 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?Marketplaces are relatively new and complex businesses. You have to look both at the customer and supplier sides. It will be also challenging to build a marketplace if it is built on the back of an existing business. Those issues make it difficult to analyze such business during consulting projects. Most firms don’t give you the full toolbox that you need to do the analyses. This may lead to huge frustration during consulting projects and a lot of inefficiencies.Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need during consulting projects devoted to marketplaces. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during projects devoted to marketplaces. You will master how to analyze data and draw conclusions from the analyses. On top of that, you will also master the essential information related to scaling the business efficiently.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of the marketplaces business model. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that did not finish business school. The course will help you become an expert in marketplaces on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:What are the main drivers and challenges in the marketplace business modelHow to create a marketplaceHow to model the marketplace model in ExcelWhat kind of analyses you may have to do during consulting projectsHow to perform analyses fast and efficiently during consulting projectsHow to scale marketplacesHow to acquire customers and suppliers cost-efficientlyYou can also ask me any question either through the discussion field or by messaging me directly.How is the course organized?The course is divided currently into the following sections:Introduction. We begin with a little introduction to the course as well as some general info on how the course is organizedEssential Concepts. We will first look at the essential concepts that we will need to better understand the marketplace business model. They will help us with more advanced issues.Modeling Cash Flow in Marketplaces. In the previous section, you learned how to create a simple business model in Excel for a marketplace. In this section, we will concentrate on modeling the Cash Flow.How to create a marketplace. Creating a marketplace is one of the most difficult business challenges. In this section, we will discuss certain issues that will help you improve your attempts at building a marketplace.Funnel Analyses. Funnel Analysis can be used to map and analyze a series of events that lead to a particular goal. In this section, we will discuss what is a funnel analysis and how you can use it to achieve better business results.Customer Acquisition. Without customer acquisition, you will not enjoy much growth. In marketplaces, you will spend a lot of time on optimizing and finding more optimal ways to acquire customers. In this section, we will discuss this topic in more detail.Scaling Business. Scaling is one of the most difficult stages in building firms, especially in marketplaces. You have to be faster than the first of firms to become number one in a specific market. In this section, we will loo at general frameworks used in scaling and how Amazon scaled its operations.You will be able also to download many additional resources1. Useful frameworks and techniques2. Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth reading At the end of my course, students will be able to…Understand how the marketplace business model worksAnalyze the performance of a marketplace in ExcelCreate a financial model of a marketplace in ExcelDefine the optimal strategy for starting and scaling a marketplaceOptimize the customer & supplier acquisition costsWho should take this course? Who should not?Management ConsultantsBusiness AnalystsManagersFinancial ControllersInvestment AnalystsStartup FoundersManagers responsible for Acquisitions and MergersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

A practical guide on how to estimate the value of firms during consulting projects and do a company valuation What you'll learn: Understand main concepts used in company valuationEstimate the value of different firmsCreate in Excel financial models used for valuationDo the valuation of complex firms (with many business units)Estimate the value of firms with significant non-core assets What is the aim of this course?During many consulting projects, you will be asked to estimate the value of a firm or business units belonging to that firm. This will be especially true during strategic projects, due diligence projects, and M&A projects. That is why it is a good idea to master different valuation techniques and see how you can present the business model in Excel. In this course, I will teach you how to estimate the value of firms during consulting projects.In the course you will learn the following things:Essential concepts used in valuationWhat techniques you can use to estimate the value of the firmHow to create a simple financial model in ExcelHow to estimate the value of complex firms with many different business unitsHow to approach non-operating assets during the valuationWhat is Multiplier ArbitrageThis 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 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 200 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?Valuation is a pretty difficult task that you have to perform during most strategic projects. You have to master different skills and tools that you will be using during such projects, especially financial modeling, identifying synergies, and potential improvements. Most firms don’t give you the full toolbox that you need during such projects. This may lead to huge frustration during consulting projects that require doing valuation and a lot of inefficiencies.Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need to do the valuation of companies. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do when you will have to do company valuation. You will master how to analyze data and draw conclusions from the analyses.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of company valuation. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that did not finish business school. The course will help you become an expert in valuation on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:Essential concepts used in valuationWhat techniques you can use to estimate the value of the firmHow to create a simple financial model in ExcelHow to estimate the value of complex firms with many different business unitsHow to approach non-operating assets during the valuationWhat is Multiplier ArbitrageYou can also ask me any question either through the discussion field or by messaging me directly.How is the course organized?The course is divided currently into the following sections:Introduction. We begin with a little introduction to the course as well as some general info on how the course is organizedEssential Concepts. Every good methodology requires solid foundations. That’s why we will first look at essential concepts that are heavily used in valuation.Cash Flow. For some valuation methods extremely important is the Cash Flow. In this section, we will look at it in more detail.Essential Valuation Techniques. In valuation, we will usually use 2 groups of methods. We will discuss them in this section, using a ready-made financial model. Later, you will learn how to create such a model.Financial Modeling. As you have noticed to do valuation in some cases, we will have to create a financial model. We will see how this can be done relatively easily.Alternative Valuation Techniques. It’s difficult to estimate the value of the firm if it has low profits and low cash flow. In this section, we will see what alternative methods you can use in such situations.Valuation of Complex Firms. Many firms consist of many different businesses. Those businesses have different Cash Flows, Profits, and expected growth rates. In this section, we will see how we can approach the valuation of complex firms.Multiplier Arbitrage. Many firms use the so-called Multiplier Arbitrage to increase the value of a firm. In this section, we will look at the general concept and a case study devoted to this approach.You will be able also to download many additional resources1. Useful frameworks and techniques2. Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth readingAt the end of my course, students will be able to…Understand the main concepts used in company valuationEstimate the value of different firmsCreate in Excel financial models used for valuationDo the valuation of complex firms (with many business units)Estimate the value of firms with significant non-core assetsWho should take this course? Who should not?Management ConsultantsBusiness AnalystsManagersFinancial AnalystsInvestment AnalystsStartup FoundersManagers responsible for Acquisitions and MergersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

A practical guide on how to improve production and operations in a firm and analyze potential savings in Excel What you'll learn: Analyze production processImprove production process – make it faster, cheaper and at higher qualityCalculate in Excel the potential impact of proposed changesApply improvement techniques to other fields and industriesAnalyze in Excel potential investmentsPlan the increase of production capacityCreate optimal production plans What is the aim of this course? This course will help you drastically improve your knowledge and skills in optimizing the production and operations of any company through a series of practical cases. It is designed for people who want to become consultants, business analysts, or have to run and optimize production on a daily basis. In the course you will learn 3 things: How to understand any production or operational activities How to optimize the production and operations in order to get more things done, cheaper at higher quality with fewer resources Where to look for savings and improvements, how to calculate potential savings in Excel and implement themThis 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 300 000 students including people working in EY, 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 are terrible at organizing operational issues. They treat the operations, especially production, as a black box and try to avoid it at any cost. Technical things overwhelm them and they shy away from them. This approach is not the right one as you find elements that resemble production everywhere. In hospitals, most procedures performed are very similar to production issues. The same goes for running a call center, a chain of restaurants, a logistics company, or a firm delivering specialized services. Everywhere you have operations that you can optimize by using techniques that I will show in this course. Production influences heavily other areas, especially sales and marketing. Therefore, it is a good idea to have at least a general knowledge of production. The funny thing is that to be good at production you do not even have to be technical at all. I have not finished any technical school and I am pretty good at finding significant improvements in production. One of the best Production Directors I know has finished Pedagogical Studies.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 optimizing production. 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 production 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 find and analyze production. 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: How to understand the production How to optimize it Where to look for savings and improvement in production 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 into the following sections:Introduction. We begin with a little intro into the course as well as some general info on production Basic methods of improving production. In the second section, I will discuss the basic techniques that you can use to optimize your business. Here you will find the potential low-hanging fruits Continuous Flow. The ideal in production is the so-called continuous flow in which everything goes smoothly and fast. Products are being produced fast and cheaply. In this section, I will tell you how to achieve it. Advanced methods of improving production. In section 4 I will continue with more advanced ways in which you can improve your production such as SMED, TPM, Automation, Critical Chain Capacity management. Apart from optimizing the production you have to think strategically and know when you have to add a new capacity/factory. In this section, I will show you how you can do that Investment Analysis. In this section,I will show you how to analyze whether an investment makes sense or not. We will have a look at different case studies. We will analyze replacement investments, investments required by customers, cost-reducing investments, and investments in bottlenecksProduction planning. Production planning is the brain of production. If you get this wrong the other things won’t matter. In this section, I will show you some ways in which you can analyze and improve production planning You will be able also to download many additional resources Excels with analyses shown in the course Presentation of slides shown in the course Links to additional presentations and movies Links to books worth reading At the end of my course, students will be able to… Analyze production processImprove production process – make it faster, cheaper, and at higher qualityCalculate in Excel the potential impact of proposed changesApply improvement techniques to other fields and industriesWho should take this course? Who should not?ConsultantsProduction DirectorsBusiness analystsSmall and medium business ownersStartups foundersControllersWhat will students need to know or do before starting this course? Basic or intermediate ExcelBasic knowledge of economics or financeEnjoy the course!

A practical guide on how to train the best people to compete with McKinsey, Bain, BCG, PwC, EY What you'll learn: Design the optimal training system for you firmProduce fast and efficiently world class Business Analysts and Management ConsultantsEstimate the cost of training systemPick the optimal training system for your firmImplement the new training system at your firm What is the aim of this course?Having good people who can do a great job is the fundamental thing that every consulting firm has to secure. If you a smaller consulting firm you will struggle with attracting the best and brightest. Therefore, the training process at your firm is crucial. It will help you deliver great results for your customers and scale your business. However, training Business Analysts and Management Consultants is not easy. It takes a lot of time and effort to transform a freshman into a world-class Business Analyst. I had the pleasure of training numerous Management Consultants and Business Analysts who not only did a great job at consulting firms but later on went on to become partners and directors at PE funds, COO, CEO, CRO, and Directors. In this course, I will show you what processes and tools I have been using and I will teach you how to train your Business Analysts and Management Consultants efficiently (fast and with few resources). Thanks to the approach that I will show in this course you will have a significant competitive advantage over others.In the course you will learn the following things:How to define the profile of the ideal consultantWhat options are on the table when it comes to training consultants and business analystsHow to estimate the costs of every type of trainingHow to allocate time to trainingHow to build the training machine for your firmThis 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, 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?Smaller consulting firms struggle with training great Business Analysts and Management Consultants. They don’t have the resources and quite often they don’t have the experience to design training systems. We get a lot of questions from owners of such consulting firms regarding the training system. Consulting firms want to scale operations but for that to happen they have to also train more people. Given the turnover, they also have to do it faster and cheaper than the big firms. I have been very good at transforming fast and efficiently freshmen into world-class Business Analysts and Management Consultants so I have decided to share my experience and methods that helped me achieve that.To sum it up, the course will help you scale your consulting business and create a training machine that will constantly create great analysts and consultants for your practice. That is why, I highly recommend this course not only to owners, and directors of consulting firms that want to scale their businesses. It will be also extremely useful for other professional services in which you have to train your people extensively: law firms, business process outsourcing firms, PE, and VC funds.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 of training and drastically increase the quality of the analysts, and consultants that you create. 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 learn: How to define the profile of the ideal employeeWhat options are on the table when it comes to training consultants and business analystsHow to estimate the costs of every type of trainingHow to allocate time to trainingHow to build the training machine for your firmYou can also ask me any question either through the discussion field 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 how the course is organizedThe ideal Business Analyst and Management Consultant. In the second section, I will show you how to define the ideal profile of an employee. For that, we will use management consultants as an example. We will also talk about all the elements around the employee that you have to create to make sure that the business analysts/consultants are working efficientlyComponents of the training machine. In this section, I will discuss what options you can use to train business analysts and management consultants. We will discuss things like Lesson Learnt, Project Database, Offline Courses, Online Courses, Workshops, Prob-Bono projects, Frameworks, MentorshipHow big does the training machine have to be? In this section, I will show you how to estimate the costs of training for different types of training. You will get ready-made templates that you can use to estimate the costs in your firmHow to allocate time for training. In this section, we will discuss how to allocate time to training, both content creation as well as consumption of the content created by business analysts and consultantsHow to build the training machine. In the last section, I will show you how to build the training system in practice. I will first show you the whole process and we will discuss each and every element of this process that at the end will help you deliver the target. There will be plenty of case studies that will teach you how to make certain choices when it comes to the training process.You will be able also to download many additional resources Ready-made analyses that you can use for your firmTools that you can use for your firmList of useful resourcesLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…Design the optimal training system for your firmProduce fast and efficiently world-class Business Analysts and Management ConsultantsEstimate the cost of the training systemImplement the new training system at your firmWho should take this course? Who should not?Owners and Partners at consulting firmsOwners and Partners at law firmsOwners and Partners at other professional service firmsDirectors in Business Process Outsourcing firmsHR DirectorsPartners at PE or VC fundsWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics or finance

A practical guide how to improve supply chain in a firm and analyze potential savings in Excel during consulting project What you'll learn: Analyze supply chainImprove supply chain – make it faster, cheaper and require less inventoryCalculate in Excel the potential impact of proposed changesFind strategic fit for the supply chainImprove supply chain in Retail, FMCG, SMCG, commodityApply improvement techniques to other fields and industries What is the aim of this course?This course will help you drastically improve your knowledge and skills in optimizing any company's supply chain through a series of practical cases. It is designed for people who want to become management consultants, business analysts or have to run and optimize supply chai on a daily basis. In the course you will learn 3 things: How to understand supply chain activities How to optimize the supply chain to get more things done, cheaper at higher quality with fewer resources Where to look for savings and improvements, how to calculate potential savings in Excel and implement themThis 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. Based on 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, COOs, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 300 000 students including people working in EY, 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 are terrible at organizing operational issues. They treat the operations, especially the supply chain, as a black box and try to avoid it at any cost. Technical things overwhelm them and they shy away from them. This approach is not the right one as you find elements of the supply chain in every business. To make matters worse supply chain efficiency and performance have a huge impact on the ability of any business to compete and grow. Everywhere you have some supply chain that you can optimize by using techniques that I will show in this course. Supply chains influence heavily other areas especially sales and marketing as well as production. Therefore, it is a good idea to have at least a general knowledge of the supply chain. The funny thing is that you do not even have to be technical at all to be good at the supply chain. I have not finished any technical school and I am pretty good at finding significant improvements in the supply chain. 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 optimizing the supply chain. 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 supply chain managers, and 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 find and analyze the supply chain. There is little theory – mainly examples, a lot of tips from my own experience, and other notable examples worth mentioning. We intend that thanks to the course you will know: How to understand the supply chain How to optimize the supply chain Where to look for savings and improvements How to calculate the impact of proposed changes in Excel How to find the strategic fit when it comes to the supply chain You can also ask me any question either through the discussion field 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 General information on Supply Chain. In the second section, I will discuss the strategic part of the supply chain, how to find the strategic fit, and what aspect you have to pay attention to.Retail - Examples of business analyses of Supply Chain. This section will start a series of sections devoted to a specific type of business where are will show you detailed cases. In this section, I will show you an overview of the Retail Supply Chain, the main challenges, and a series of cases that will show you how to reach the full potential of the supply chain.FMCG - Examples of business analyses of Supply Chain. In the 4th section, I will show you an overview of the FMCG Supply Chain, the main challenges, and a series of cases that will show you how to reach the full potential of the Supply Chain.SMCG - Examples of business analyses of Supply Chain. In the 5th section, I will show you an overview of the SMCG Supply Chain, the main challenges, and a series of cases that will show you how to reach the full potential of the Supply Chain.Commodity - Examples of business analyses of Supply Chain. In this section, I will show you an overview of the Commodity Supply Chain, the main challenges, and a series of cases that will show you how to reach the full potential of the Supply Chain.Distribution model - general information. Distribution (logistics and warehousing) is the powerhouse of the supply chain moving physically the goods. In this section, I will show you: the goals of the distribution model, the basic laws of distribution, different types of distribution, Where you can find savings, and typical problems in Distribution.Sales forecasting and customer service - general information. Sales forecasting gives the input data for the whole supply chain. Even small glitches in this part cause huge problems in the whole supply chain. In this section, I will show you: the goals of sales forecasting, Sales forecasting, customer service value drivers, and typical problems in sales forecasting and customer service.Production planning - general information. Production planning is the brain of the supply chain. If you get this wrong the other things won’t matter. In this section, I will show you: the goals of production planning, production planning value drivers, and typical problems in production planning.Purchasing - general information. Purchasing has a big impact not only on cost but also the inventory levels. The wrong quality of products bought will lead to problems both in sales and in production. In this section, I will show you: the goals of purchasing, purchasing value drivers, and typical problems in purchasing.You will be able also to download many additional resources Excels with analyses shown in the course Presentation of slides shown in the course Links to additional presentations and movies Links to books worth readingAdditional Resources

A practical guide on how to model, analyze and improve e-commerce businesses What you'll learn: The drivers of the e-commerce business modelConduct analyses of e-commerce in Excel during consulting projectsHow to model e-commerce business in ExcelHow to analyze potential improvements in e-commerceHow to model marketplacesHow to do funnel analysis in e-commerceHow to measure and lower the costs of acquiring customers (CAC)How to measure and increase the Lifetime Value of the Customer (LTV) What is the aim of this course?The share of online purchases is constantly growing. We have a lot of pure players, but also traditional businesses that build their own e-commerce business units. Consulting firms are quite often hired to help analyze and improve e-commerce businesses. Those projects are interesting yet challenging. Luckily, there are a lot of interesting techniques and frameworks that will help you analyze and model e-commerce during consulting projects. In this course, I will teach how to perform fast and efficiently different types of analyses related to e-commerce.In the course, you will learn the following things:The drivers of the e-commerce business modelConduct analyses of e-commerce in Excel during consulting projectsHow to model an e-commerce business in ExcelHow to analyze potential improvements in e-commerceHow to model marketplacesHow to do funnel analysis in e-commerceHow to measure and lower the costs of acquiring customers (CAC)How to measure and increase the Lifetime Value of the Customer (LTV)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 the 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 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 are now 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 have already been taken by more than 315 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 Excel files as well as additional presentations and materials shown in the lectures. Therefore, 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?E-commerce has become an important business unit for the majority of Retailers and Consumer Brands (especially FMCG and SMCG). It behaves differently from traditional businesses, and you have to adjust your approach to the new situation. Most firms don’t give you the full toolbox that you need. This may lead to huge frustration during consulting projects and a lot of inefficiencies.Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they will need during consulting projects devoted to e-commerce. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects devoted to e-commerce. You will master how to analyze data and draw conclusions from the analyses.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst, you have to have a pretty decent understanding of the e-commerce business model. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish business school. The course will help you become an expert in e-commerce at the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand and analyze businesses. 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 learn:The drivers of the e-commerce business modelConduct analyses of e-commerce in Excel during consulting projectsHow to model an e-commerce business in ExcelHow to analyze potential improvements in e-commerceHow to model marketplacesHow to do funnel analysis in e-commerceYou can also ask me any questions either through the discussion field or by messaging me directly.How is the course organized?The course is currently divided into the following sections:Introduction. We begin with a little introduction to the course, as well as some general info on how the course is organizedEssential Concepts. We will start with some essential concepts around e-commerce. This will help us later on with more advanced issues. We will also see how to create a basic e-commerce model in Excel.Modeling Cash Flow in e-commerce. In the previous section, we showed you how to do a simple business model in Excel for e-commerce. In this section, we will concentrate on modeling the Cash Flow in a simple way.Funnel Analysis. Funnel Analysis can be used to map and analyze a series of events that lead to a particular goal. In this section, we will discuss what a funnel analysis is and how you can use it to achieve better business results.Sales Funnels by Cohorts. Quite often, you want to go deeper and analyze what the sales funnel looks like for different segments and cohorts. This is when cohort analysis comes in handy. We will discuss it in this section.Advanced model of e-commerce. In some cases, you will have to create more complex models of e-commerce. In this section, we will see how this can be done in practice.Customer Acquisition. Without customer acquisition, you will not enjoy much growth. In e-commerce, you will spend a lot of time optimizing and finding more optimal ways to acquire customers. In this section, you will learn how to analyze and optimize customer acquisition.2-sided market. Many e-commerce businesses will try to expand their business by becoming a marketplace, which is a type of 2-sided market. We will discuss it in this section.Multichannel. In this section, we will discuss the so-called multichannel, and I will show you the main challenges in this conceptYou will also be able to download many additional resourcesUseful frameworks and techniquesAnalyses showed in the courseAdditional resourcesLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will learn:The drivers of the e-commerce business modelConduct analyses of e-commerce in Excel during consulting projectsHow to model an e-commerce business in ExcelHow to analyze potential improvements in e-commerceHow to model marketplacesHow to do funnel analysis in e-commerceWho should take this course?Management ConsultantsBusiness AnalystsManagersFinancial ControllersInvestment AnalystsStartup FoundersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

A practical guide with cases studies how to analyze and improve a retail business during management consulting projects What you'll learn: Analyze retail business and find improvements especially low hanging fruitsModel the retail business in Excel and draw conclusions out of thisOptimize retail operations – make them faster, cheaper and at higher qualityYou will be able to build expansion strategyYou will know what to look for when you move to multichannelYou will learn how to analyze the behavior of customers in the stores What is the aim of this course? Retail has become very competitive. We have the rise of e-commerce and multichannel, and buyers' behavior has also changed drastically. This leads to lower margins. As a Business Analyst or Management Consultant, you have to be able to analyze the Retailer you work for fast and find possible improvements. This course will help you drastically improve your knowledge and skills in optimizing Retail business through a series of practical cases. It is designed for people who want to become consultants, business analysts or have to run and optimize Retail business on a daily basis. In the course you will learn 6 things: How to analyze Retailer and find low-hanging fruits How to build the business model of the Retailer in Excel in order to see the big picture and see how specific KPIs impact the profit How to optimize Retailers' operations How to behave in a multichannel surrounding (when you have also e-commerce operations) How to expand your business into new categories and markets How to analyze in-store engagements There will be also many growth hacks that Retailers use. The course is based on my 15 years of experience in Retail as well as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement, and turn-arounds in the biggest companies from Retail, FMCG, SMG, and B2B sectors that I worked for. I worked for retailers in home improvements, pharmaceuticals, vending, kids products, convenience stores, electronics, wood products, and many more so what you will see in this course are observations drawn from many industries. 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 over 100 consultants, business analysts, and managers who now are CEOs, Operational Directors, COOs, Investment Directors, Directors in Consulting Companies, Board Members, Customer Insight Managers, Data Science Managers, etc. On top of that my courses on Udemy have already been taken by more than 300 000 students. The course you will take has been taken also by people from EY, McKinsey, PwC, Walmart, Booz Allen Hamilton, Dell, Walgreens, and many more as a part of Udemy for Business.I teach through cases so most of the lectures are case studies showing some business problems solved in Excel. There will be also an overview of the main techniques used in optimizing and running retail. To every lecture, you will find attached (in additional resources) the Excels shown in the lecture 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 in your work. Why have I decided to create this course? Retail has become quite complex and there is a shortage of business analysts and consultants that have a good understanding of how to approach retail. There is a lack of knowledge on how to get a broader view of the retail business and at the same time to be able to go deep into details. Even people working for years in retail have problems with seeing the whole picture and being able to find potential savings. Therefore, I have decided to create a course that will bridge this gap. This course will transform you into a retail expert in a relatively short time and help you see all the elements of the business. The approach you will see in this course was tested on humans and I have seen tremendous positive results. Thanks to this course you will become a priceless member of any team that is doing strategic and operational improvements projects in retail. It will help you land a job not only with retailers but also with consulting firms, and private equities investing in retail. To sum it up, I believe that if you want to build or to find improvements in retail you should master the techniques shown in this course. That is why I highly recommend this course not only to consultants or business analysts that have to advise their customers but also to retail managers, and analysts already working in retail or in PE.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 find and analyze production. 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: How to analyze Retailer and find low-hanging fruits How to build the business model of the Retailer in Excel in order to see the big picture and see how specific KPIs impact the profit How to optimize Retailers' operations How to behave in a multichannel surrounding (when you have also e-commerce operations) How to expand your business into new categories and markets How to analyze in-store engagementsYou 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 retail Basic analyses that you should perform. In the second section, I will discuss the basic type of analysis that you can use to better understand the business that you work for. Here you will find the potential low-hanging fruits Retail Business Model. As a business analyst or consultant, you may be asked to model the whole business in Excel. I will show you in this section how to do it and you will get ready-made models. I will also show you how to model e-commerce. Optimization of in-store processes – case study. In section 4 I show you how to optimize processes in the store. I will use here a real case of a company from the home improvement / DIY sector. You will get also the model we used to calculate costs Business Hacks used by Retailers. It is always good to look at what others are doing. Here I will show you some hacks used by other retailers Expansion. At some point, you will start considering expansion. I will show you in this section how you can expand your retail business and how to decide what to do Multichannel. As e-commerce has been a significant distribution channel traditional retailers were forced to transform into multichannel players (operating both in traditional stores, the offline world as well as online business) Here I will show you the main challenges and how to tackle them In-store engagement and productivity analysis. If you have data on the customer behavior in the store you can get nice insight and craft a better strategy to grow your business. Here I will show you examples of such analyses that we did with Retailnext – a system to collect data on customer behavior in the store. You will be able also to download many additional resources:Excels with analyses shown in the coursePresentation of slides shown in the course Links to additional presentations and movies Links to books worth reading

A practical guide on how to analyze in Excel and improve consumer goods business during consulting projects What you'll learn: Model consumer goods (FMCG) business in ExcelAnalyze sales and marketing in FMCGIncrease profits by optimizing sales and marketing in consumer goods businessAnalyze supply chain in FMCGImprove supply chain in consumer goods businessReduce costs and improve results in consumer goods business especially in FMCG What is the aim of this course? Consulting projects especially when it comes to the consumer goods business are very demanding. The two most complicated areas are sales and marketing and the supply chain. During consulting projects, I have seen business analysts and management consultants struggling to understand the business fast enough to deliver value to the customer. This course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project in a consumer goods business much easier. This course will help you drastically improve your knowledge and skills in analyzing and improving Fast Moving Consumer Goods businesses (FMCG). It is designed for people who want to become management consultants, and business analysts or have to run and optimize FMCG businesses on a daily basis. In the course you will learn 3 things: How to model FMCG business in Excel How to improve sales and marketing in order to increase margin and profit How to improve the supply chain in order to increase margin and profitThis 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 300 000 students including people working in EY, 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? Consulting projects especially when it comes to the consumer goods business are very demanding. The two most complicated areas are sales and marketing and supply chain. During consulting projects, I have seen business analysts and management consultants struggling to understand the business fast enough to deliver value to the customer. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project in a consumer goods business much easier. Thanks to this course, you will know what and how to do during a consulting project devoted to an FMCG company. I will show you also how to model FMCG business in Excel. To sum it up, I believe that if you want to build or to find improvements in the FMCG business you should master techniques related to analyzing and optimizing sales and marketing as well as the supply chain. That is why, I highly recommend this course not only to consultants or business analysts that have to advise their customers but also to owners, founders of businesses as well as 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 find and analyze FMCG business. 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 learn: How to understand and improve sales and marketing in FMCG How to understand and improve the supply chain in FMCG How to model FMCG business in Excel You can also ask me any question either through the discussion field or by messaging me directly. How the course is organized? The course is divided into the following sections: Introduction. We begin with a little intro to the course. Modeling FMCG business in Excel. In the second section, I will show you how to model an Excel FMCG business. You will also get as a part of it Excel files to play with. I will use an example cosmetics business Sales and Marketing in FMCG. In this section, I will show you examples of analysis of sales and marketing in the FMCG business. This will give you a good idea of what to concentrate on during a consulting project FMCG - Examples of business analyses ofthe Supply Chain. In this section, I will show you examples of analysis of supply chain in FMCGbusiness. This will give you a good idea of what to concentrate on during a consulting project I will be adding new sections and lectures in the coming months You will also be able to download many additional resources Excels with analyses shown in the course Presentation of slides shown in the course Links to additional presentations and movies Links to books worth reading

A practical guide on how to use Excel Tables during consulting projects. What you'll learn: How to create and modify Excel TablesCreate functions based on Excel TablesHow to create dynamic chartsHow to use Pivot Tables and Pivot ChartsUse the Data ModelBuild relationships between Excel Tables in the Data ModelCreate simple Power Pivots A practical guide on how to use Excel Tables during consulting projects.What is the aim of this course?During the first 2 years, you will be heavily using Excel to do analyses for the customers. On average, you will spend 4-6 hours a day working in Excel. In many situations, you can speed up your work and make your analyses more dynamic, by using the so-called Excel Tables. In this course, I will teach you how to use Excel Tables during consulting projects.In the course you will learn the following things:How do Excel Tables differ from regular calculations in Excel?How to create and use Excel Tables.How to create dynamic drop-down lists and dynamic charts using Excel Tables,How to link Excel Tables in the Data Model and use Power Pivot.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?Excel Tables are not widely understood by most Management Consultants. They not only help you do dynamic tools like dynamic drop-down lists, project charters, and Gantt charts but are also necessary components of Power Pivots (Pivot Tables using data from different sources). Once you master Excel Tables you will be able to understand much faster tools like Power Query, Power Pivots, and Power BI. Therefore, I have decided to create this course that will help students understand or refresh their knowledge of Excel Tables. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know how and when to use Excel Tables during consulting projects.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of Excel Tables. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who spend a lot of time analyzing data in Excel. The course will help you become an expert in Excel Tables on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:How do Excel Tables differ from regular calculations in Excel?How to create and use Excel Tables.How to create dynamic drop-down lists and dynamic charts using Excel Tables,How to link Excel Tables in the Data Model and use Power Pivot.You can also ask me any question either through the discussion field 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 introduction to the course as well as some general info on how the course is organizedEssentials. Excel Tables use a totally different approach than the regular functions that you will be using most of the time. In this section, we will look at the basic characteristics of Excel Tables.Slicers in Excel Tables. Slicers enable you to create with the use of Excel Tables and advanced tools. In this section, we will see how you can use them to create Gant Charts, to-do lists, and dynamic drop-down lists.Essential Pivot Tables. Excel Tables are especially powerful if they are combined with Pivot Tables. In this section, you will learn how to use Pivot Tables and Pivot Charts.Dynamic Charts in Excel. In some cases, you will want to make your charts more dynamic so they can readjust to changes in parameters or questions asked. In this section, I will show you how to achieve it in Excel.The Data Model. With more complicated calculations, you may have more than 1 data set. If they are put in the form of Excel Tables, you can connect them to simplify your life. This section will show you how to use the Data Model, link Excel Tables, and create simple Power Pivots.You will also be able to download many additional resources1. Useful frameworks and techniques2. Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth readingAt the end of my course, students will be able to…How to create and modify Excel TablesDo functions based on Excel TablesHow to create dynamic chartsHow to use Pivot Tables and Pivot ChartsUse the Data ModelBuild relationships between Excel Tables in the Data ModelCreate simple Power PivotsWho should take this course? Who should not?Management Consultants Business AnalystsFinancial ControllersInvestment AnalystsProject ManagersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics

A practical guide on how to analyze in Excel and improve consumer goods businesses during consulting projects What you'll learn: How to model consumer good (SMCG) businesses in ExcelAnalyze sales and marketing in SMCG businessesIncrease profits by optimizing sales and marketing in consumer goods businessAnalyze supply chain in SMCGImprove supply chain in consumer goods businessMaster approach and tricks used by top consulting firms such as McKinsey, BCG, BainHow to estimate the value of consumer baseModel SMCG as a service business What is the aim of this course?Consulting projects especially when it comes to the consumer goods business are very demanding. The two most complicated areas are sales and marketing and the supply chain. During consulting projects, I have seen business analysts and management consultants struggling to understand the business fast enough to deliver value to the customer. This course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project in a consumer goods business much easier.This course will help you drastically improve your knowledge and skills in analyzing and improving Slow Moving Consumer Goods businesses (SMCG) such as furniture, smartphones, cars, etc. It is designed for people who want to become management consultants, and business analysts or have to run and optimize SMCG businesses on daily basis. In the course, you will learn 4 things:How to model SMCG business in ExcelHow to improve sales and marketing in order to increase margin and profitHow to improve the supply chain in order to increase margin and profitHow the move from selling a product to selling a service will impact the businessThis 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, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.I teach through cases, so most of the lectures are case studies showing some business problems solved in Excel. There will be also an overview of the main challenges in sales and marketing as well as the supply chain typical for SMCG. To every lecture, you will find attached (in additional resources) the Excels shown in the lecture 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 in your work.Why have I decided to create this course?Consulting projects especially when it comes to the consumer goods business are very demanding. The two most complicated areas are sales and marketing and the supply chain. During consulting projects, I have seen business analysts and management consultants struggling to understand the business fast enough to deliver value to the customer. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project in a consumer goods business much easier. Thanks to this course, you will know what and how to do during a consulting project devoted to an SMCG company. I will show you also how to model the SMCG business in Excel.To sum it up, I believe that if you want to build or to find improvements in SMCG business you should master techniques related to analyzing and optimizing sales and marketing as well as the supply chain. That is why, I highly recommend this course not only to consultants or business analysts that have to advise their customers but also to owners, founders of businesses as well as 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 find and analyze SMCG business. There is little theory – mainly examples, and case studies with 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 learn:How to understand and improve sales and marketing in SMCGHow to understand and improve the supply chain in SMCGHow to model SMCG business in ExcelHow to model for relatively new things in SMCG like customer base and switching from selling a product to selling a serviceYou can also ask me any question either through the discussion field or by messaging me directly.How the course is organized?The course is divided into the following sections:Introduction. We begin with a little intro to the course. I will show you here what you can expect from this course and how it is organizedModeling SMCG business in Excel. In the second section, I will show you how to model in Excel SMCG businesses. You will also get as a part of it Excel files to play with. I will use here 2 examples. We will model the SMCG in the traditional way (selling a product) and in an alternative way (selling services). We will here use the case study of smartphones and vacuum cleaner producersSales and Marketing in SMCG. In this section, I will show you examples of analyses of sales and marketing in the SMCG business. This will give you a good idea of what to concentrate on during a consulting projectExamples of business analyses of Supply Chain in SMCG. In the 4th section, I will show you examples of analyses of the supply chain in the SMCG business. This will give you a good idea of what to concentrate on during a consulting project.You will be able also to download many additional resourcesExcels with analyses shown in the coursePresentation of slides shown in the courseLinks to additional presentations and moviesLinks to books worth readingAt the end of my course, students will be able to…How to model consumer goods (SMCG) business in ExcelAnalyze sales and marketing in SMCGIncrease profits by optimizing sales and marketing in the consumer goods businessAnalyze the supply chain in SMCGImprove supply chain in consumer goods businessHow to estimate the value of the consumer baseModel SMCG as a service businessWho should take this course? Who should not?Management ConsultantsBusiness AnalystsDirectorsStartups foundersControllersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics or finance

A practical guide on how to do analyses during mergers & acquisition projects What you'll learn: How to conduct fast and efficiently analyses in Excel during M&A projectsHow to select potential targets for M&AHow to estimate in Excel potential synergies from M&AHow to conduct commercial due diligenceWhat market research tools are useful during M&A and due diligence?Essential Valuation techniques used in M&AWhen mergers and acquisitions make sense.Create a business model of the firm in ExcelAnalyze business units What is the aim of this course?Consulting firms are hired very often to help with Mergers & Acquisitions. Those projects are difficult as you have to deliver results fast and you have to deal with many stakeholders. You not only have to help select potential targets, and model businesses in Excel, but also you will have to estimate the potential benefits of M&A, the value of the firm, and forecast the development of the acquired firms. In this course, I will teach how to perform fast and efficiently different types of analyses during M&A projects.In the course you will learn the following things:What kind of analyses you may have to do during the M&A projectHow to Select Potential Targets for M&A using ExcelHow to create a financial model in Excel for M&A purposesHow to estimate the value of the M&A targetHow to estimate potential synergies coming from the M&A processHow to conduct commercial due diligenceWhat kind of market research tools you can use during due diligenceThis 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 300 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 did I decide to create this course?M&A projects are fast-paced and require a lot of hard work. You have to also master different skills and tools that you will be using during such projects especially: financial modeling, market research, identifying synergies, and potential improvements. Most firms, don’t give you the full toolbox that you need. This may lead to huge frustration during M&A projects and a lot of inefficiencies.Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need during M&A projects. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do it during M&A projects. You will master how to analyze data and draw conclusions from the analyses. On top of that, you will also master the essential information related to valuation.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of M&A projects and analyses done during such projects. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish business school or Economics. The course will help you become an expert in M&A analyses on the level of McKinsey, BCG, Bain, and other top consulting firms.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 understand, and analyze businesses. 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 learn:What kind of analyses you may have to do during the M&A projectHow to Select Potential Targets for M&A using ExcelHow to create a financial model in Excel for M&A purposesHow to estimate the value of the M&A targetHow to estimate potential synergies coming from the M&A process How to conduct commercial due diligenceWhat kind of market research tools you can use during due diligenceYou can also ask me any questions either through the discussion field or by messaging me directly.How the course is organized?Currently, you will find the following things in the course:Introduction. We begin with a little intro to the course as well as some general info on how the course is organizedWhen M&A is done? Mergers & acquisitions are done for a lot of reasons by different players. In this section, we will discuss how they differ and why they invest so much money in M&A.M&A process. In this brief section, I will shed some light on what the M&A process looks like.Selecting Potential Targets. M&A starts with picking the right targets that make sense. In this section, I will show you how you can do that in practice using Excel. We will conduct analyses of potential targets in different industries.Modeling Businesses in Excel. During M&A projects you will quite often have to create a model of the business in Excel. I will show you how to do that using a few examples.Valuation. During consulting projects, especially devoted to M&A or due diligence you will have to evaluate a specific business. In this section, I will show you examples of how to do it in practice.Estimating Potential Impact. In this section, I will show you how to estimate the potential benefit coming from M&A. We will do it in Excel for a few interesting case studies.Commercial Due Diligence. A lot of effort from Management Consultants goes into the Commercial Due Diligence stage of the M&A Process. We will have a look at some things that are important during this stage.Requesting Data from the Target Company & Independent Data Gathering. In the next 6 short sections, we will discuss how you can collect data required for commercial due diligence.Discussion of the results. In the last section, we will briefly give you some tips on how to discuss the results of commercial due diligence with the customer.You will be able also to download many additional resourcesUseful frameworks and techniquesAnalyses that are shown in the courseAdditional resourcesLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…How to conduct fast and efficiently analyses in Excel during M&A projectsHow to select potential targets for M&AHow to estimate in Excel potential synergies from M&AHow to conduct commercial due diligenceWhat market research tools are useful during M&A and due diligence?Essential Valuation techniques used in M&AWhen mergers and acquisitions make sense.Create a business model of the firm in ExcelAnalyze business unitsWho should take this course? Who should not?Management Consultants and Business AnalystsManagersFinancial ControllersInvestment AnalystsStartup FoundersProject ManagersManagers responsible for Acquisitions and MergersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting

A practical guide on how to plan, manage and develop your career What you'll learn: Understand how to manage your career in consultingHow to get promoted fastHow to set goalsHow to achieve goalsWhat options do you have when you leave consultingHow to be more efficient What is the aim of this course?Management Consulting is a great starting point for your career. It gives you a lot of knowledge and opens a lot of doors. However, if you want to make the most out of management consulting, you should actively manage your career and do a little bit of planning as well as strategic thinking. In this course, I will show you how you can speed up your career in consulting and how to get the dream job afterward.In the course you will learn the following things:How to make optimal decisions when it comes to your careerHow to set and achieve goalsHow to get promoted fastWhat options do you have when it comes to a career once you have joined the consultingHow to make sure that you move fast up the corporate ladderThis 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 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 234 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 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?Managing a career in consulting is pretty difficult as you have plenty of options and no clear path that will lead you to success. Most people in consulting struggle to pick the optimal for them path and don’t know to move forward fast. This may lead to huge frustration and a lot of inefficiencies.Therefore, I have decided to create this course that will help students manage their careers in consulting. The course will give you the knowledge and insight into real-life case studies that will help you get promoted faster. You will learn how to pick the right career path for you. Thanks to this course, you will know what to do to be a successful Management Consultant and you will master how to set and achieve goals. On top of that, you will also learn how to manage your career efficiently.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of how to manage your career in consulting. That is why, I highly recommend this course to Management Consultants or Business Analysts, The course will help you manage your career in consulting firms including, EY, Deloitte, McKinsey, BCG, Bain, and other top consulting firms.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 manage things important for your career. 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 learn:How to make optimal decisions when it comes to your careerHow to set and achieve goalsHow to get promoted fastWhat options do you have when it comes to a career once you have joined the consultingHow to make sure that you move fast up the corporate ladderYou can also ask me any question either through the discussion field or by messaging me directly.How is the course organized?The course is divided currently into the following sections:Introduction. We begin with a little introduction to the course as well as some general info on how the course is organizedEssential Concepts in Career Management. Before we talk about speeding up your career, let’s first see what options are on the table in management consulting and what choices you will be making.How to achieve goals. Achieving goals is in most cases not easy. However, there are some interesting techniques that will make your journey faster and easier. In this section, you will learn how to define and achieve goals.How to get promoted. In this section, we will talk about general rules that will get you promoted. Those tips will be useful no matter what career path you choose.The Consulting Path. In this section, we will look in more detail at the career path in management consulting. We will give you some hints that may help you get promoted faster in consulting.How to be a badass manager. In this section, I will give you some practical tips that will help you become a great manager.You will be able also to download many additional resources1. Useful frameworks and techniques2. Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth readingAt the end of my course, students will be able to…Understand how to manage your career in consultingHow to get promoted fastHow to set goalsHow to achieve goalsWhat options do you have when you leave consultingHow to be more efficientWho should take this course? Who should not?Management ConsultantsBusiness AnalystsInvestment AnalystsStartup FoundersProject ManagersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting