Create a forecast sheet in Excel that uses the ETS AAA smoothing algorithm.
- [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…and this upper bound here, this range…
- Using, modifying, and sharing templates
- Importing data from a database
- Cleaning up data
- Refreshing queries
- Pasting data
- Sorting and filtering tables
- Using slicers
- Adding a dynamic commission calculation
- Using conditional formatting
- Working with PivotTables and PivotCharts
- Creating a leaderboard
- Create period, monthly, and yearly summaries
- Creating dashboards
Skill Level Intermediate
1. Getting Started with Templates
2. Importing Sales Data
3. Working with Tables
4. Analyzing Sales Data
5. Build Awesome Sales Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.