Excel Sales Forecasting for Dummies, 2nd Edition
- 5h 55m
- Conrad Carlberg
- John Wiley & Sons (US)
- 2016
Excel at predicting sales and forecasting trends using Microsoft Excel!
If you're a sales or marketing professional, you know that forecasting sales is one of the biggest challenges you face on the job. Unlike other books on the subject, Excel Sales Forecasting For Dummies, 2nd Edition leaves arcane business school terms and complex algebraic equations at the door, focusing instead on what you can do right now to utilize the world's most popular spreadsheet program to produce forecasts you can rely on.
Loaded with confidence boosters for anyone who succumbs to sweaty palms when sales predictions are mentioned, this trusted guide show you how to use the many tools Excel provides to arrange your past data, set up lists and pivot tables, use moving averages, and so much more. Before you know it, you'll become a forecaster par excellence—even if numbers aren't your jam.
- Choose the right forecasting method
- Find relationships in your data
- Predict seasonal sales
- Filter lists or turn them into charts
Consider this guide your crystal ball—and start predicting the future with confidence and ease!
About the Author
Conrad Carlberg is a nationally recognized expert in quantitative analysis, data analysis, and management applications such as Microsoft Excel, SAS, and Oracle. He has been a sales engineer and also worked in product marketing. Conrad has written numerous books on Excel and other Microsoft Office applications. He holds a PhD in statistics.
In this Book
-
Introduction
-
A Forecasting Overview
-
Forecasting—The Basic Issues
-
Understanding Baselines
-
Predicting the Future—Why Forecasting Works
-
Choosing Your Data—How to Get a Good Baseline
-
Setting up Tables in Excel
-
Working with Tables in Excel
-
Summarizing Sales Data with Pivot Tables
-
Charting Your Baseline—It's a Good Idea
-
Forecasting with Excel's Data Analysis Add-in
-
Basing Forecasts on Regression
-
Entering the Formulas Yourself
-
Using Moving Averages
-
Changing Horses—From Moving Averages to Smoothing
-
Smoothing—How You Profit from Your Mistakes
-
Fine-Tuning a Regression Forecast
-
Managing Trends
-
Same Time Last Year—Forecasting Seasonal Sales
-
Ten Fun Facts to Know and Tell about Array Formulas
-
The Ten Best Excel Tools
