An Introduction to Spreadsheet Optimization Using Excel

How can one use "optimizers" to solve linear, nonlinear, and integer programs within spreadsheets?

Mark Broadie | Spring 2012

The major PC-based spreadsheets used today, Lotus, Excel, and Quattro, all have built-in optimizers. These optimizers allow linear, nonlinear, and integer programs to be solved within the spreadsheet. This guide provides a step-by-step introduction to using the optimizer that is built into Microsoft Excel.

Case ID: 120201

Buy select cases through Ivey Publishing and Harvard Business Publishing.