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.
LEVEL – Intermediate
COURSE TOPICS:
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
READ MORE
LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Solving Optimization and Scheduling Problems in Excel”
Instructor’s Welcome Note:
– Hi, I’m Curt Frye. Welcome to Solving Optimization and Scheduling Problems in Excel. In this course, I will show you how to use one of the most powerful tools available in Microsoft Excel, the free Solver add-in. I’ll start by showing you how to install Solver, how to organize a worksheet for use in Solver and how to find a solution to an optimization problem. Then I’ll move on to examples of specific problem types, Linear Mixture Problems, Nonlinear Mixture Problems, Transportation Problems, Personnel Scheduling Problems and for something a little different, Sports Scheduling Problems.
In the final chapter, I’ll show you how to make the most of your results by changing Parameters by hand, performing Sensitivity Analysis and creating Scenarios. I’m sure you’ll find that your time studying Solving Optimization and Scheduling Problems in Excel will be time well-spent. Dive right in.
Get 10 days of FREE unlimited access to Lynda.com.
Solving Optimization and Scheduling Problems in Excel
Business Intelligence T
Curt Frye tutorials
Lynda review
from Course reviews, freebies, coupons http://www.coursetag.com/free-solving-optimization-and-scheduling-problems-in-excel-business-excel/
No comments:
Post a Comment