Mastering Excel: Goal Seek & Solver

This Excel lesson covers the heavy duty data analysis features of Excel:


Goal Seek

Scenario manager

Solver



These features let you tell Excel to run thousands of iterations to find the best answer, whether it be a specific number, the best result (maximum value) or the lower result (minimum value).

I go through each feature step-by-step and include many images to make learning the material easy. No technical jargon, just plain English and a few corny jokes thrown in for good measure.

As with all my lessons, there is a link inside where you can download follow-along workbooks to practice what you read.