| || | Novice | || | Beginner | || | Intermediate | || | Advanced | || | Specialist | || | Expert | || |
List of Features
| Filter | Advanced Filter | Pivot Table | Group and Outline | Data Validation | Name Manager | ||||||
| Goal Seek | Freeze Panes | Split Screen | Conditional Formatting | Text to Columns |
Goal Seek
Locating Goal Seek
Goal Seek is used to get a particular result when you're not too sure of the starting value.
From the Excel menu bar, click on Data Locate the Data-> Analysis ->Goal Seek
We use the Set cell , To Value and By Changing cell to complete the Goal Seek exercise.
All selected cells are updated in absolute formula with a $ sign
[Alt]+T+G
Goal Seek is used to get a particular result when you're not too sure of the starting value.
From the Excel menu bar, click on Data Locate the Data-> Analysis ->Goal Seek
We use the Set cell , To Value and By Changing cell to complete the Goal Seek exercise.


