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 » How do I use Solver in Excel?

	98.1 % recommend us
	More live stats...

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

Training information:

How do I use Solver in Excel?

Resolved · Low Priority · Version 2007

Reply Wed 14 May 2008, 15:51 Edited on Thu 15 May 2008, 14:53Delegate Ronnie said...

Ronnie has attended:
Excel Intermediate course
Excel Advanced course

How do I use Solver in Excel?

Tell me more about solver and how it works.

For upcoming training course dates see: Pricing & availability

Reply Thu 15 May 2008, 14:55Trainer Richard said...

RE: How do I use Solver in Excel?

Hello Ronnie,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding Solver.

Solver is part of a suite of commands sometimes called what-if analysis tools. With Solver, you can find an optimal value for a formula in one cell

Excel articles

· How To Use Freeze Panes In Excel 2007
· Replacing Cell Formats In An Entire Excel Workbook
· How To Use The New Excel Web App
· Summing Up Scenarios With Excel
· Using Find And Replace In Excel

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

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips