Solving Business Questions with What-If Analysis, Goal Seek, and Solver

For much of your work with Excel, you’ll probably want to manipulate the hard data you already have, as you’ve been doing so far in the book. But at other times, you’ll need to ask questions of your data—for example, by how much do you need to raise prices to boost your revenue by a certain amount, or what will happen if you cut 10 percent off your manufacturing costs?