Excel Sales Forecasting For Dummies

Part I: 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 II: Organizing the Data.

Chapter 5: Choosing Your Data: How to Get a Good Baseline.

Chapter 6: Setting Up Lists in Excel.

Chapter 7: Working with Lists in Excel.

Part III: 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 Analysis ToolPak.

Chapter 11: Basing Forecasts on Regression.

Part IV: Making Advanced Forecasts.

Chapter 12: Entering the Formulas Yourself.

Chapter 13: Using Moving Averages.

Chapter 14: Evaluating a Moving Average.

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 V: The Part of Tens.

Chapter 19: Ten Pivot Table Troubles — and How to Overcome Them.

Chapter 20: The Ten Best Excel Tools.

Index.