In this excerpt from the book Data Smart, find out how to use Excel's free Solver add-in to do some data science optimization in a spreadsheet. Topics Spotlight: New Thinking about Cloud Computing ...

If you want to use Excel's Goal Seek on multiple cells simultaneously, you'll need a much more powerful tool. Fortunately, one such tool comes with Excel. Let's have a look at the Solver add-in.