[eBook Code] Excel Sales Forecasting For Dummies (eBook Code, 2nd)

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