Join Curt Frye for an in-depth discussion in this video Using the exercise files, part of Solving Optimization and Scheduling Problems in Excel.
- If you have a premium subscription to the lynda.com online training library, then you have access to the exercise files for this course. I have downloaded those files from the course site and saved them on my desktop in a folder called Exercise Files. To use any of the files all I need to do is double click the folder to open it up. And you can see that the files have been organized by chapter. If I want to display the files for a particular chapter, I can just click its folder, in this case Chapter07 and work with any of the files inside of the folder.
If you don't have a premium subscription, you can create your own assets or just follow along.
- 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
Skill Level Intermediate
1. Working with Solver
2. Solving a Linear Mixture Problem
3. Solving a Nonlinear Mixture Problem
4. Solving a Transportation Problem
5. Solving a Resource Scheduling Optimization Problem
6. Solving a Sports Scheduling Problem
7. Analyzing Your Solver Results
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.