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
Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods
Use popular data mining techniques in Microsoft Excel to better understand machine learning methods. Software tools …
book
INSPIRED, 2nd Edition
How do today’s most successful tech companies—Amazon, Google, Facebook, Netflix, Tesla—design, develop, and deploy the products …
book
Data Analysis with Microsoft Power BI
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
The Art of Communication
Bring nuance, depth, and meaning to every conversation you have The Art of Communication is for …