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
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of coursescompany.com.
View Sitemap