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

excel in courses - goalseek

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

excel in courses - Goalseek

ResolvedVersion Standard

Imran has attended:
Excel Intermediate course
Excel Advanced course

Goalseek


When do you use Goalseek? For which purposes?

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

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.