Book description
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
Table of contents
-
- Cover
- Introduction
- Part 1: Understanding Sales Forecasting and How Excel Can Help
- Part 2: Organizing the Data
- Part 3: Making a Basic Forecast
-
Part 4: Making Advanced Forecasts
- Chapter 12: Entering the Formulas Yourself
- Chapter 13: Using Moving Averages
- Chapter 14: Changing Horses: From Moving Averages to Smoothing
- 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 5: The Part of Tens
- About the Author
- Advertisement Page
- Connect with Dummies
- End User License Agreement
Product information
- Title: Excel Sales Forecasting For Dummies, 2nd Edition
- Author(s):
- Release date: July 2016
- Publisher(s): For Dummies
- ISBN: 9781119291428
You might also like
book
Business Forecasting
A comprehensive collection of the field's most provocative, influential new work Business Forecasting compiles some of …
book
Financial Forecasting and Decision Making
Many companies fail to succeed due to poor planning, which is one reason why accountants are …
book
Predictive Analytics: Microsoft Excel, 2nd Edition
EXCEL 2016 PREDICTIVE ANALYTICS FOR SERIOUS DATA CRUNCHERS! Now, you can apply cutting-edge predictive analytics techniques …
book
Financial Forecasting, Analysis and Modelling: A Framework for Long-Term Forecasting
Risk analysis has become critical to modern financial planning Financial Forecasting, Analysis and Modelling provides a …