Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction: Linear programming in Excel - course overview + use cases|
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!
Briefly demonstrating how to enable the Solver add-on within MS Excel, as it is necessary that this add-on is enabled in order to formulate an LP.
|Section 2: Components of linear programming|
In this lecture, we'll discuss what linear programming is comprised of, and the general framework of solving for a linear optimization.
Examples of when to use linear programmingPreview
We will walk you through determining feasible and optimal solutions in linear programming given a graph.
|Section 3: Solving a basic optimization problem using linear programming in Excel|
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.
|Section 4: Solving a more complex optimization problem using linear programming in Excel|
Here we will dive into a more complex example, where ***** descriptor****
|Section 5: Conclusion + additional resources|
Conclusion, further learning, and our contact information
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.