Chapter 12

Optimization Modeling with Solver

In This Chapter

arrow Understanding optimization modeling

arrow Setting up a Solver worksheet

arrow Solving an optimization modeling problem

arrow Reviewing the Solver reports

arrow Noodling around with the Solver options

arrow Setting a limit on Solver

arrow Understanding the Solver error messages

In the preceding chapters of this book, I discuss how to use Excel tools to analyze data stored in an Excel workbook. However, you can also perform another sort of data analysis. You can perform data analysis that looks not at labels and values stored in cells but rather at formulas that describe business problems. In fact, Excel includes just such a tool for working on these kinds of problems: Solver.

When you use optimization modeling and Solver, you aren’t problem solving or analyzing ...

Get Excel Data Analysis For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.