Just a taste. In Excel, optimization problems are solved using an Add-In that ships with Excel called Solver. On Windows, Solver may be added in by going to File (in Excel 2007 it’s the top left ...

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.