Forecast seasonality in Excel (EASY METHOD) | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy



★ Check out the blog post★
https://exceloffthegrid.com/how-to-fo...



★ About this video ★
Before Excel 2016, seasonality calculations required a lot of additional steps. However, with the introduction of the FORECAST.ETS function, forecasting seasonality in Excel is now easy.

0:00 Introduction
0:27 The scenario
1:05 FORECAST.ETS function
3:37 Using FORECAST.ETS
5:28 Common Errors
6:26 Predicting the seasonal pattern
7:27 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/




★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com


Twitter:   / exceloffthegrid  



#MsExcel