advanced.excel - 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