Linear programming is an interesting, relatively easy-to-use Excel tool that helps you solve complex problems. Why have I decided to create this course?
To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, 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. I teach through case studies, so you will have a lot of lectures showing examples of analyses, tools that we use. On top of that my courses on Udemy were already taken by more than 124 000 students including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others. 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. I have carried or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of additional EBITDA. 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.
How to find optimal solutions to problems using Solver
How to define problems using the linear programming language In the course you will learn the following things: In this course, I will teach how to use Solver in Excel and Linear Programming in practice to solve complex problems and find optimal solutions. Where we should build factories to minimize the total costs for the whole supply chain? How should we plan the flow of goods between factories and our customers, so the demand is met and we maximize our profit? What mix of products will be optimal for us given our capacities, demand, costs, and profits? Luckily, for those cases, we can use Solver in Excel and Linear Programming that will help you find optimal solutions.
From time to time you have to find optimal solutions to more complicated problems that cannot be solved by typical analyses.