One of my favorite tips in Microsoft Excel 2007 is goal seek. The command can be found under What-If Analysis menu in data tools of Data tab. Generally, what-if analysis provide us several different sets of values in one or more formulas to explore all the various results. Within what-if analysis, a series of process to change the values is running, enabling us to see how those change will affect the result of formulas.
There are several command in What-if analysis: goal seeks, scenarios and data table. Both scenarios and data tables need sets of input values to determine possible results. If we only work with one or two variable then data table command is enough. Meanwhile, a scenario command has multiple variables and it addresses up to 32 values.
Related terms- what if analysis, goal seek excel 2011, goal seeking analysis, GOAL SEEK, why is goal seek used in spreadsheets, using goal seek in a table of data excel 2011, the purpose of goal seeking in a spreadsheet program, spreadsheet Goal Seek analysis, ms excel coral seek option what menu