Previous article Next article back to category 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.3 % 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

Oystercatchers
Project Manager
Maria Kiuber

"The course was really great and all the tips I've picked up with be very helpful in the office.

The one thing that could be improved is the speed of the computers - simple things like PowerPoint and Excel at times took a little while to load!

I am booked on to my Intermediate Excel course next week at the same venue and I'm really looking forward to it!"

7IM
Operations Specialist
Emma Martin

"I have quite a good knowledge of Excel, but still learnt some new things, so that was very helpful. Lovely patient instructor and loved the pre-made exercises on the course Excel workbook.

I would have liked if the course also covered importing data into workbooks that we have previously created (at the moment I just copy and paste data in every time), but this may have been covered in one of the other courses that I haven't attended."

Medicspro Ltd
Bookkeeper
Josh Barnett

"Jens was incredibly enthusiastic and the facts about 500 functions, 60 can be used in 1 cell is impressive stuff!

To be honest the biggest improvement would have to be on directions, it was really confusing on how to even get to the building even with the directions I got via email!

The lesson had everything I needed for my job and anything I asked Jens was answered how I wanted.
I will be back for the advanced course and hope he is teaching again!"

More testimonials

Clients

Client logo

Main client list

Article list

Articles RSS feed ^{What's this?}