Join Curt Frye for an in-depth discussion in this video What you should know before watching this course, part of Solving Optimization and Scheduling Problems in Excel.
- Before I dive into the course, I wanted to give you overview of what you should know before taking on this course and also what to expect from within the course. First, you should know how to create formulas. That is a fundamental Excel skill and hopefully you have that well in hand at this point. It's also helpful to know how to use relative and absolute references. Relative references change when you copy a formula from one cell to another while absolute references don't, and knowing how those work before you go into the course will save you a little bit of time, although I do explain it as we go.
You should also know when to work with backup copies of your data and the answer to that question is all the time. When you work with scenarios and solver models there is definite chance that your data will be changed and if you accidentally save your workbook, you won't be able to go back to the original, at least not easily. So always, always, always, work with backup copies of your data. Next, let's go over what you should expect from this course. It is a little bit different from many other lynda.com courses that you'll take.
The first thing you should expect is to see the movies within chapter 2-6 done in tutorial style. What that means is that the result of the tasks in one movie are used in the next movie. Now, you don't have to worry, I provide intermediate exercise files for each new movie that I create, but if you're up to the challenge, and I hope you are, it might be fun and worth your time to work through all of the tasks in the chapter with a file that you create yourself. Finally, I have provided exercise files so you see exactly what I see.
I give you a file that is marked final and it is the product of the procedure that I've worked through in each chapter. So even if you didn't get something exactly right, all you need to do is check the final workbook that I provide and you can see what the answer should look like.
- 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