An optimization problem is one where you have to make the best decision (choose the best investments, minimize your company’s costs, find the class schedule with the fewest morning classes, or so on).

Solving linear programming problems in a spreadsheet yields equations for maximizing business profits. As applied to business, linear programming typically involves an objective formula, such as unit ...

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