Excel

The UK's most regular instructor-led training courses.
Training information: excel+training · Microsoft+excel+training · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Excel

Candice has attended:
Excel Intermediate course

by - delegate Candice [1 post] (2008 Apr 23 Wed, 11:45) Reply

Can goal seek use multiple changing cells?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel

by - trainer Pete platinum contributer [799 posts] (2008 Apr 23 Wed, 14:12) Reply

Hi Candice, Thank you for your post, welcome to the forum, in answer to your question, Goal Seek is used when you know what answer you want, but don't know the exact figure to input for that answer. For example, you're quite certain that 8 multiplied by something equals 56. You just not sure what that missing number is. Is it 8 multiplied by 6? Or Is it 8 multiplied by 7? Goal Seek will tell you the answer. To answer your question Goal Seek is a single option What If, if you wish to query more than one cell, you should use Solver. I hope that has answered your question. Best regards Pete.

· Microsoft Excel's Best Kept Secret
· Advanced Excel Training - takes you to the next level
· Interesting Lifestyle Applications for Microsoft Excel
· Crazy Things People Have Done With Excel
· Reporting and Analysis with Excel

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips