Mastering Excel: Goal Seek & Solver
Mastering Excel: Goal Seek & Solver
English | 2017 | ASIN: B0725R1MW7 | 72 pages | AZW3/PDF/EPUB (conv) | 7 Mb
English | 2017 | ASIN: B0725R1MW7 | 72 pages | AZW3/PDF/EPUB (conv) | 7 Mb
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.