Читать книгу Excel Data Analysis For Dummies - Paul McFedries - Страница 45

Spreadsheet tools such as Goal Seek that change a single variable are useful, but unfortunately most problems in business are not so simple. You’ll usually face formulas with at least two and sometimes dozens of variables. Often, a problem will have more than one solution, and your challenge will be to find the optimal solution (that is, the one that maximizes profit, minimizes costs, or matches other criteria). For these bigger challenges, you need a more muscular tool. Excel has just the answer: Solver, a sophisticated optimization program that enables you to find the solutions to complex problems that would otherwise require high-level mathematical analysis.