goal seeking
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Goal seeking

Goal seeking

resolvedResolved · Low Priority · Version 2007

replyReply Fri 6 Nov 2009, 15:11Delegate Ajay said...

Ajay has attended:
Excel Advanced course

Goal seeking

give me an example of when goal seeking would be useful

For upcoming training course dates see: Pricing & availability

replyReply Tue 10 Nov 2009, 07:50Trainer Anthony said...

RE: goal seeking

Hi Ajay, thanks for the query. There are many uses for the goal seeking function in Excel, two obvious ones being mortgage and loan queries. However, here's a tutorial on how to build a retirement calculator using Goal Seek:

http://chandoo.org/wp/2009/07/29/excel-goal-seek-tutorial/

Hope this helps,

Anthony

Mon 16 Nov 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard