Previous article Next article Excel articles

Tools From Advanced Excel Courses: Goal Seek and Solver

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 https://www.stl-training.co.uk

Original article appears here:
https://www.stl-training.co.uk/article-299-advanced+excel+courses.html

Back to article list

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.

Excel courses in London and UK wide.

» Next available dates

Training courses

98.5 % recommend us

More live stats...

London's widest choice in
dates, venues, and prices

Public Schedule:

Buy now / Live dates

On-site / Closed company:

Get quote

Testimonials

CH2M
Consultant
Barthelemy Monhonval

"The course was very good, maybe a bit too basic for my level but was good revision as i do not use VBA very often. Also the course is an introduction, therefore probably the right level.

It would be useful to be able to take the code we wrote back home with us or to have a copy of the code in the manual as some section of the code are useful when starting coding."

Geolabs Limited
Laboratory Technician
Leon Nyoro

"One topic I would certainly appreciate. Are identifying the characteristics required to excel as a manager and detailed methods/approaches on how to optimize staff productivity (general sense). But all topics discussed were incredibly informative and would appreciate another seminar to further improve my skills."

Visas & Citizenship, UK Visas and Immigration
ECO
Andy Collins

"The key point was the delivery of the trainer, Andrew was enthusiastic which always helps, knowledgeable and engaged in a casual manner that got the best out of all attendees"

More testimonials

Clients

Client logo

Main client list

Article list

Articles RSS feed ^{What's this?}