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!
In this lecture, we will quickly introduce ourselves and discuss our backgrounds.
Next, we'll cover the targeted audience for this course, how the course is laid out, and what you can expect to learn!
In this lecture, we'll discuss what linear programming is comprised of, and the general framework of solving for a linear optimization.
We will walk you through determining feasible and optimal solutions in linear programming given a graph.
Our first complete example! We will cover an optimization problem where a student is looking to optimize his test score given a set of constraints. A great first example and introduction to the power of an LP.
Here we will dive into a more complex example, where ***** descriptor****
Hi! My name is Erik. I currently work as an analyst at Google. I have a strong interest in data visualization and analysis, so the content I publish here will be more or less related to that.
Feel free to reach out via email with any questions, hope you find the courses useful!
I'm a 2014 graduate of the University of Michigan, with my BS in Industrial and Operations Engineering. Upon graduation, I spent about 8 months at The Dow Chemical Company where I optimized chemical production on reactor assets. I am Pebble Tech as a Product Analyst. I also have created & manage a data-centric blog in efforts to learn some new tools for analysis and further refine my skills.