advanced.excel - Solver

Resolved · Low Priority · Version Standard

Wed 15 Aug 2007, 09:50 Delegate Clive said...

Clive has attended:
Excel Intermediate course
Excel Advanced course

Solver

What is the solver utility used for please?

Wed 15 Aug 2007, 09:55 Trainer Richard said...

RE: Solver

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

Wed 15 Aug 2007, 16:59 Delegate Clive said...

RE: Solver

Thanks Richard.

Rgds.

Clive

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

advanced.excel - Solver

Solver

RE: Solver

RE: Solver

Excel articles

Excel tip:

Use shortcut keys to select rows or columns