Virtually all sales professionals must produce forecasts,
and 98 percent of them use Excel to help them do it.
Keeping algebraic formulas and business school jargon to
a minimum, this veteran Excel consultant shows sales and marketing professionals how to predict sales with spreadsheets.
Packed with real-world examples from both large and small companies, the book takes readers step by step through the forecasting process, including averaging models, exponential smoothing models, trends forecasting, probability, forecast presentations, and more.
Part I: Understanding Sales Forecasting and How Excel
Can Help.
Part II: Organizing the Data.
Part III: Making a Basic Forecast.
Part IV: Making Advanced Forecasts.
Part V: The Part of Tens.