O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Goal Seek

When you're planning or forecasting, you'll often need to work backward from your target to derive the figures you need. For example, when planning your next financial year, you may need to find out how much you need to raise the selling price for your widgets to make an extra $30,000 a year.

To work this out, you can try increasing the unit price for the widgets until your revenue figure is $30,000 higher. But you can save time and effort by using Excel's Goal Seek feature to derive the required price automatically by working backward from the revenue figure.

To derive values using Goal Seek, follow these steps:

  1. Open the workbook that contains the data, and navigate to the worksheet that contains the calculation.
  2. Make active ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required