Excel: Sales Forecasting
With Michael McDonald
Liked by 3,117 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
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
-
Daniela Popa
Daniela Popa
Statistical Programming| Clinical Trials| CRO FSP Oversight experience| Lead teams| Regulatory submissions
-
Nidal Hilal
Nidal Hilal
Assistant Procurement Manager /Senior Procurement Officer /Senior Sourcing Specialist /Supply Chain/ (Fitout/Construction/Manufacturing) AT AL…
Contents
What’s included
- Practice while you learn 1 exercise file
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.