Learn to Use Excel's Solver in an Hour: An easy to follow, illustrated introduction to Excel's Solver. (Making Excel Easy)
- Binding: Paperback
- Author: Carl Nixon
- Publish Date: 2017-02-11
Learn to use Excel's Solver in an Hour
If you are new to Excel's Solver it can seem daunting and scary. This easy to follow and fully illustrated guide by the internationally renowned Excel consultant, Carl Nixon, is designed to get you up to speed quickly and easily. You will be able to start producing your own Solver solutions in an hour or less!
This easy to follow guide uses 5 real world business examples to walk you through how to use Excel's Solver
Stock Level Problem
Work out which stock to buy so you can make the most effective use of your money and your storage facilities.
When you have a variety of suppliers with different pricing and stock levels, work out the most cost effective way of ordering your required stock.
If you have a combination of work centres all capable of completing certain tasks, all at different costs, work out what is the most cost effective way of distribution the workload.
Delivery Route Problem
In this classic problem we work out the optimum route through a series of distribution points.
Maximum Flow Problem
In this problem we work out the maximum flow through a system when each link in the system has limited through put. This could be through a network of pipes, a computer network or even the workflow through a factory.
FREE Accompanying File!
An accompanying spreadsheet, which helps you follow the exercises in the book, is also provided via a FREE download.