From the course: Excel Supply Chain Analysis: Solving Transportation Problems

What you should know - Microsoft Excel Tutorial

From the course: Excel Supply Chain Analysis: Solving Transportation Problems

Start my 1-month free trial

What you should know

“

- [Instructor] Thanks again for your interest in this course. Before I jump into the technical material, I would like to give you an overview of what you should know to get the most out of this course. First, you should have good familiarity with functions. If you've used some product before, then that would be particularly helpful, but don't worry, I explain it as we go along. You should also be comfortable with absolute and relative references. Absolute references don't change when you copy a formula from one cell to another. Relative references can. Again, I'll explain it as I go, but if you haven't worked with them before, you might want to review from other sources. Finally, you should be able to work with Solver or at least install it. If you don't have Solver installed on your system currently, then I will show you how to do it here. I have opened a blank Excel workbook, and I can check to see if I already have Solver installed on this system. To do that I'll go to the Data tab of the ribbon and look over to the right. If Solver were installed, I would see the Analyze group and Solver at the top. In this case, it's not installed, so I need to do it myself. I'll go to the File tab of the ribbon and click the bottom category, Options. That displays the Excel Options dialog box. I'll click the Add-ins category, and then at the bottom, next to Manage, I'll make sure that Excel Add-ins is selected from the list and click Go. And that displays the Add-ins dialogue box, check the Solver Add-in, click OK. And you can see that the Analyze group and the Solver button appears in Excel on the Data tab of the ribbon. And that is all we need to get started.

Contents