Goal Seek : Microsoft Excel 2003

File

Edit

View

Insert

Format

Tools

Data

Window

- Introduction - - Parts of Microsoft Excel Window - - Functions used in Microsoft Excel - - Custom List - - Goal Seek - - Error Checking - - Groupping/Ungroupping cells - - Forms - - Data Validation - - Filters - - Sorting - - Freeze Panes -

What is Goal Seek?
This option is used to estimate the value. This option is applied on the cell containing the formula.
-Tools - Goal Seek, this will open a dialog box with following options.
-Set Cell – type the name of the cell containing the formula.
-To Value – type the desired value.
-By Changing Cell – type the name of the cell which you want to be changed.