Solver Samples already included in Excel – Excel Tips

Most of you must be familiar with Solver. It’s a built-in tool in Excel which helps you solve optimization problems like maximization of profit, minimizing cost of transportation, minimum cost staff scheduling etc. These problems are so widely encountered that people have made and taught specific samples to use when solving a specific type of problem with Solver. These samples ensure that you are working with the tool as efficiently as is possible. You might think “where can I find those samples?”. Or maybe you are an Excel enthusiast who wants to learn the use of Solver. All the help that you need is already there on your PC. And Daniel Fylstra is here to guide you!

Let’s get started

Step 0: Enabling Solver

If you already have Solver under your ‘Data’ tab, proceed to Step 1. If you are not sure how to access Solver, please follow the steps below:

  1. Go to ‘File’ on the top-left corner and select ‘Options’. A window will open up.
  2. Now select ‘Add-Ins’. You can see a list of active and inactive add-ins here.
  3. Select ‘Excel Add-ins’ from the dropdown menu at the bottom and click on ‘Go…
  4. Tick the checkbox next to ‘Solver Add-in’ and press ‘OK’.dan1

You should be able to access the tool from the ‘Data’ tab on the ribbon under the ‘Analysis’ section.

bullet step 1

 Opening the Samples


Follow the steps below to access the samples:

  1. While in Excel, press Ctrl+O.
  2. Now locate the drive where Microsoft Office is installed. It should be C:\ in most of the cases.
  3. Go to Program Files (x86) > Microsoft Office > Office14 > SAMPLES
  4. Now open SOLVSAMP.XLS

And there you have it! This file contains samples and guidelines on different types of widely encountered Solver problems like Product Mix, Transportation Problem, Investment Problem, Scheduling Problem etc. Also, it teaches you how to use Solver.dan2

bullet step 2

 Getting Started with the Samples

  1. Read through the explanations given on the Quick Tour sheet to understand what type of problems one can use Solver for.


 Setting up Solver


  1. Go to Product Mix sheet.
  2. Click on the Target cell as shown in the diagram.
  3. Now click on Solver. You would find that the problem is already set up. The objective, variable and constraint cells have been properly selected. Click on ‘Solve’ to arrive at the maximal profit.  You can read the provided description and this set up in Solver to learn about Product Mix problems and efficient ways of setting such problems up in Excel.
  4. Browse through other sheets and you would see that differing layouts have been used for each of them. Read them, explore them and learn from them!dan3

What’s next?

Whenever you are working through a Solver problem, use this samples file. And, most importantly, do not forget to SHARE this post with your friends and colleagues!! Exercise your brain today by learning something new. Cheers!


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.