microsoft excel training in london - goal seek

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

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

resolvedResolved · Low Priority · Version 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:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips


Server loaded in 0.08 secs.