Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel training in london - goal seek

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training in london - Goal Seek

microsoft excel training in london - Goal Seek

ResolvedVersion Standard

Kristy-lea has attended:
Excel Advanced course

Goal Seek

Where to use it

RE: Goal Seek

Hi Kristy-Lea

The best time to use it is when you need to check how a figure in a formula will change when the result is different.

A good example would be:

In a cell you have calculated how much you need to pay monthly on a loan.

If you increase the monthly payments you can check how this will affect how many months you will be paying.

Hope this helps

Carlos

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.