goal seeker solver

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Goal seeker & Solver

Goal seeker & Solver

resolvedResolved · Low Priority · Version 2002/XP

Richard has attended:
Excel Advanced course

Goal seeker & Solver

Kindly explain the above subjects

RE: Goal seeker & Solver

Dear Richard

Goal Seeker and Solver are both know as What IF features that allow the management to make appropriate decisions.

A typical example of Goal Seek is if you were self employed and had taken a loan for a specific period at a specific annual rate of interest.

You would use the PMT function to calculate the monthly payments.

Once you have calculated the monthly payments and you predicted that for a set amount of period you can pay more or less than the calculated monthly payments you can use the goal seek to either calculate how much Loan you will be offered or how many months you can pay off the loan in.

If you need an example of goal seek please let me know by replying to this post and I should be able to attach it for you (both goal seek as well as solver!!)

Solver is also for analyzing What If situations!!


A typical example where you could use Solver would be when you currently have a 20 % overall profit but you want to set your profit to 30 % in the next year. You may want to find out how much your sales figure might have to be in order to achieve this target.

By using the Solver you tell Excel to provide you such changes in the Sales in order to achieve this result.

Another benefit you have in solver compared to using Goal Seek feature is that you can Cap (set limits) to some variables. for example, you might want to say that my marketing costs shouldn't be less than


 

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips


Server loaded in 0.09 secs.