advanced.excel - solver

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - Solver

advanced.excel - Solver

resolvedResolved · Low Priority · Version Standard

Clive has attended:
Excel Intermediate course
Excel Advanced course

Solver

What is the solver utility used for please?

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

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


Server loaded in 0.08 secs.