Courses

Unlock ChatGPT's Potential: User Research, PRDs, and Requirements with ChatGPT and AI-Powered Prompt Engineering What you'll learn: How to use chatGPT to conduct market researchUse ChatGPT to identify customer's pain points & build user personaUse chatGPT to write product requirements, epics & user storiesUse ChatGPT to identify KPIs & success metricsUse chatGPT for prioritizationAnd much for Product management, Business analysis & Consulting. Unlock the full potential of ChatGPT in product management, business analysis, and consulting with our comprehensive program. This course equips you with the skills to leverage ChatGPT for creating, managing, and optimizing end-to-end digital products. Whether you're a product manager, business analyst, or consultant, you'll discover how to seamlessly integrate ChatGPT into your workflow to enhance customer research, streamline decision-making, and accelerate product development. Through practical, real-world scenarios, you’ll learn to: Conduct user research, define personas, and map customer journeys using ChatGPT.Automate and improve business analysis, from gathering requirements to stakeholder communications.Create detailed product roadmaps, feature prioritization, and execution strategies with AI.Collaborate more effectively with teams by using ChatGPT for ideation, brainstorming, and problem-solving. By the end of this course, you'll have the tools and knowledge to use ChatGPT as a strategic asset, driving efficiency and innovation in building digital products from concept to launch. Take your product management and business analysis expertise to the next level with the power of AI! So if you're looking for a way to optimize your workflow and stay ahead of the competition, sign up for our ChatGPT Course for Product Managers and Business Analysts today! Transform Your Workflow: End-to-End Product Development with ChatGPT

A practical guide on how to create a killer presentation efficiently with examples from management consulting What you'll learn: Create a great presentation in the style of top consulting firmsPut your analyses on slidesExpress yourself with slidesRead and understand consulting presentationCreate the flow in the story told via presentationPick the right slides for present analyses What is the aim of this course?As a business analyst or management consultant,you are delivering your advice, observation, and analyses using presentations. During some projects, you may be producing as many as 200-300 slides. Slide preparation is very time-consuming and you have to make sure that you structure your work properly to deliver according to promised deadlines. In this course, you will learn how to prepare a great presentation for your customer that will help you deliver your thoughts in a coherent manner and win him over. I will teach you how to prepare the presentation in the right order so you do not waste your time. You will also learn what type of slides you can consider and when you should use a specific type of slide. You will also find in the course examples of presentations from management consulting along with useful templates you can use for your own goals.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 in 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, using the 80/20 rule so most of the lectures will be case studies showing examples of how to put something on a slide. Those slides are based on real-life examples. You will also learn the order in which you should do things in order to deliver nice, coherent, and understood by your customer, presentations within the deadlines. For every lecture, you will also find attached additional resources. Thanks to this, as a part of this course you will also get a library of ready-made materials that will help you in your first year as a business analyst / junior consultant.Why have I decided to create this course?Presentations are not something people learn in school or even at universities. For most people, it is difficult to read presentations and express themselves using slides. Many people, experience also in the beginning problems in proper structuring of the whole presentation. They cannot make it understandable for the customer and quite often the presentation lacks flow. The biggest problem in consulting is that the presentation determines the analyses that you have to make. If your presentation draft is not well structured and thought-through you will not be efficient with interviews, data gathering, and analyses. Therefore, I found it critical to teach all my co-workers and employees how to express themselves. In this way, I made their work (not only related to presentation) much more efficient and also my life much easier :). Learn from this course and apply it also in your workIn what way will you benefit from this course?The course is a practical, step-by-step guide loaded with tons of cases, tricks, and hints that will significantly improve the speed with which you work. You will learn how to prepare a great presentation both for internal as well as external purposes. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. My intention is that thanks to the course you will know:How to structure the subject that the presentation is addressing?In what order you should approach the preparation of the presentation?How to prepare the sketch and the template of the presentation?What type of slides and when you can use them?You can also ask me any question either through the discussion mode or by messaging me directly.How the course is organized?The course is divided currently into 7 sections. Currently, you will find the following sections:Introduction.We begin with a little intro into the course as well as some general info on the role of presentation in consulting and when you actually prepare presentationsCreating the template.In the second section, how to go from a general idea (i.e. from an issue tree) to a sketch and how to transform the sketch into a templateFilling in the slides. In the next section, I will talk about general rules concerning the filling in the slides, the flow that you achieve, and how different is the template vs the end-productDelivery of the presentation.In section 4 we will talk briefly about the delivery of the presentation: how to do it and how different is the written presentation from the presentation that can be delivered to the audience.Types of charts you can use. In section 5 I will go through many types of slides and will show you what you can use for a specific purposeExample of presentations.In the next section, I show examples of real presentations and will discuss how I have structured them in such a way.We will be adding new lectures in the coming monthsYou will be able also to download many additional resourcesTemplates of slidesExamples of presentations shown in the courseLinks to additional presentations and moviesLinks to books worth readingAt the end of my course, students will be able to…Create a great presentation in the style of top consulting firmsUnderstand the main challenges in preparing the management consulting presentationExpress yourself with slidesRead presentationCreate the flow in the story told via presentationWho should take this course? Who should not?Management ConsultantsStudents of Business SchoolsResearchersBusiness Analysts

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 optimize processes in practice and improve efficiently things What you'll learn: Optimize process in practiceLower the cost of specific processHow to measure the costs of processesWhat other KPIs matter when it comes to processHow to make the process fasterIncrease the quality of products and servicesHow to make processes more scalableHow to select the projects for implementation What is the aim of this course?In every firm, you have key processes that you have to take care of to stay in business, thrive, and scale your business. You should optimize those processes to outperform your competition, get more customers, and generate higher profits. In this course, I will teach you how to optimize processes in practice and how to estimate in Excel the potential impact of the improvements. I will show you how you can do it either in your own firm or during consulting projects for your customers.In this course, I will show you different methods that you can use to improve processes. You will learn the following things:How to optimize processes in practice?What methods can you use to optimize processesWhat you can try to optimizeHow to estimate in Excel the potential impact of the improvementsThis 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 turnarounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. We have helped numerous firms improve performance, escape bankruptcy, and conquer new markets as well as customers, by using techniques and frameworks shown in this course. 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, Alvarez & Marsal, PwC, Dell, Walgreens, Orange Citigroup, Cisco, IBM, 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 a lot of lectures, 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 modification, be applied by you or your team in your work.Why have I decided to create this course?Process optimization is the bread and butter both for Management Consultants as well as Managers. However, firms usually do not teach the skills and the approach that you need to optimize fast processes. Most firms do not even define KPIs for important processes and do not try to find out the drivers of those processes. Therefore, we wanted in the shortest possible time, to give you the essential tools that will help you optimize processes in practice.This course will help you become an expert in process improvement. This skill will prove very useful not only in consulting but also later when you become a manager or 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 process optimization. Thanks to this course, you will know what and how to do, during process optimization projects. You will also get insight into how to create a new process from scratch. We want to provide you with frameworks that will open your eyes to ways in which you can make the firm do things cheaper, faster, and deliver high-quality products and services.To sum it up, the course will help you become an expert in process optimization on the level of McKinsey, BCG, Bain, PwC, Deloitte, EY, and other top consulting firms. That is why, I highly recommend this course to Management Consultants, Business Analysts as well as Managers, 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 optimize the process. 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 optimize processes in practice?What methods you can use to optimize?What you can try to optimizeHow to estimate in Excel the potential impact of the improvementsYou can also ask me any questions either through the discussion field or by messaging me directly.How the course is organized?The course is 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 organizedOptimization of in-store processes – a case study. In the second section, we will have a look at a case study in which we will optimize processes in a store. The aim will be to lower the costs of processes so we can have a more profitable business. We will discuss in this section also the main techniques that are useful during process optimization projects. Later, we will use the same techniques to improve other than costs, KPIsOptimization for other KPIs. In this section, I will show what other KPIs we can optimize during process optimization. Again, we will have a look at the usual suspects, such as improving quality, improving capacity, and speed. We will also discuss how to make the process more scalable and reduce frictionProject Selection. In the 4th section, I will discuss different methods of selecting projects. In practice, you will map a lot of potential projects that can be used to optimize the process. You have to select from a huge list a few that give you the biggest potential. We will discuss how to do that in this section.You will be able also to download many additional resources1. Useful frameworks and techniques2. Selected analyses shown in the course3. Links to additional presentations, articles, and movies4. Links to books worth reading5. Additional resources expanding the issues mentioned in the courseAt the end of my course, students will learn to…Optimize process in practiceHow to lower the cost of a specific processHow to measure the costs of processesWhat other KPIs matter when it comes to the processHow to make the process fasterHow to increase the quality of products and servicesHow to make processes more scalableHow to select the projects for implementationWho should take this course? Who should not?Management ConsultantsBusiness AnalystsManagersAnalysts working in Strategic DepartmentsStartup FoundersControllersFinancial DirectorsWhat 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 consulting projects What you'll learn: Analyze the production plans in ExcelCalculate the optimal production batches in ExcelHow to do simulations in ExcelHow to do scenario analysis in ExcelUnderstand the role of Production PlanningOptimize the Production Planning during Management Consulting Projects What is the aim of this course?Consulting firms are hired very often to help with Supply Chain and Production. During such projects, you will quite often have to look at the production planning and optimize it. Optimizing production planning will require a good understanding of what drives production capacity, as well as how production can impact the costs in the whole supply chain. In this course, I will teach how to perform fast and efficiently different types of analyses related to production planning.In the course you will learn the following things:What does the production capacity depend on and how to estimate itHow to find optimal production batches for different products in Excel that will minimize costs in the whole supply chainHow to plan production capacity for the futureHow and when to use different methods for production planningThis 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, resources, 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 modification, be applied by you or your team in your work.Why have I decided to create this course?Production planning is very difficult for most management consultants. You not only have to master more advanced techniques, but you also have to have a good understanding of the production processes. Most firms, don’t give you the full toolbox that you may 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 need during consulting projects devoted to production planning, supply chain, or production improvement. 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 learn how to analyze data and draw conclusions from the analyses. On top of that, you will also master the essential information related to production and supply chain.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 production planning and analyses done during projects devoted to production optimization. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that want to concentrate on operations, production, or supply chain. The course will help you become an expert in production planning 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 one analyzes 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 does the production capacity depend on and how to estimate itHow to find optimal production batches for different products in Excel that will minimize costs in the whole supply chainHow to plan production capacity for the futureHow and when to use different methods for production planningYou 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.What does Production Planning do in practice? In the second section, we will look at some essential concepts that we will need to do the production planning. We will devote a lot of attention to removing bottlenecks.Essential Methods for Production Planning. In this brief section, I will show the main methods used in production planning.KPIs and goals for Production Planning. In production planning, you have to decide how to organize production so that it is optimal not only from the point of view of production but also from the whole supply chain. That is why, in this section, we will look at KPIs and goals that Production planning concentrates on.Advanced Methods for Production Planning. In this section, we will look at more advanced methods of finding optimal production batches. They can be very useful in more complicated case studies.Kanban & Continuous Flow. Production planning roles will differ if you are using Kanban and continuous flow. That is why in this section we will look at those two concepts.Production Planning in Continuous-Flow. In this section, I will show you how to define the size of kanbans you will be using in the firm.Capacity management. In the last section, we will discuss how to manage the medium-term and long-term capacity available in your production facilities.You will be able also to download many additional resources Useful frameworks and techniques Analyses shown in the course Additional resourcesLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…Analyze the production plans in ExcelCalculate the optimal production batches in ExcelDo simulations in ExcelDo scenario analysis in ExcelUnderstand the role of Production PlanningWho should take this course? Who should not?Management ConsultantsBusiness AnalystsFinancial ControllersAnalysts working in Supply Chain DepartmentsAnalysts working in Production DepartmentsAnalysts working in Production Planning Units

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 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 do funnel analyses & use them for decision making What you'll learn: Define sales funnels for different analysesAnalyze funnels in ExcelAnalyze funnels by cohortsUse funnels to Increase SalesUse funnels to manage new ideasUse funnels to manage testsManage Projects with the help of funnels & funnel analysis What is the aim of this course?Funnels and funnel analyses are great tools that can help you find problems and opportunities, optimize processes as well as manage projects. They are widely used by technological firms. However, many industries are still not using them, despite their big potential. In this course, I will teach you how to use funnel analyses to increase the profits of the firm.In the course you will learn the following things:What are funnels?How to analyze funnels in ExcelHow funnels look like for e-commerce, marketplace, SaaS firms, and other business modelsHow to use funnels and funnel analysis to increase sales and profitsWhat are cohorts and how to use them to analyze funnels?How to use funnels to manage tests, projects, or tasksThis 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 in total of 2 billion of 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?Many processes, especially those related to sales, and project management are very complicated. Therefore you have to analyze them by stages. In such situations, funnels and funnel analysis are extremely useful. Most firms, don’t give you the full toolbox that you need to analyze funnels. 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 funnels and funnel analyses as well as use them 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 when and how to use funnels. You will master how to analyze data and draw conclusions from the funnel 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 funnels and funnel analysis. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that want to optimize sales, generate new business ideas, or manage projects. The course will help you become an expert in funnel 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 the 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 funnels?How to analyze funnels in ExcelHow funnels look like for e-commerce, marketplace, SaaS firms, and other business modelsHow to use funnels and funnel analysis to increase sales and profitsWhat are cohorts and how to use them to analyze funnels?How to use funnels to manage tests, projects, or tasksYou 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 are 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 a funnel analysis is and how you can use it to achieve better business results.Sales Funnels. Funnel analyses are used successfully in sales & marketing. In this section, we will show you how to analyze sales funnels in Excel.Sales Funnels by Cohorts. Quite often you want to go deeper and analyze how the sales funnel looks like for different segments and cohorts. This is when cohort analysis comes in handy. In this section, we will see what cohorts are and how to combine them with funnel analyses.Funnels in Testing. Funnel analyses can also be used for testing business ideas, and small and big improvements. In this section, we will discuss how to do it in practice.Funnels for Project Management. The Funnel Approach is also a great tool for managing projects or tracking the status of many projects visually. We will discuss this in this section.You will also be able to download many additional resources1. Useful frameworks and techniques2. Ready-made analyses presented 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…Define sales funnels for different analysesAnalyze the funnel in ExcelAnalyze by cohorts funnelsUse funnels for Sales IncreaseUse funnels for managing new ideasUse funnels for managing testsManage Projects with the help of funnels & funnel analysisWho should take this course? Who should not?Management Consultants and Business AnalystsSales AnalysisData AnalystsFinancial ControllersInvestment AnalystsStartup FoundersProject ManagersE-commerce AnalystsWhat 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 show results of analyses during consulting projects What you'll learn: What type of slides and charts to use to present data to your customer?How to create charts in ExcelHow to create charts in PowerPointHow to use PivotChartsHow to make the charts more dynamicMain concepts used in Data Visualization What is the aim of this course?In consulting, you will spend a lot of time creating presentations to show the results of your analyses to the customer. That is why data visualization is so important. With a proper display of data, you have more chances of convincing the customers that your approach makes sense. In this course, I will teach how to use different data visualization techniques to show the results of your analyses during consulting projects.In the course, you will learn the following things:What types of slides should you use to present your thoughtsWhat types of charts should you use for data visualizationHow to read the chartsHow to create charts in Excel How to create charts in PowerPointHow to create dynamic charts 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 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. Based on 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, 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, 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 or your team in your work.Why have I decided to create this course?Data visualization is one of the most important skills that you should master during your 1st year of work in consulting. If you are able to analyze data but you don’t know how to present it to the customer, you will lose the opportunity to impress them. Data visualization is one of the crucial skills that you should master if you want to get promoted fast. 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 need during consulting projects when it comes to data visualization. The course will give you knowledge and insight into the types of charts and slides that you will be using during your work to present the data. It will also make your life during a consulting project much easier. Thanks to this course, you will know what and how to present data and visualize them during consulting projects. On top of that, you will also have access to the library of slides and charts that we use ourselves.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 data visualization. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who present the results of their analyses to customers. The course will help you become an expert in data visualization 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:What types of slides should you use to present your thoughtsWhat types of charts should you use for data visualizationHow to read the chartsHow to create charts in Excel How to create charts in PowerPointHow to create dynamic charts in ExcelYou 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 intro to the course, as well as some general info on how the course is organizedTypes of slides you can use. In this section, I will show you what kind of slides you can use for different purposes during consulting projects.How to read charts. In this section, I will show how to read charts and how people can lie to you with chartsWhich chart type should you use? We will discuss in detail what type of charts you can use for different purposes. We have grouped them into 5 different categories.Essential Charts in Excel. In the fifth section, we will move to more technical issues. I will show you how you can create and modify specific types of charts in Excel. Data Visualization using Conditional Formatting. You can do data visualization not only with charts but also with conditional formatting. In this section, we will see how this can be done in Excel.How to create charts in PowerPoint. In the seventh section, we will move to more technical issues. I will show you how you can create and modify specific types of charts in PowerPointPivotCharts. To make the charts more dynamic, you can use PivotCharts. We will see in this section how this can be done in practice.PivotCharts Case Studies. In this section, we will see how we can use PivotCharts to present data from analyses.Dynamic Charts in Excel. In this 10th section, we will see how we can make the charts more dynamic.Advanced Charts in Excel. In the last section, I will show you more advanced types of charts that you can create in Excel.As 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 reading At the end of my course, students will be able to…How to create charts in ExcelHow to use PivotChartsHow to make the charts more dynamicWhat type of slides and charts to use to present data to your customer?Who should take this course? Who should not?Management ConsultantsBusiness AnalystsFinancial ControllersInvestment AnalystsStartup FoundersProject ManagersWhat will students need to know or do before starting this course?Basic or intermediate Excel

A practical guide on how to conduct efficiently meetings during consulting projects What you'll learn: How to prepare for a meeting with managersHow to deliver presentation during consulting projectsHow to prepare for interviews with managers and directorsHow to conduct interviews with managers and directors What is the aim of this course?During consulting projects, you will be doing plenty of interviews and meetings. In the beginning, you may find them very stressful and challenging, especially, when you have to talk with directors, and managers that are much older than you, and that has a much bigger experience than you. Luckily, there are a lot of interesting techniques that will help you conduct efficiently interviews and meetings during consulting projects.In this course, I will show you different tips and methods that will help you achieve your goals. Thanks to this course you will learn the following things:How to prepare and conduct initial interviews during consulting projectsHow to conduct regular meetingsHow to make sure that your final presentation is a successThis 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. We have helped numerous firms improve performance by using techniques and frameworks shown in this course. 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, Strategy&, Booz Allen Hamilton, Alvarez & Marsal, PwC, Dell, Walgreens, Orange Citigroup, Cisco, IBM, 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 a lot of lectures, 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 modification, be applied by you or your team in your work.Why I have decided to create this courseMost consulting firms and universities don’t devote much attention to softer skills related to conducting and managing meetings. Management Consultants also experience some problems due to the big age difference. Most of the people you will have to talk to during consulting projects, are much older than you. Not having the right skills in this area may mean that you will spend too much time in meetings and the quality of data may be low. That’s why I have decided to put the best practices when it comes to interviewing and conducting meetings into this course.This course will help you conduct efficiently different types of meetings during consulting projects. These skills 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. Thanks to this course, you will know what and how to do, during different types of meetings, to achieve your goals.To sum it up, the course will help you become an expert in conducting meetings on the level of McKinsey, BCG, Bain, PwC, Deloitte, EY, and other top consulting firms. That is why I highly recommend this course to Management Consultants and Business Analysts.In what way will you benefit from this course?The course is a practical, step-by-step guide loaded with tons of examples, tricks, and hints that will significantly improve the way you conduct meetings. There is little theory – mainly examples, and 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 prepare and conduct initial interviews during consulting projectsHow to conduct regular meetingsHow to make sure that your final presentation is a successYou can also ask me any questions 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 short intro to the course as well as some general info on how the course is organizedInterviews – Preparation Phase. In the second section, I will show how you should prepare for the first interviews during consulting projects. We will discuss tools that will help you with the preparation.Interviews – Execution Phase. In this section, I will show how you should conduct the interviews. We will discuss useful tools and frameworks. I will also discuss briefly how to take notes during the interviewRegular meetings with stakeholders. In the 4th section, I will discuss regular meetings that you have to conduct during the consulting projects. We will discuss the general framework. Afterward, I will shed some light on how to get buy-in as well as how to over-deliverYou will be able also to download many additional resources1. Useful frameworks and techniques2. Selected analyses that are shown in the course3. Links to additional presentations, articles, and movies4. Links to books worth readingAt the end of my course, students will learn to…How to prepare for a meeting with managersHow to deliver presentations during consulting projectsHow to conduct interviews with managers and directorsHow to conduct internal meetings with your team during consulting projectsHow to successfully manage implementation teamsWho should take this course? Who should not?Management ConsultantsBusiness AnalystsFuture ManagersAnalysts working in Strategic DepartmentsProject ManagersWhat 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 create slides fast & efficiently during consulting projects What you'll learn: How to create fast and efficiently slides in PowerPoint during consulting projectsHow to move, copy and rearrange objects in PowerPointHow to create animation in PowerPointHot to create charts in ExcelHow to create charts in PowerPointHow to use transition to animate objectsHow to create templates in PowerPointHow to use Smart Arts in PowerPoint What is the aim of this course?In consulting, you will be spending plenty of time browsing through documents and doing calculations in Excel to estimate the impact of potential improvements. However, in the end, you have to produce a presentation that you can show to your customers. That is why it’s essential to master PowerPoint. This skill will help you finish your work on time. In this course, I will teach how to produce fast and efficiently slides in PowerPoint during consulting projects.In the course you will learn the following things:How to create slides from scratchHow to be fast and efficient in PowerPointHow to create simple and intermediate animations in PowerPointHow to create charts in ExcelHow to create charts in PowerPointHow to create or modify templatesHow to animate charts in PowerPointThis 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 in 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?During consulting projects, you will spend up to half of your time in PowerPoint creating slides. That’s why it’s vital to use PowerPoint fast and efficiently. Once you master tricks and hacks that will help you do the slides much faster, you can spend more time understanding the business and building relationships with the customers. This, in turn, will help you get promotions much faster. 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 learn essential PowerPoint or refresh their knowledge of PowerPoint. We will concentrate on the things you 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 work much faster with PowerPoint and produce better, more consistent slides.To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have pretty good at PowerPoint. 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, master PowerPoint, 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 to create slides from scratchHow to be fast and efficient in PowerPointHow to create simple and intermediate animations in PowerPointHow to create charts in ExcelHow to create charts in PowerPointHow to create or modify templatesHow to animate charts in PowerPointYou can also ask me any question either through the discussion field or by messaging me directly.How the course is 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 organizedEssentials. In this section, we will discuss how to do basic things in Excel like inserting slides, aligning objects, inserting objects, bringing and sending objects, and using smart art.Animations. In this brief section, I will show you how to do different types of animations. We will use not only basic animation but also the animation of charts and through the transition.Templates. In consulting, you will be using a lot of templates. In this section, I will show you how to create and modify them.Essential Charts in Excel. In this section, I will show you how to insert and edit great charts in Excel. This will help us, later on, repeat it in PowerPoint.How to create charts in PowerPoint. In the last section, I will show you how to create and modify charts in PowerPoint. We will use a lot of concepts that we have learned from Excel.You will be able also to download many additional resourcesTemplates and libraries of slidesAdditional resourcesLinks to additional presentations, articles, and moviesAt the end of my course, students will be able to…How to create fast and efficiently slides in PowerPoint during consulting projectsHow to move, copy, and rearrange objects in PowerPointHow to create animation in PowerPointHot to create charts in ExcelHow to create charts in PowerPointHow to use the transition to animate objectsHow to create templates in PowerPointHow to use Smart Arts in PowerPointWho should take this course? Who should not?Management Consultants and Business AnalystsManagersFinancial ControllersInvestment AnalystsStartup FoundersProject Managers

A practical guide with case studies and examples of financial analyses done during consulting projects What you'll learn: How to conduct fast and efficiently financial analyses during consulting project in ExcelHow to draw conclusions from financial analysesAnalyze financial indicators, ratiosDo essential firm valuationAnalyze different types of investments in ExcelEstimate the impact of the M&A activityEstimate the impact of proposed improvements on profit and balance sheetCreate a business model of the firm in ExcelAnalyze business units What is the aim of this course?During many consulting projects, you will have to do a lot of financial analysis and draw conclusions about a specific company or industry. This is especially true during due diligence projects, strategic projects, and turn-arounds. Financial analyses will help you decide which option is better, what investments you should take, estimate potential improvements, or estimate the impact on the profit and the balance sheet. On top of that, during consulting projects, you have to do everything 3x faster and with little data. Therefore, I will teach you in this course how to do fast and efficiently financial analyses and how to draw conclusions from themIn the course you will learn the following things:How to do financial analyses in Excel fast and efficientlyHow to draw conclusions from the analysesHow to analyze financial statements in ExcelHow to use financial indicatorsHow to model a business in ExcelHow to analyze business units of the firmHow to carry out analyses related to M&AHow to evaluate a potential investment in ExcelHow to estimate the value of the firm using simple methodsThis 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?Analyzing the financial situation of the firm is a fundamental skill in consulting. It helps you understand the current situation of the firm, identify problems, and estimate potential savings. Many Management Consultants and Business Analysts did not finish Business School and sometimes struggled with some financial analyses. This sometimes puts them at a disadvantage and makes it difficult for them to get promoted. On top of that, many consultants and analysts who did study finance at university/college have forgotten some things.Therefore, I have decided to create this course that will help students understand or refresh how to do financial analyses in Excel. 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 to understand financial data, analyze them, and draw conclusions from them. 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 financial analyses. 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 financial analyses on the level of McKinsey, BCG, Bain, and other top consulting firms. That is why, I highly recommend this course to Managers, Management Consultants, and owners/founders of businesses that need better to have a good understanding of the business.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 to do financial analyses in Excel fast and efficientlyHow to draw conclusions from the analysesHow to analyze financial statements in ExcelHow to use financial indicatorsHow to model a business in ExcelHow to analyze business units of the firmHow to carry out analyses related to M&AHow to evaluate a potential investment in ExcelHow to estimate the value of the firm using simple methodsYou 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 8 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 organizedGeneral Analysis of Financial Statements. In the second section, I will show you how to analyze 3 main financial statements: cash flows, profit, and loss statements, and balance sheets.Financial Analysis of Indicators. In this section, I will show you how to use financial indicators, and ratios to analyze the situation of the firm, especially in comparison with other firms. We will look at profitability, efficiency, liquidity, and debt ratios.Modeling of Profit & Loss statement in practice. In the 4th section, I show you how to model the profit and loss statement of a company in Excel. A business model of the firm you can use to understand the business, forecast future growth, or for valuation purposesBusiness Units Analyses. In the 5th section, we will discuss the analysis of Business Units. Many firms are running more complicated businesses with plenty of business units that you should analyze separately. We will have a look at 2 examples of such analysesValuation. 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.Financial Analyses related to M&A. In this section, I will show you how to analyze the different aspects of M&A. Here we will see what is better: organic growth or M&A, how to estimate the impact of M&A on the firm, and how to decide whether to sell a business unit or notInvestment Analyses. In the last section, I will show you how to analyze different investments in the firm. We will look at investments demanded by customers, investments that are supposed to generate savings, and investments in bottlenecks. Different types of investments require different approaches.You will also be able to download many additional resourcesUseful frameworks and techniquesSelected analyses presented in the courseLinks 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 financial analyses during a consulting project in ExcelHow to draw conclusions from financial analysesAnalyze financial indicators, ratiosDo essential firm valuationAnalyze investments in ExcelEstimate the impact of the M&A activityCreate a business model of the firm in ExcelAnalyze business unitsWho should take this course? Who should not?Management Consultants and Business AnalystsManagersFinancial ControllersStartup FoundersOwners of small and mid-sized businessesInvestment DirectorsWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics or financeBasic or intermediate knowledge of finance & accounting

A practical guide on how to conduct market research during consulting projects What you'll learn: How to estimate the market size in ExcelHow to analyze the competitionHow to analyze the market structureHow to model the results of the research in ExcelHow to analyze data from consumersHow to analyze data from sales channelsWhere to find the information, you will needHow to use jobs-to-be-done framework What is the aim of this course?During most consulting projects you will have to carry out some sort of market research. You will be analyzing the market size, competition, sales channels, and products. For strategic projects, due diligence, and business development projects, market research is a must and will be the basis for the whole project. Market research is time-consuming and requires combining different methods and sources. This is a must to get the full picture and advise the customer. In this course, I will teach how to perform fast and efficiently market research analyses during consulting projects.In the course, you will learn the following things:How to estimate the market size in ExcelHow to analyze the competitionHow to analyze the market structureHow to model the results of the research in ExcelHow to analyze data from consumersHow to analyze data from sales channelsWhere to find the information, you will needHow to use the jobs-to-be-done frameworkThis 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 224 000 students including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.I teach through case studies, so you will have a lot of lectures showing examples of analyses, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.Why have I decided to create this course?Most consulting projects especially those related to strategy will require you to research and analyze the market. To do that efficiently, you will have to master certain skills and tools as well as have a good understanding of what kind of sources of information you can use. Most firms don’t give you the full toolbox that you need. This may lead to huge frustration during management 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 to do market research 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 projects that will require conducting market research and analyzing market data. You will master how to analyze data and draw conclusions from the analyses using ExcelTo 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 market research and market analyses done during consulting projects. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who have not finished business school. The course will help you become an expert in market research and market 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:How to estimate the market size in ExcelHow to analyze the competitionHow to analyze the market structureHow to model the results of the research in ExcelHow to analyze data from consumersHow to analyze data from sales channelsWhere to find the information, you will needHow to use the jobs-to-be-done framework.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 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 organizedEstimating Market Size. The first thing you will do is estimate the size of the market. This will help you calculate the shares of competitors and observe trends in the market. In this section, we will see how this can be done.Jobs-to-be-done Framework. This framework is extremely useful for defining the market and the competitors. In this section, we will what it is and how it can be used in practice.Competitive Landscape. As a part of most market research, you will also have to analyze the competitors, understand their shares in the market, what drives profitability as well as what strategies they use. In this section, we will see how we can map and analyze the competitors.Market Structure Analyses. The next step is to understand the market structure and the consumer. This will also give us a deeper understanding of the differences between competitors.Sales Channel Analyses. If you are dealing with other than the retail, marketplace, or e-commerce business models you should analyze what kind of sales methods and channels are used. In this section, you will learn how to analyze the sales channels in Excel.Financial Modeling. Market research is usually followed by financial modeling. The aim is usually to see whether entering certain segments or increasing presence makes economic sense. In this section, you will learn how to create a simple financial model and check whether the business idea makes sense or not.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 learn:How to estimate the market size in ExcelHow to analyze the competitionHow to analyze the market structureHow to model the results of the research in ExcelHow to analyze data from consumersHow to analyze data from sales channelsWhere to find the information, you will needHow to use the jobs-to-be-done frameworkWho should take this course? Who should not?Management ConsultantsBusiness AnalystsManagersFinancial ControllersInvestment 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.

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

Learn Financial Modeling in Excel that will allow you to participate in due diligence, strategy or turn around projects What you'll learn: You will master financial modeling in Excel at the needed for business analysts and consultants levelUnderstand the main challenges in financial modellingPerform the analyses of financial modelsYou will get access to +30 ready-made models that you can utilize for your purposesModel your business in ExcelEstimate the value of your business What is the aim of this course?As a business analyst or a consultant, you will have to from time to time create financial models. They are a bit different than business models. In business models, you go into details of operations and you focus on getting the links on the KPIs. Those models are usually done for internal purposes, to manage in the right direction the business. Financial models on the other hand are more for external users. You concentrate on creating a picture of the business in a standardized, understood by everybody way. You also want to create financial statements: profit & loss statement, balance sheet statement, and cash flow statement. On top of that, you use financial statements for valuation purposes. The most typical situation when, as a business analyst or a consultant, you will have to prepare such a model is connected with selling or purchasing a company. You may be doing it on the sell side or on the buy side. Financial modeling is done as a part of strategy projects, turnaround projects, and due diligence. I will NOT teach you everything on financial modeling because it is simply not efficient (and frankly you don’t need it). This course is organized around the 80/20 rule and I want to teach you the most useful (from a business analyst/consultant perspective) ways to go as fast as possible from rough description to working model in Excel that you can make more and more complicated. The aim of this course is that you are able to do a financial model of the business as fast as possible. If done properly, this course will transform you in a few days into a pretty good business analyst who knows how to create fast and efficiently financial models. 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 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 step by step on the basis of Excel files that will be attached to the course. We will go through a real-life example of a business and create the financial model for it. To make the best out of the course you should follow my steps and repeat what I do with the data after every lecture. Don’t move to the next lecture if you have not done what I show in the lecture that you have gone through. I assume that you know basic Excel so the basic features (i.e. how to write formulas in Excel) are not explained in this course. I concentrate on intermediate and advanced solutions and purposefully get rid of some things that are advanced yet later become very inflexible and useless (i.e. naming the variables). To every lecture, 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? This course is a part of my attempt to help business analysts and consultants gain fast useful knowledge that will help them excel at their work. I have done 10 other courses that will help you become a great business analyst or consultant. I have covered already: hacks and tricks in Excel, business modeling, market research, management productivity hacks, and others. Now you have the opportunity to learn financial modeling in Excel 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 available in your company data. 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 is the difference between business models and financial models? How to model cost positions and balance sheet positions? How to create on the basis of these financial statements: profit and loss statement, balance sheet statement, and cash flow statements How to make sure that there is integrity in the model? What analyses and conclusions you can draw from the financial model? You can also ask me any question either through the discussion mode or by messaging me directly.How the course is organized? The course is divided currently into 10 sections and will be adding new sections to address other important issues. Currently, you will find the following sections: Introduction. We begin with a little intro to the course Modeling of Profit & Loss account. In this section, we start by showing how to model cost positions (except for Depreciation)and how to create on the basis of this, a profit & loss statement Capex and Depreciation. Capex and Depreciation are some of the most difficult elements that you will model in Excel. Therefore, we have created a separate section devoted just to this subject. In this section, you will learn how to follow specific groups of assets, track their gross and net value, and calculate depreciation. Working Capital. Working capital is crucial to the business as it defines how much money you have to have engaged in the business. I will show you how to model specific positions of Working Capital Debt. You may need external sources of financing for the company. I will show you how to model loans and get the necessary info to create a balance sheet later. Equity. In this section, I will show you how to model equity and all relations with shareholders Balance sheet modeling. Here we get everything together to model the balance sheet statement. Cash flow modeling. Here we get everything together to model the cash flow statement. Here we will check the integrity of the model as well. Analyses of the Financial Model. In the end, on the basis of a ready model, I will try to draw conclusions that will show us whether the business we have been analyzing is interesting or not Valuation. In this section, I will show you the main valuation methods. We will look at DCFand the Multiplier methodBusiness modeling. In many cases, you will have no time to do a full financial model. In such situations, you may resort to creating a business model. A business model will usually have only a P&Lstatement. In some cases also simplified the Cash Flow statement. In this section, we will see how you can create such models. You can also get access to more than 30 models. You will see how to model e-commerce, marketplace, real estate, subscription businesses, and many more. You will also be able to download many additional resources Excels with analyses shown in the courseLinks to additional presentations and moviesLinks to books worth reading At the end of my course, students will be able to… You will master financial modeling in Excel at the needed for a business analyst and consultant levelUnderstand the main challenges in financial modelingPerform the analyses of the financial modelYou will get a ready model that you can utilize for your purposesWho should take this course? Who should not? Business analystsResearchersControllersConsultantsSmall and medium business ownersStartups foundersWhat will students need to know or do before starting this course? Basic ExcelBasic knowledge of economics or finance

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