Excel: Sales Forecasting

Focused View

Michael McDonald

1:22:56

0 View

01 Introduction

001 Using Excel for sales forecasting.mp4

01:05

02 The Basics

001 What is sales forecasting .mp4

04:51

002 Business intelligence and company sales.mp4

04:11

03 What Goes into a Forecast

001 Conventional forecasting methods.mp4

03:17

002 Basics of business regression analysis.mp4

05:22

003 Predict values with regression analysis.mp4

03:20

004 Budgeting and forecasting using growth rates.mp4

04:49

04 Getting Data for a Forecast

001 Gather sales data.mp4

04:14

002 Using data from FRED.mp4

04:43

003 Clean sales data.mp4

04:41

004 Identifying outliers.mp4

06:52

005 What do the results mean .mp4

05:23

006 Confidence intervals around the result.mp4

06:11

007 Stress testing the results.mp4

05:41

05 Putting It All Together

001 Customer transaction forecasting.mp4

05:25

002 Running forecasts with non-numerical data.mp4

05:11

003 Interpreting your forecast.mp4

06:16

06 Conclusion

001 Running your own analysis.mp4

01:24

Description

Creating accurate and reliable sales forecasts is essential for any sales leader. Professor Michael McDonald shows how to use Excel to forecast sales more effectively, beginning with a quick primer on sales forecasting, then explaining the business intelligence used in forecasting and the basics of regression analysis. Next, Michael shows how to use Excel to gather the necessary data for your forecast, how to cleanse data so that it will lead to more accurate forecasts, and how to interpret and explain the results of a regression forecast. The course concludes with a sample project, forecasting sales for a fictional restaurant. In this sample project, you’ll construct a data set, compute a simple set of forecast metrics, and construct an in-depth sales forecast. Finally, Michael explains the limitations of sales forecasting and how you can mitigate risk.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Analytics

Excel Dashboard

Michael McDonald

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.