Mike Alexander, "Excel Sales Forecasting For Dummies, 2nd Edition"
English | ISBN: 1119291429 | 2016 | PDF | 408 pages | 46 MB

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