Join Curt Frye for an in-depth discussion in this video What you should know before watching this course, part of Microsoft Excel: Using Solver for Decision Analysis.
- [Instructor] Before we get started with this course, I'd like to give you some information about what you should expect as you work your way through. It would be very helpful if you know how to create formulas, specifically how to use relative and absolute references. Relative references are cell references that change when you copy a formula from one cell to another, and absolute references stay the same. Also, you should know when to work with backup copies of your data. I'll give you a hint, almost all the time. If you're going to be making changes to a data set, then you should work with a backup copy and keep the original plus another couple of backups somewhere safe.
What you should know about the movies in this course is that they are laid out differently than most of my other courses in the library. Movies within chapters two through four are done in tutorial style. Specifically, I will introduce the problem for a chapter in the first movie, and then all the other movies in the chapter will build upon the previous. So that means that whatever I finish in one movie will be used in the next. I understand that people work in different ways and like to try different things, so I've provided exercise files so you will see exactly what I see.
I have also provided results files so that if you want to skip ahead and see what everything should look like at the end, you can. With all that information in place, let's go ahead and keep going.
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees