See more Amazon Details

Contents Listing

Introduction.
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.