Excel® sales forecasting for dummies / Conrad Carlberg

Part 1: Understanding Sales Forecasting and How Excel can help
Chapter 1: A Forecasting Overview
Chapter 2: Forecasting: The Basic Issues
Chapter 3: Understanding Baselines
Chapter 4: Predicting the Future: Why Forecasting Works

Part 2: Organizing the Data
Chapter 5: Choosing your data: How to get A good baseline
Chapter 6: Setting up tables in Excel
Chapter 7: Working with Tables in Excel

Part 3: Making a Basic Forecast
Chapter 8: Summarizing Sales Data with Pivot Tables
Chapter 9: Charting Your Baseline: It's a good idea
Chapter 10: Forecasting with Excel's Data Analysis Add-in
Chapter 11: Basing Forecasts on Regression

Part 4: Making Advanced Forecasts
Chapter 12: Entering the Formulas Yourself
Chapter 13: Using Moving Averages
Chapter 14: Changing Horses: From Moving Averages to Smoothing
Chapter 15: Smoothing: How you profit from your mistakes
Chapter 16: Fine-Tuning a Regression Forecast
Chapter 17: Managing Trends
Chapter 18: Same Time Last Year: Forecasting Seasonal Sales

Part 5: The Part of Tens
Chapter 19: Ten Fun Facts to know and tell about Array Formulas
Chapter 20: The Ten Best Excel Tools

Includes Index.