★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Check out the blog post★
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 ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel
Негізгі бет Forecast seasonality in Excel (EASY METHOD) | Excel Off The Grid
Пікірлер: 13