• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 17. Analyzing Your Data > Using the Goal Seek Tool

Using the Goal Seek Tool

Goal Seek is a useful tool that you can use to achieve a certain value in a cell that contains a formula. The way you do that is to adjust the value of another cell that has a direct effect on the original cell. If I can afford $400 a month, what could I borrow? You can use Goal Seek to see how much you can borrow to make the payment of $500 per month.

How the Goal Seek Tool Works

The following To Do exercise shows you how Goal Seek works. You need to enter data on Sheet2 in the Data Analysis workbook to prepare for using Goal Seek.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint