Join Curt Frye for an in-depth discussion in this video Using the exercise files, part of Learning Excel What-If Analysis.
If you are a premium subscriber to the lynda.com online training library then you have access to the exercise files. I have downloaded the exercise files on to my system and put them in a folder on my desktop called exercise files. You can navigate within the archive by opening the exercise files folder and then double clicking on any of the sub folders. Each of which corresponds to a chapter. The files are clearly labeled and there is at least one file for each movie within a chapter.
If you don't have access to the sample files, then you can create your own assets or just follow along.
- Creating a scenario
- Defining data tables
- Finding a target value with Goal Seek
- Defining constraints and running Solver
- Creating a configurable model
- Manipulating your model
- Running a Monte Carlo simulation
Skill Level Intermediate
1. Defining Scenarios and Data Tables
2. Creating Goal Seek and Solver Models
3. Creating a Configurable Model
4. Performing Monte Carlo Simulation
- 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.