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


Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!


Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.


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


MrExcel 2022 Boosting Excel

April 2022

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


see more products »