Description

Because Excel is such a powerhouse for storing and analyzing data, there are a wealth of tools for pushing from analyzing the past to forecasting the future. With tools like What-If, Scenarios, Solver, and a range of add-ins, Excel can create new charts and tables that explain potential future conditions.

Topics include:

• Creating new calculated results with What-if and Data Tables
• Adding Scenarios to existing calculations
• Searching for desired outcomes with Solver
• Sampling and forecasting data