From the course: Excel for Sales Professionals
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Quick forecasting
- [Instructor] Predicting future sales is a bit of an art and there are many approaches. Some take a top down approach where you look at marketing conditions and try to predict how those conditions can effect your sales team. But if you want to take a bottom up approach where you use your sales history and predict future results you can. And it's pretty quick and easy in Excel 2016. I have the '04, '08 forecasting file open and that's in the chapter four folder. So what I'm gonna do is I'm gonna click and drag from order date month to sales history and what that does is select two columns that contain date and sales amount. And I'm gonna go up to the data tab here and then click forecast sheet. So let's talk about this dialogue box and what it's telling us here. This blue line here is the sales history. This is the data that we already have in the spreadsheet. And then this stronger orange line here is the forecast based on the sales history. These lighter lines, this lower bound here…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Conditional formatting5m 1s
-
(Locked)
PivotTables3m 29s
-
(Locked)
Unpacking PivotTables3m 44s
-
(Locked)
Create a leaderboard2m 29s
-
(Locked)
Leaderboard finishing touches5m 37s
-
(Locked)
PivotCharts6m 24s
-
(Locked)
Funnel charts8m 42s
-
(Locked)
Quick forecasting7m 30s
-
(Locked)
3D maps5m 58s
-
(Locked)
-
-