When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel Solver for Beginners (2 full examples + methodology)
Background information on linear programming, 2 complete examples, and plenty of resources to further your learning!
This Course Includes
udemy
3.7 (35 reviews )
32 total mins 
english
Online - Self Paced
course
Udemy
About Excel Solver for Beginners (2 full examples + methodology)
This course gives an overview of linear programming (definition, background, use cases) and then shows how to solve a linear program using Microsoft Excel through 2 complete examples. Below is a complete outline of the course:
Lecture 1: Introduction: Linear programming in Excel - course overview + use cases
Lecture 2: Enabling Solver add-on for linear optimization
Lecture 3: What is linear programming?
Lecture 4: Examples of when to use linear programming
Lecture 5: How to identify optimal solutions in linear programming graphically
Lecture 6: Linear programming example 1 - 'taking a test' (optimizing score)
Lecture 7: Linear programming example 2 - 'Stanley's glass'
Students joining this course should have access to MS Excel, and a willingness to learn!
What You Will Learn?
- Install and enable Solver add-in within MS Excel.
- Formulate and solve a linear program using Solver in Excel.
- Understand the components and objective of a linear program (using Solver/Excel).
- Solve for linear optimization graphically.