Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

Solver

Resolved · Low Priority · Version 2007

Reply Tue 6 May 2008, 17:03Delegate Marc said...

Marc has attended:
Excel Advanced course

Solver

where is the solver option in the menu

For upcoming training course dates see: Pricing & availability

Reply Tue 6 May 2008, 18:22Trainer Tracy said...

RE: solver

Hi Marc,

The Solver option generates a solution given certain parameters. I will give you any example:

Let us say in A1 there is 50 and B1 is empty.

In C1 using the solver you specific the solution must be 100 to the question A1+B1=100. The computer goes through lots of possible solutions and give you a suggested solution of 50. This is a simple example but with more complicated formula it can be a very useful tool.

I hope that makes sense, if not let me know

Tracy

Excel articles

· Making The Most Of Filtering In Excel
· Microsoft Excel's Best Kept Secret
· Tools From Advanced Excel Courses: Goal Seek and Solver
· How to Create Better Excel Spreadsheets: Part One
· Data Basics Using Excel

Please browse our web site to find out more about
excel+course and other Microsoft training courses.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips