An Introduction to Spreadsheet Optimization Using Excel
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
Contact us by e-mail at Columbia CaseWorks or 212-854-1796.
Professor Broadie currently teaches the elective courses Security Pricing: Models and Computation, Computational Finance, and Programming for Business Research. He is the Research Director for the Program for Financial Studies. His research interests include the pricing of derivative securities, risk management and, more generally, quantitative methods for decision-making under uncertainty. Broadie is the financial engineering area editor of Operations Research and serves on... View Full profile
Personal Website