The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Goalseek

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

excel in courses - Goalseek

Resolved · Low Priority · Version Standard

ReplyMon 4 Dec 2006, 15:48Delegate Imran said...

Goalseek

When do you use Goalseek? For which purposes?

For upcoming training course dates see: Pricing & availability

ReplyMon 4 Dec 2006, 16:11Trainer Amanda said...

RE: Goalseek

Hi Imran

Thanks for your question.

Basically GoalSeek allows you to tell Excel what you want the result of a formula to be, and also tell Excel what inputs to the formula it can change in order to give you the result that you want.

Basically it saves you from having to keep manually adjusting the inputs to a formula to get the result (or a close enough result) that you want to get from your formula.

I hope this answers your question.
Amanda

Excel articles

· Using Excel For Simple Home Accounting And Budgets
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Data Validation In Excel
· How To Add Extra Data Ranges To An Excel Chart

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

How would you subtotal date and text columns

» Forum post: Subtotals

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions