Excel Solver for Beginners (2 full examples + methodology)

Excel Solver for Beginners (2 full examples + methodology) free download

Background information on linear programming, 2 complete examples, and plenty of resources to further your learning!

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!