How do I use Solver in Excel?

Resolved · Low Priority · Version 2007

Wed 14 May 2008, 15:51 Edited on Thu 15 May 2008, 14:53 Delegate 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.

Thu 15 May 2008, 14:55 Trainer 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 tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips

How do I use Solver in Excel?

How do I use Solver in Excel?

RE: How do I use Solver in Excel?

Excel articles

Excel tip:

Use Paint Brush to Format More than one Cell