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

Поделиться
HTML-код
  • Опубликовано: 7 ноя 2024

Комментарии • 14

  • @turnerfamily5868
    @turnerfamily5868 Год назад +3

    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
    @EricHartwigExcelConsulting 2 года назад +2

    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
      @ExcelOffTheGrid  2 года назад +1

      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
      @EricHartwigExcelConsulting 2 года назад

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

  • @wayneedmondson1065
    @wayneedmondson1065 2 года назад +1

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

  • @mohammadalghamdi5587
    @mohammadalghamdi5587 2 месяца назад

    Thank you for your illustration

  • @spongebobby188
    @spongebobby188 4 месяца назад +1

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

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  4 месяца назад +1

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

    • @spongebobby188
      @spongebobby188 4 месяца назад

      @@ExcelOffTheGrid Brilliant! Thanks so much!

  • @IvanCortinas_ES
    @IvanCortinas_ES 2 года назад +2

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

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  2 года назад

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

  • @johnlucanas24
    @johnlucanas24 Год назад +1

    This video solved my problem. Thank you!