advanced.excel - Solver

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

Resolved · Low Priority · Version Standard

Solver

Clive has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Clive [2 posts] (2007 Aug 15 Wed, 09:50) Reply

What is the solver utility used for please?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	6	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Solver

by - trainer Richard platinum contributer [813 posts] (2007 Aug 15 Wed, 09:55) Reply

Solver is a complex "What IF?" scenario solution tool. You are able to use it to analyse possible outcomes for a data model. The example covered in the Excel advanced course is of a company wanting to improve their profit.

You are able to specify the outcome desired, and then choose inputs that can be modified, and also what restrictions you want to put on that change. So you can specify limits that SOLVER will work to to provide an accurate range of solution.

Essentially it is data modelling.

Regards
Richard

RE: Solver

by - delegate Clive [2 posts] (2007 Aug 15 Wed, 16:59) Reply

Thanks Richard.

Rgds.

Clive

· Creating Charts with Excel
· Crazy Things People Have Done With Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel's Best Kept Secret
· Tools From Advanced Excel Courses: Goal Seek and Solver