Forum home » Delegate support and help forum » Microsoft Excel Training and help » Carlos

Carlos

ResolvedVersion 2007

Wed 15 Oct 2008, 16:12 Delegate Claudio said...

Claudio has attended:
Excel Advanced course

Carlos

Goal Seek tryin to have as answer a PERCENTAGE

Fri 17 Oct 2008, 15:55 Trainer Carlos said...

Goal Seek

Hi Claudio

Goal Seek is a What-If Analysis tool in Excel.

With Goal Seek you can set a formula to a new value (Goal) and then specify which one of the cells that the formula referenced as the cell to be adjusted.

If the selected cell is formatted as a percentage them you can enter the new Goal in the Set Value box as a percentage. The computer will take it into account in the calculation.

Hope this helps

Carlos

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

Carlos

Carlos

Goal Seek

Excel articles

Excel tip:

Convert a column into row quickly in Excel 2010