Excel 2024: Find Optimal Solutions with Solver


November 4, 2024 - by

Excel 2024: Find Optimal Solutions with Solver

Excel was not the first spreadsheet program. Lotus 1-2-3 was not the first spreadsheet program. The first spreadsheet program was VisiCalc in 1979. Developed by Dan Bricklin and Bob Frankston, VisiCalc was published by Dan Fylstra. Today, Dan Fylstra runs Frontline Systems. His company wrote the Solver used in Excel. Frontline Systems has also developed a whole suite of analytics software that works with Excel.

If you have Excel, you have Solver. It may not be enabled, but you have it. To enable Solver in Excel, press Alt+T followed by I. Add a checkmark next to Solver Add-in.

Press Alt+T I to display the Add-ins dialog. Choose the box next to Solver Add-in to load Solver.
Press Alt+T I to display the Add-ins dialog. Choose the box next to Solver Add-in to load Solver.

To successfully use Solver, you have to build a worksheet model that has three elements:

  • There has to be a single Goal cell. This is a cell that you either want to minimize, maximize, or set to a particular value.
  • There can be many input cells. This is one fundamental improvement over Goal Seek, which can deal with only one input cell.
  • There can be constraints.

continue reading »

More Reading


Excel 2024: Do 60 What-If Analyses with a Sensitivity Analysis

Excel 2024: Do 60 What-If Analyses with a Sensitivity Analysis »

October 31, 2024 - by Bill Jelen


Goal Seek lets you find the set of inputs that lead to a particular result. Sometimes, you want to see many different results from various combinations of inputs. Provided that you have only two input cells to change, the Data Table feature will do a sensitivity analysis.

Excel 2024: Back into an Answer by Using Goal Seek

Excel 2024: Back into an Answer by Using Goal Seek »

October 28, 2024 - by Bill Jelen


Have you ever found yourself plugging in successively higher and lower values into an input cell, hoping to arrive at a certain answer?

Excel 2024: Protect All Formula Cells

Excel 2024: Protect All Formula Cells »

October 21, 2024 - by Bill Jelen


It seems unusual, but all 16 billion cells on a worksheet start out with their Locked property set to True. You need to unlock all of the cells first.

read more articles »

Featured Products


Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


The Transformative Magic of Power Query M Code in Excel and Power BI

August 2024

A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution


Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.


see more products »