Learn how to use Excel to forecast sales more effectively. Instructor Michael McDonald offers a primer on sales forecasting, regression analysis, data set construction, and more.
Overview
Syllabus
Introduction
- Using Excel for sales forecasting
- What is sales forecasting?
- Business intelligence and company sales
- Conventional forecasting methods
- Basics of business regression analysis
- Predict values with regression analysis
- Budgeting and forecasting using growth rates
- Gather sales data
- Using data from FRED
- Clean sales data
- Identifying outliers
- What do the results mean?
- Confidence intervals around the result
- Stress testing the results
- Customer transaction forecasting
- Running forecasts with non-numerical data
- Interpreting your forecast
- Running your own analysis
Taught by
Michael McDonald