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

preview_player
Показать описание
★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post★

★ 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 ★

★ Where to find Excel Off The Grid ★

#MsExcel
  1. Excel Off The Grid
Рекомендации по теме
Forecast seasonality in 0:07:57

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

Forecasting in Excel 0:05:42

Forecasting in Excel Made SIMPLE (include seasonality & make predictions)

How to Forecast 0:07:10

How to Forecast the future values using Excel make predictions easily using excel

The Excel FORECAST 0:05:31

The Excel FORECAST Function

How to Add 0:07:36

How to Add Seasonality to your Excel Forecast

Forecast Seasonality in 0:11:42

Forecast Seasonality in EXCEL!

Seasonality in Time 0:15:46

Seasonality in Time Series: Integrate it into Demand Forecasting (Full Excel Tutorial)

Forecasting for Seasonality 0:04:51

Forecasting for Seasonality in Excel

Forecasting in Excel 0:11:23

Forecasting in Excel Tutorial

Operations Management using 0:13:32

Operations Management using Excel: Seasonality and Trend Forecasting

How to use 0:07:30

How to use FORECAST.ETS.SEASONALITY function in Excel - Office 365

FORECAST.ETS.SEASONALITY Function with 0:01:29

FORECAST.ETS.SEASONALITY Function with Example in MS Excel 2016

Monthly Sales Forecast 0:11:21

Monthly Sales Forecast with Seasonality and Trend - EXCEL regression with dummy variables

Seasonal Demand Forecasting 0:04:20

Seasonal Demand Forecasting Simplified With Excel

The Forecast.ETS Function 0:00:29

The Forecast.ETS Function

Forecasting in Excel 0:13:23

Forecasting in Excel | Seasonality & Confidence Intervals

Seasonality and Trend 0:09:34

Seasonality and Trend Forecasting Video 2: Multiple SKUs

Forecasting Seasonality Using 1:08:17

Forecasting Seasonality Using Excel Solver Tutorial

Calculating Seasonal Indexes 0:02:50

Calculating Seasonal Indexes (without trend) in Excel | Forecasting

4 8 13 0:20:08

4 8 13 Seasonality with Trend Forecasting Excel

How to Calculate 0:03:23

How to Calculate a Seasonal Index Forecast in Microsoft Excel (Example)

Building a Rolling 0:09:56

Building a Rolling Forecast in Excel

Excel FORECAST ETS 0:02:08

Excel FORECAST ETS SEASONALITY Function

Basic Forecasting in 0:44:57

Basic Forecasting in Excel Tutorial (SLOPE, INTERCEPT, FORECAST.LINEAR, TREND, Forecast Sheets)

Комментарии
Автор

This was SO helpful!!! I spent 2 hours trying to read blogs and figure out how to do this before I stumbled across this video. I followed your step-by-step process and it worked on my first try! Thank you for sharing this.

turnerfamily
Автор

Excellent video! Thank you for creating/sharing this!
A friend and I have been working on a sales forecasting project and this video is perfectly timed to help out with it.

EricHartwigExcelConsulting
Автор

Great Mark! Thanks for the in-depth explanation. Thumbs up!!

wayneedmondson
Автор

Superb video. Tiny mistake: Instead of 8764, it is 8760, the number of hours in a year. Thank you Mark!!

IvanCortinas_ES
Автор

This video solved my problem. Thank you!

johnlucanas
Автор

@ExcelOffTheGrid can this be used for non revenue data...?

spongebobby