Microsoft Excel 10: Forecasting and Analysis - Hands-on
Microsoft Excel 10: Forecasting and Analysis
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