Learn to Use Excel’s Solver in an Hour

Excel’s Solver Tool was designed with just one purpose in mind – finding the optimum solution to a problem when multiple solutions are possible. For example, if you have to deliver 5 packages what is the optimum route? Learn how to master this powerful tool in just an hour.


Book Contents

As well as teaching you how to use Excel’s Solver tool, this excellent guide shows you how to use it to solve several everyday business problems.

  • Optimum stock level problems.
  • Optimum buying problems.
  • Workload distribution problems.
  • Finding optimum delivery routes.
  • Maximum flow problems.
  • Plus, much more.

Fully Illustrated

The book is fully illustrated with full size images. Here are just some examples of the images from this book.

FREE Accompanying Exercise Files

Every book is accompanied with a FREE to download file that contains all of the exercises covered in the book. Simply download and follow along.


With every book I write, I aim to aid simplicity to already complex processes. To walk you through every problem, step by step instructions are always accompanied with illustrations.


To help you follow the exercises in my books, I always strive to include follow along exercises to download. All for free with no sign ups required. Simply visit our download section and find your book.

Our Books

No time to read through a tome of an Excel manual just to learn the one skill you need?
These quick, fully illustrated and easy to follow guides are designed to get you up and running in an hour or less!

Learn to Use Pivot Tables in an Hour

Learn to Use Pivot Tables in an Hour

Are Pivot Tables a mystery to you? This guide will demystify and simplify Pivot Tables for you. Within the hour you will be wondering what you did without them.

Learn to Use Data Tables in an Hour

Learn to Use Excel Data Tables in an Hour

Do you need to store and manipulate large tables of data? Find out how Excel Data tables allow you to easily store, access and manipulate large tables of data.

Learn to Use Excel's Solver in an Hour

Learn to Use Excel’s Solver in an Hour

Do you need to find solutions to seemingly impossible problems? Find out how Excel’s solver allows you to find the optimum value to problems with multiple solutions.