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 ...

Excel is incredibly powerful when your data is complete, but what happens when you need to solve for unknown variables? Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy ...