Mastering Excel: Goal Seek & Solver
2017 / English / PDF, EPUB, AZW3
7 MB Download
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.
