Tools From Advanced Excel Courses: Goal Seek and Solver

Next article
Previous article
Back to article list
back to category Back to Excel articles
Subscribe to feed (What's this?)

Wed 12th March 2008

Excel has a number of powerful tools for numerical analysis that can reduce complicated problems into fairly simple answers. Two of these that are covered in advanced Excel courses are Goal Seek and Solver.

Goal Seek: Looking For a Specific Answer

Goal Seek is the tool to use when you know the answer to an equation but don't know the input values to put out that answer.

Consider a simple example. You sell 100 units of a product per week for

Author is a freelance copywriter. For more information on advanced+excel+courses, please visit http://www.microsofttraining.net

Original article appears here:
http://www.microsofttraining.net/article-299-advanced+excel+courses.html

Back to article list

Distribution notes

PUBLICATION GUIDELINES

You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
If you do not agree to these terms, please do not use this article.

Rate this page:

Currently 2.79/5
1
2
3
4
5

2.8/5 (129 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