Excel Solver for Beginners (2 full examples + methodology)

Excel Solver for Beginners (2 full examples + methodology)

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!

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

Url: View Details

What you will learn

• Install and enable Solver add-in within MS Excel
• Formulate and solve a linear program using Solver in Excel
• Understand the components and objective of a linear program (using Solver/Excel)

Rating: 3.7

Level: Beginner Level

Duration: 32 mins

Instructor: E R