Excel Sales Forecasting For Dummies 2/e

Choose, manage, and present data

Select the right forecasting method for your business

Use moving averages and predict seasonal sales

Create sales forecasts you can trust

You don't need magic, luck, or an advanced math degree to develop reliable sales forecasts; you just need Excel and this book! This guide explains how forecasting works and how to use the tools built into Excel. You'll learn how to choose your data, set up tables, chart your baseline, to create both basic and advanced forecasts you can really use.

Inside...

• Prevent common issues
• Why baselines matter
• How to organize your data
• Tips on setting up tables
• Working with pivot charts
• How to forecast seasonal sales revenue
• Forecasting with regression