From the course: Excel 2016 Essential Training

Unlock the full course today

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

Using Solver

Using Solver

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using Solver

- In the previous movie which you might have seen, called Goal Seek, we were able to change the result of a formula by changing one of the formula's components; in other words, one of the cells that contributes to that formula. A more sophisticated version of Goal Seek is called Solver, and ultimately, it's very sophisticated. We've got a worksheet here, and there's a total here, and the total is based on what's happening in a lot of different cells. Let's imagine that we want a different total here. We're the optimistic sort, maybe, and we're envisioning that this first quarter profit really should be, or could be, 265,000. The feature called Solver will allow us to come up with a new total based on not just one cell changing, but maybe many cells. If you were to review this worksheet, you would see there are formulas in column C, February entries here, that are based on entries in column B, and the column D entries are based on entries in column C, so ultimately, the data that we…

Contents