Solver

The UK's most regular instructor-led training courses.
Training information: excel+course · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

Solver

Marc has attended:
Excel Advanced course

by - delegate Marc [1 post] (2008 May 6 Tue, 17:03) Reply

where is the solver option in the menu

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 May 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jun 5 Thu + 6 Fri	Bayswater	6	book now	£450	£485
2003/XP	2008 Jun 12 Thu + 13 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Jun 19 Thu + 20 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jul 3 Thu + 4 Fri	Southwark	6	book now	£450	£485
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	5	book now	£450	£485
Full Schedule: See all 65 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: solver

by - trainer Tracy platinum contributer [586 posts] (2008 May 6 Tue, 18:22) Reply

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

· Fun Things I've Done With Excel
· Tips to Facilitate Printing of Excel worksheets
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel Training - Numerical excellence for all

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

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Solver

Related articles

Excel tip:

Shortcut for deleting all comments in a spreadsheet