Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Solver in Excel for Management Consultants & Analysts

A practical guide on how to use linear programming and Solver in Excel to find optimal solutions
4.9
4.9/5
(18 reviews)
977 students
Created by

9.5

CourseMarks Score®

10.0

Freshness

8.9

Feedback

9.0

Content

Platform: Udemy
Video: 1h 39m
Language: English
Next start: On Demand

Top Excel Analytics courses:

Detailed Analysis

CourseMarks Score®

9.5 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 12/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

8.9 / 10
We analyzed factors such as the rating (4.9/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.0 / 10
Video Score: 7.8 / 10
The course includes 1h 39m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.7 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
12 resources.
0 exercise.
0 test.

Table of contents

Description

What is the aim of this course?
From time to time you have to find optimal solutions to more complicated problems that cannot be solved by typical analyses. 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. 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.
In the course you will learn the following things:
•How to use Solver in Excel in practice
•How to define problems using the linear programming language
•How to find optimal solutions to problems using Solver
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 or supervised over 90 different performance improvement projects in different industries that generated in total 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 116 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, tools that we use. 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.
Why have I decided to create this course?
Linear programming is an interesting, relatively easy-to-use Excel tool that helps you solve complex problems. Most firms, don’t teach you how to use linear programming and Solver to find optimal solutions. 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 linear programming and learn how to use Solver in Excel 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-how in a simple manner to solve many complex problems.
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 linear programming and Excel Solver. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that do a lot of analysis in Excel. The course will help you become an expert in 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 tones of analyses, tricks, hints that will significantly improve the speed with which you understand, 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:
•How to use Solver in Excel in practice
•How to define problems using the linear programming language
•How to find optimal solutions to problems using Solver
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 organized
•How to use Solver in Excel. I will start with a short example that will help you understand how to use Solver in practice.
•Essential Linear Programming. In this section, I will explain to you what is Linear Programming. To make the most of the Solver in Excel you have to learn a little bit about Linear Programming which we will use to write down the problems we want to solve.
•Cases studies. In this section, we will use the concept that we have learned to solve different case studies.
You will be able also to download many additional resources
•Useful frameworks and techniques
•Analyses shown in the course
•Additional resources
•Links to additional presentations, articles, and movies
•Links to books worth reading
At the end of my course, students will be able to…
•How to use Solver in Excel in practice
•How to define problems using the linear programming language
•How to find optimal solutions to problems using Solver
Who should take this course? Who should not?
•Management Consultants
•Business Analysts
•Analysts responsible for Supply Chain
•Analysts responsible for Production Planning
•Analysts responsible for finding the optimal place for a new factory.
What will students need to know or do before starting this course?
•Basic or intermediate Excel
•Basic knowledge of economics
•Basic or intermediate knowledge of finance & accounting

You will learn

✓ How to use Solver in Excel in practice
✓ How to define problems using the linear programming language
✓ How to find optimal solutions to problems using Solver
✓ How to pick the optimal place for a factory or warehouse
✓ How to allocate resources to different projects

Requirements

• Basic or intermediate Excel
• Basic knowledge of economics

This course is for

• Management Consultants
• Business Analysts
• Analysts responsible for the Supply Chain
• Analysts responsible for the Production Planning
• Analysts responsible for finding the optimal place for a new factory

How much does the Solver in Excel for Management Consultants & Analysts course cost? Is it worth it?

The course costs $14.99. And currently there is a 82% discount on the original price of the course, which was $84.99. So you save $70 if you enroll the course now.

Does the Solver in Excel for Management Consultants & Analysts course have a money back guarantee or refund policy?

YES, Solver in Excel for Management Consultants & Analysts has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Solver in Excel for Management Consultants & Analysts course, but there is a $70 discount from the original price ($84.99). So the current price is just $14.99.

Who is the instructor? Is Asen Gyczew a SCAM or a TRUSTED instructor?

Asen Gyczew has created 61 courses that got 23,459 reviews which are generally positive. Asen Gyczew has taught 123,053 students and received a 4.4 average review out of 23,459 reviews. Depending on the information available, Asen Gyczew is a TRUSTED instructor.
Expert in performance improvement, turnaround and startups
Expert in performance improvement, scaling businesses, and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 500 million) and startups. I have trained in person over 100 consultants, business analysts, and managers who now are Investment Directors, CEO, Partners in PE and VC funds, Sales and Marketing Directors, Operational  Directors, COO, Directors in Consulting Companies, Supply Chain Directors, Board Members, etc. Functional experience: performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence, turn-arounds, PMO;   Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending, fashion, toys), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing), foodtech, marketplacesCountries: Poland, Serbia, Russia, Ukraine  Show moreShow less

9.5

CourseMarks Score®

10.0

Freshness

8.9

Feedback

9.0

Content

Platform: Udemy
Video: 1h 39m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Solver in Excel for Management Consultants & Analysts rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/solver-in-excel-for-management-consultants-analysts/" target="_blank" title="Solver in Excel for Management Consultants & Analysts on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/95.svg" width="200px" alt="Solver in Excel for Management Consultants & Analysts rating"/></a>