Excel formulas are perfect when you need to analyze information from the past, like sales figures, census data, and experimental observations. But life becomes more complicated when you need to plan for the future. Some of the problems you can face include:
To help you tackle these challenges, Excel includes a few specialized tools that you'll learn about in this chapter. First, you'll see how you can use Excel scenarios to consider multiple possibilities within the same worksheet. Next, you'll learn about Excel's goal-seeking tool, which provides a simple approach for calculating backward and filling in a missing value. Finally, you'll take a look at one of Excel's most sophisticated add-ins Solver , which is an all-purpose tool for making predictions and optimizing plans and projections.