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 backgrounds

Lecture 2: Enabling Solver add-on for linear optimization

• Enabling Solver add-on in MS Excel

Lecture 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!