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!
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:
You should be able to access the tool from the ‘Data’ tab on the ribbon under the ‘Analysis’ section.
Follow the steps below to access the samples:
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.
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!
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.