Introduction 1 Part 1: Understanding Sales Forecasting and How Excel Can Help 5 CHAPTER 1: A Forecasting Overview 7 CHAPTER 2: Forecasting: The Basic Issues 23 CHAPTER 3: Understanding Baselines 41 CHAPTER 4: Predicting the Future: Why Forecasting Works 53 Part 2: Organizing the Data 69 CHAPTER 5: Choosing Your Data: How to Get a Good Baseline 71 CHAPTER 6: Setting Up Tables in Excel 87 CHAPTER 7: Working with Tables in Excel 103 Part 3: Making a Basic Forecast 119 CHAPTER 8: Summarizing Sales Data with Pivot Tables 121 CHAPTER 9: Charting Your Baseline: It's a Good Idea 141 CHAPTER 10: Forecasting with Excel's Data Analysis Add-in 159 CHAPTER 11: Basing Forecasts on Regression 173 Part 4: Making Advanced Forecasts 189 CHAPTER 12: Entering the Formulas Yourself 191 CHAPTER 13: Using Moving Averages 219 CHAPTER 14: Changing Horses: From Moving Averages to Smoothing 237 CHAPTER 15: Smoothing: How You Profit from Your Mistakes 259 CHAPTER 16: Fine-Tuning a Regression Forecast 285 CHAPTER 17: Managing Trends 311 CHAPTER 18: Same Time Last Year: Forecasting Seasonal Sales 329 Part 5: The Part of Tens 349 CHAPTER 19: Ten Fun Facts to Know and Tell about Array Formulas 351 CHAPTER 20: The Ten Best Excel Tools 363 Index 373.