How to do forecasting with Excel 2016

Поділитися
Вставка
  • Опубліковано 13 гру 2024

КОМЕНТАРІ • 61

  • @rcssiddharth5986
    @rcssiddharth5986 3 роки тому +1

    Mr Flisser, I've seen one of the best forecasting tutorials ever made on UA-cam. Thanks to you

  • @mwpv11
    @mwpv11 2 роки тому

    Great lesson Bob. Just started to use forecasting and this cleared up everything for me. Thank you and keep up the great work.

  • @andreeakuhn1922
    @andreeakuhn1922 5 років тому +4

    Mr. Flisser, I want to thank you for this tutorial. It helped me to understand all forecast's functions.

  • @anoop1439
    @anoop1439 6 років тому +5

    I couldn't have done my assignment without your help. Thank you so much Bob.

  • @MahadiHasan-qk5ko
    @MahadiHasan-qk5ko 7 років тому +9

    Sir, you are a great teacher of Ms. Excel. Your explanation is simply awesome !!!!

    • @BobFlisser
      @BobFlisser 7 років тому

      Thanks so much! Glad you like it.

  • @seshubabuvellanki2406
    @seshubabuvellanki2406 7 років тому +1

    Thank you Mr. Bob. I am going through excel forecasting for the first time and I am feeling like a pro only because of your lecture. Very helpful video for me

  • @paulsmith3820
    @paulsmith3820 3 роки тому

    Very helpful! Instead of typing in the syntax, I used the drop down dialogue boxes to enter the data. That is how I normally work with Excel; I find it much easer than typing in the syntax.

  • @saromijuwon7151
    @saromijuwon7151 3 роки тому +1

    Sir, I love the way you explained, you're really good

  • @priyansha2323
    @priyansha2323 3 роки тому

    This is such a simple and best explanation. thank you Bob!

  • @rkortez
    @rkortez 2 роки тому

    Excellent video! Thank you for sharing this!

  • @blakestraus717
    @blakestraus717 4 роки тому +1

    This was a phenomenal tutorial, thank you so much for sharing this Bob. You are an excellent teacher no less!

  • @jmp0207
    @jmp0207 3 роки тому

    Awesome video Mr. Flisser! Thank you very much!!

  • @kebincui
    @kebincui 2 роки тому

    Awesome. Thanks Bob for sharing

  • @agroasesor1
    @agroasesor1 6 років тому +1

    finally a coherent explanation about forecasting using a regular tool.
    Gacias mil, Señor ! ! !

  • @lorithompson4332
    @lorithompson4332 4 роки тому

    This is the best explanation of the different forecast functions. Would you be willing to post the location of the file again?
    Thank you, thank you!

  • @centdavids
    @centdavids 7 років тому +3

    This simple but well explained tutorial is great. Thanks a lot.

    • @softwareschool4114
      @softwareschool4114 7 років тому

      Thanks, glad you found it helpful!

    • @Danndy08
      @Danndy08 9 місяців тому

      @@softwareschool4114You are welcome

  • @frankconte2457
    @frankconte2457 3 роки тому

    Excellent demonstration! Thank you!

  • @eyesofdoriss
    @eyesofdoriss 2 роки тому

    thank you. great video! may i know what the number of FORECAST.ETS.STAT function tells us? what does that mean for 0.001?

  • @jimblack8027
    @jimblack8027 5 років тому

    Mr. Flisser, thank you for this presentation. It was excellent - and I'm no rookie to the subject of forecasting.

  • @KumarNishant181286
    @KumarNishant181286 4 роки тому

    Explained in simplest way.. Thank you

  • @chinhck2063
    @chinhck2063 4 роки тому

    i just wish that if the volume of your voice can be higher, Bob. thank you so much for this tutorial.

  • @umairfarrukh7646
    @umairfarrukh7646 5 років тому +1

    Thanks buddy really helpful may God Bless you

  • @mdparvezalam8104
    @mdparvezalam8104 2 роки тому

    Thank you, BOB. Aswesome

  • @tewfiksabongui2875
    @tewfiksabongui2875 4 роки тому

    Mr. Flisser, thank you, very useful. I'm looking at doing similar forecast analysis, just in my case I have over about 2500 different types of items, each one in its own column and I need to look into each of them separately, so what is the best way how to automate that the same seasonal criteria and steps get assigned to each of the items / columns? And a second question, I'm also work with a yearly stats, so seasonal nr 12, but I have a wider time range of 3,5 years, do I need to limit the time period to 3 years and ignore the data of the following half year to get the seasonality factor of 12?

  • @Rose-lu5bu
    @Rose-lu5bu 3 роки тому

    such a useful tutorial, thx a lot!

  • @THEGLADIUS101
    @THEGLADIUS101 6 років тому +1

    So my understanding is if you have no trend then seasonality will show 0? Also when you use the .ETS function and put in a number in the seasonality section (for eg 12) what does that mean? I am using this example but for my data excel is automatically taking the seasonality as 0.

  • @yogendrapratapsingh1
    @yogendrapratapsingh1 4 роки тому

    Thanks for this very informative video

  • @divyasingha
    @divyasingha 4 роки тому

    Hello.Mr Bob.There are many methods of forecasting like simple exponetial smoothing method,double exponetial,holt-winter(if trend & seasonality).can i perform all types of forecasting by using excel formula and not using the above mentioned method ? Plz respond

  • @fabiolio7394
    @fabiolio7394 4 роки тому

    Can this function be used in lotto forecasting numbers? Which to use liner? Can you do a video for lotto forecasting

  • @tarekatteya9492
    @tarekatteya9492 6 років тому

    Thank you, very helpful video. I have made the same, but the Seasonality value become 0 and Confidence values are greater than forecast sold quantities !!!

  • @Ryuzakari
    @Ryuzakari 6 років тому +1

    Thank you for the amazing tutorial.

  • @prasad9976
    @prasad9976 4 роки тому

    not only helpfull this is much helpfull thanks Bob

  • @arindambhattacharya7848
    @arindambhattacharya7848 4 роки тому

    Where was the seasonality data 12 used?

  • @sheryll9966
    @sheryll9966 6 років тому +1

    Hello! Thanks for posting this video. I wonder though, let's say I have counts of surveys and the Customer Satisfaction score (in %) for each period, can I still use the Straight Line method but do it separately for each of them to compute the future # of surveys and their corresponding Customer Satisfaction score goals?
    I'm also thinking if I used the Straight Line method to compute the Customer Satisfaction goals and then go back and use the values to compute the # of surveys necessary to get to those goals using Multiple regression, is that even possible? Thank you in advance! :)

  • @kazukinakamura1110
    @kazukinakamura1110 4 роки тому

    Hello, do you always have to put the dates down the rows? I am always working with forecast data by quarter/year and the timeline always goes across columns. I am seeing a number of tutorials that have it like you do. In theory excel should be able to process the data the same way correct?

  • @9824pravin
    @9824pravin 5 років тому

    Sir, this is the great video.. i would lik to know whether it is possible to forecast rainfall amount for more years in future.. will that be reliable.. awaiting for ur kind reply, Sir..

  • @jimblack8027
    @jimblack8027 5 років тому

    Sir, is this functionality available en masse? That is, if I have a hundred (or a thousand) Items with historical demand, is there a way to get this to forecast all of them in one batch job?

  • @shradha7074
    @shradha7074 6 років тому

    Sir I am unable to open the link provided to get the excel sheet, could you please attach the file in your description?

  • @Assirion
    @Assirion 2 роки тому

    It is so helpful. The only problem I have is actually clicking the FN+F3 on my Macbook... It goes into Siri....

  • @muratturan2636
    @muratturan2636 4 роки тому

    i tried this on both linear forecast and regular forecast functions on my monthly future revenue prediction sheet. However, the numbers came up very different in each function. Even when i was checking the previous years, the numbers were still very different so i don't know what i did wrong

  • @samwoon1947
    @samwoon1947 4 роки тому

    may I kindly ask in reality there are many products (Part numbers) to forecast. And each Part number required 3years past data each respectively.
    if I have 100 products to sell and I need to do a forecast of each product... then how can I do it in a easy way using excel?

  • @johng5295
    @johng5295 4 роки тому

    Thanks in a million.

  • @rafi010484
    @rafi010484 4 роки тому

    Thank you so much sir, Can anyone please help me how do I activate this statistical function in excel as I couldn't find it in my formulaes

  • @aminulislam210
    @aminulislam210 4 роки тому

    I can't seem to locate the chart in Mac. Can you someone help me?

  • @akshaykumarhalkude5159
    @akshaykumarhalkude5159 3 роки тому

    Hello anyone has link to download this excel sheet

  • @alaala3238
    @alaala3238 6 років тому

    Many thanks
    Great job

  • @waxdw1
    @waxdw1 7 років тому +2

    Thank you !!

    • @BobFlisser
      @BobFlisser 7 років тому

      waxdw1 Glad you found it helpful!

  • @Raghv9h
    @Raghv9h 6 років тому

    Thank You Very much :)

  • @musabibrahim7791
    @musabibrahim7791 6 років тому

    I'm follow Same steps, but I'm not get same result

  • @agungsukariman
    @agungsukariman 6 років тому

    I LOVE YOU SIR!

  • @Taxi2853
    @Taxi2853 6 років тому

    OHMAIGADDD YOU ARE AWESOME ABOUT THE DOUBLE CLICK TO DRAG DOWN

  • @albertovazquez5862
    @albertovazquez5862 7 років тому

    Thanks!

  • @MooseMalarkey
    @MooseMalarkey 4 роки тому

    Bob: What if you're using Excel 2016 on a Mac? ... If you really need to forecast, you're better off using the Windows version. LMAO

  • @KyleGushue
    @KyleGushue 6 років тому +1

    full of inaccuracies

  • @sungkuan6982
    @sungkuan6982 6 років тому +1

    Thanks very much!

    • @BobFlisser
      @BobFlisser 6 років тому

      Glad you found it helpful!