Overview

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

Skills

Reviews