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
•Quick introduction + our backgroundsLecture 2: Enabling Solver add-on for linear optimization
•Enabling Solver add-on in MS ExcelLecture 3: What is linear programming?
•What linear programming is comprised of, and the general framework of solving for a linear optimization.Lecture 4: Examples of when to use linear programming
Lecture 5: How to identify optimal solutions in linear programming graphically
•We will walk you through determining feasible and optimal solutions in linear programming given a graph.Lecture 6: Linear programming example 1 – ‘taking a test’ (optimizing score)
•Test score optimization problem (our first example)Lecture 7: Linear programming example 2 – ‘Stanley’s glass’
Students joining this course should have access to MS Excel, and a willingness to learn!
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365
4.7
★★★★★ 4.7/5
1,024,581 students