Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Goalseek

excel in courses - Goalseek

ResolvedVersion Standard

Mon 4 Dec 2006, 15:48 Delegate Imran said...

Imran has attended:
Excel Intermediate course
Excel Advanced course

Goalseek

When do you use Goalseek? For which purposes?

Mon 4 Dec 2006, 16:11 Trainer Amanda said...

RE: Goalseek

Hi Imran

Thanks for your question.

Basically GoalSeek allows you to tell Excel what you want the result of a formula to be, and also tell Excel what inputs to the formula it can change in order to give you the result that you want.

Basically it saves you from having to keep manually adjusting the inputs to a formula to get the result (or a close enough result) that you want to get from your formula.

I hope this answers your question.
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

excel in courses - Goalseek

Goalseek

RE: Goalseek

Excel articles

Excel tip:

Shortcut for deleting all comments in a spreadsheet