First check to determine if Solver is already installed by clicking on 'Tools' on the main EXCEL toolbar and then on 'Add-Ins' on the dropdown menu, as indicated.
Solver—a Microsoft Office Excel add-in—can help you analyze your data more efficiently. In this course, learn how to leverage Solver to find optimal solutions to problems with multiple constraints. Curt Frye explains how to install Solver, organize worksheets to make the data and summary operations clear, and find a solution using Solver.
He also takes you through how to optimize investment portfolios by setting rules that limit the risk you're willing to take on, as well as how to change a model's parameters to analyze various scenarios. Plus, Curt shares how to define decision trees, represent a tree in an Excel table, and calculate the probability of reaching a node in your decision tree. LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc. Instructor Hello and welcome, I'm Curt Frye.
In this course, I'll show you how to use the free Solver add-in to help analyze your data in Excel 2016. I'll start by showing you how to install Solver, organize worksheets to make the data and summary operations clear and then create and solve a model. Then, I'll show you one way to optimize financial portfolios by laying out fund performance data, setting rules that limit the risk you're willing to take on and change the model's parameters to analyze various scenarios.
Next, I'll demonstrate how to calculate the optimal location for shipping depots in relation to your stores. These movies will show you how to record store and depot locations, map these locations in an xy scatter chart and use the evolutionary Solver to find locations that minimize distance traveled. After that, I'll show you how to lay out a decision tree, represent the tree in an Excel table and evaluate one or more branches to find the best option. I'm sure you'll find that your time with this course will be time well spent. Dive right in.