- 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.
- Identify where the Solver add-in appears after being installed.
- List the steps to populate a cell with whole dollar amounts.
- Identify the style used to format numbers with a thousands separator.
- Name the error you will receive if you try to solve a nonlinear problem with the simplex LP method.
- Recall the length of the season and the number of games per week in the sports scheduling problem.
- List what the Scenario Manager allows you to do.
Skill Level Intermediate
Cleaning Up Your Excel 2013 Datawith Dennis Taylor1h 59m 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.