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

[@turnerfamily5868]

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.

[@EricHartwigExcelConsulting]

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.

[@ExcelOffTheGrid]

Glad it was helpful! The biggest issue is when somebody says "but how does it calculate that number". Unfortunately, you then need an advanced statistics degree to understand the algorithm.

[@EricHartwigExcelConsulting]

@@ExcelOffTheGrid I purchased four books on the topic from amazon and you are right it is a lot of complex math.

[@IvanCortinas_ES]

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

[@ExcelOffTheGrid]

Where did I get the extra 4 from? 🤣 I think it’s a typo that I managed to repeat everywhere. Oops! 😁

[@johnlucanas24]

This video solved my problem. Thank you!

[@ExcelOffTheGrid]

Good news. 👍

[@spongebobby188]

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

[@ExcelOffTheGrid]

Yes, it can. It works with any numbers which have a cyclical nature.

[@spongebobby188]

@@ExcelOffTheGrid Brilliant! Thanks so much!

[@wayneedmondson1065]

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

[@ExcelOffTheGrid]

Thanks Wayne. I'm glad it was useful.

[@mohammadalghamdi5587]

Thank you for your illustration