Excel Solver for Beginners (2 full examples + methodology)
3.1 (32 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
99 students enrolled

Excel Solver for Beginners (2 full examples + methodology)

Background information on linear programming, 2 complete examples, and plenty of resources to further your learning!
3.1 (32 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
99 students enrolled
Last updated 9/2015
English
English [Auto]
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 32 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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)
  • Solve for linear optimization graphically
Requirements
  • MS Excel will be required to follow along.
Description

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!

Who this course is for:
  • Students interested in learning how to use Solver and create linear programs in Excel. This is an introductory course targeted at individuals with little to no experience using Solver for linear optimization.
Course content
Expand all 8 lectures 32:19
+ Introduction: Linear programming in Excel - course overview + use cases
2 lectures 05:16

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!

Preview 03:11

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.

Preview 02:05
+ Components of linear programming
3 lectures 03:21

In this lecture, we'll discuss what linear programming is comprised of, and the general framework of solving for a linear optimization.

Preview 00:37

We will walk you through determining feasible and optimal solutions in linear programming given a graph.

Preview 01:15
+ Solving a basic optimization problem using linear programming in Excel
1 lecture 09:14

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.

Preview 09:14
+ Solving a more complex optimization problem using linear programming in Excel
1 lecture 10:56

Here we will dive into a more complex example, where ***** descriptor****

Linear programming example - 'Stanley's glass'
10:56
+ Conclusion + additional resources
1 lecture 03:32
Conclusion, further learning, and our contact information
03:32