Learn to Use Excel's Solver in an Hour: An easy to follow, illustrated introduction to Excel's Solver

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.



Supplier Problem

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.


Workload Problem

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.