Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

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