Save for later
Solving Optimization and Scheduling Problems in Excel
Learn how to use Solver, a free Excel add-in, to find optimal solutions to problems with multiple constraints, including linear and nonlinear mixtures, transportation problems, and scheduling conflicts. Along the way, author Curt Frye shows how to organize Excel worksheets for use with Solver, add and swap data, and set each problem's criteria in Solver. In the final chapter, you'll learn how to analyze Solver's results, create scenarios, and change parameters by hand.
Topics include:
- Finding target values using Goal Seek
- Organizing worksheets
- Finding a solution using Solver
- Solving linear and nonlinear mixture problems
- Solving transportation problems
- Solving resource scheduling or sports scheduling problems
- Analyzing Solver results
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 2h 19m |
| Starts | On Demand (Start anytime) |
| Cost | $0/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Curt Frye |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science Business IT & Networking |
| Tags | Data Analysis Business IT Business Intelligence Excel |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Free Lance Fashion Photographer $42k
Junior Free Lance Writer $48k
NFL Free Agent $51k
Free-Lance Illustrator $56k
Free-lance Cellist $64k
Excel Reporting Developer $68k
AUTHOR, FREE-LANCE EDITOR $70k
free lance contributor $70k
Excel/Access DTS Developers $78k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 2h 19m |
| Starts | On Demand (Start anytime) |
| Cost | $0/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Curt Frye |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science Business IT & Networking |
| Tags | Data Analysis Business IT Business Intelligence Excel |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
