Excel Solver for Beginners (2 full examples + methodology)

Background information on linear programming, 2 complete examples, and plenty of resources to further your learning!
4.6 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
17 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 8
  • Length 32 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course 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!

What are the requirements?

  • MS Excel will be required to follow along.

What am I going to get from this course?

  • 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

What is the target audience?

  • 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction: Linear programming in Excel - course overview + use cases
03:11

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!

02:05

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
00:37

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 programming
Preview
01:29
01:15

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
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.

Section 4: Solving a more complex optimization problem using linear programming in Excel
10:56

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

Section 5: Conclusion + additional resources
Conclusion, further learning, and our contact information
03:32

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Erik Rood, Analyst at Google

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!

Instructor Biography

Crystal Wesnoski, Analyst at Pebble Tech

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.


Ready to start learning?
Take This Course