Chapter 12
Optimization Modeling with Solver
In This Chapter
Understanding optimization modeling
Setting up a Solver worksheet
Solving an optimization modeling problem
Reviewing the Solver reports
Noodling around with the Solver options
Setting a limit on Solver
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: the Solver.
When you use optimization modeling and the Excel Solver, you aren't problem solving ...
Get Excel Data Analysis For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
