From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using Solver

Using Solver - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using Solver

“

If you'd like to get a different answer for a formula or a function in Excel, and you would like to be able to control the variation of a number of other cells that control that formula, you want to be considering the feature called, Solver. We're looking at the Solver worksheet. This feature is actually an extension of or an optimization of the GoalSeek capability. We want a different answer here. We want this to be 265,000 in cell E14. The formulas in this worksheet and they're in columns C and D as well as E essentially build off of what's happening in column B. To activate "Solver", you need to first make sure that this feature is added in to your Excel capability. If you go to the Data Tab, if your version of Excel has already added this feature in, you'll see the word Solver in the Analysis group, just to the right of the Outline group. If you're not seeing this group or not seeing Solver, you'll need to take the following step. It only takes a few seconds and you need only to…

Contents