Dummies.com
  • Print
  • Share
Excel Sales Forecasting For Dummies (0764575937) cover image

Excel Sales Forecasting For Dummies

ISBN: 978-0-7645-7593-8
Paperback
404 pages
March 2005
US $27.95 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

This is a Print-on-Demand title. It will be printed specifically to fill your order. Please allow an additional 2-3 days delivery time. The book is not returnable.
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.

  • Print
  • Share