Excel: Sales Forecasting
With Michael McDonald
Liked by 3,042 users
Duration: 1h 22m
Skill level: Intermediate
Released: 1/4/2021
Course details
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.
Skills you’ll gain
Meet the instructor
Learner reviews
-
rani baluja
rani baluja
Cashier at tpddl
-
Solomon Brown
Solomon Brown
Sr. Financial Analyst / Business Analyst / Project Manager
-
Elisa Falconi
Elisa Falconi
Laurea magistrale in Attività Motorie Preventiva e Adattata
Contents
What’s included
- Practice while you learn 1 exercise file
- Learn on the go Access on tablet and phone