Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||
List of Features
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.

Note All selected cells are updated in absolute formula with a $ sign

Shortcut  [Alt]+T+G