Minimize costs? Create a conference schedule with fewest early-morning sessions? In this excerpt from the book Data Smart, find out how to use Excel's free Solver add-in to do some data science ...

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

In designing the spreadsheet optimizer that is bundled with Microsoft Excel, we and Microsoft made certain choices in designing its user interface, model processing, and solution algorithms for linear ...