() and they offer a great deal of information on their website, including. The tool was developed by Frontline Systems, Inc. To be called a 'solver' doesnt do it justice, though, because it is really a powerful optimization algorithm. I'm sure you'll find that your time with this course will be time well spent. The Microsoft Excel solver add-in is one of the features that makes creating engineering and financial models in a spreadsheet a powerful tool. 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. 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. Next, I'll demonstrate how to calculate the optimal location for shipping depots in relation to your stores. 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. 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. In this course, I'll show you how to use the free Solver add-in to help analyze your data in Excel 2016.
