00:02 Forecasting in Excel is crucial for data analysts 01:45 Forecasting in Excel helps in predicting future values easily 03:44 Adding trend line and interpreting model data 05:42 Selecting the best fitting model for forecasting. 07:31 Understanding the significance of R squared in forecasting models. 09:14 Forecasting in Excel can improve model performance 11:13 Select the right model for forecasting in Excel. 13:04 Adjusting confidence level for accurate predictions 14:43 Three methods for forecasting in Microsoft Excel Crafted by Merlin AI.
Rishabh Sir, if you read this comment pls reply... i am very much fascinated about your videos and the way you taught, thought and the expression.... and mostly when you used say that " agar aap ynha tk paunch gaye to pls like & subs... except than your videos.... i used to like in end of the video.... but in your case sir... suddenly i hear your voice and pause the video and like first.... because i am very much sure that i will get a very good thing a head..... thank you so much for skilling me like this.... even i cant get it after paying a lot of money....
Please keep making such videos ...industry oriented ...jo actual me kaam hota h ....faltu ni jo mostly teachers complex krte h...u r a gem... please never stop making such videos ....it can make some one's life ..we need it 😊😊
Hey Rishabh, I just wanted to take a moment to thank you for your amazing videos on excel. Your videos have been incredibly helpful in helping me understand Excel topic better. I really appreciate the time and effort you put into creating such informative and engaging content. Thank you again for all that you do!
Thank you so much, Rishabh.I have completed the Data Analyst course, but your explanation is beyond those lectures. Awesome videos.I loved the end-to-end projects which help me a lot to understand things better.
Sir Power Pivot Ka Videos Sikh Na Hai Aapse , Sir Bahut Saari Videos Dekha Pivot Table Dekha Hai, Lekin Aapse Achha Koi Achha Padha Ta Nahi Paya Mujhe Sir. Aap Bahut Achhi Tara Se Samjha Te Ho Sir.
00:02 Forecasting in Excel is crucial for data analysts 01:45 Forecasting in Excel helps in predicting future values easily 03:44 Adding trend line and interpreting model data 05:42 Selecting the best fitting model for forecasting. 07:31 Understanding the significance of R squared in forecasting models. 09:14 Forecasting in Excel can improve model performance 11:13 Select the right model for forecasting in Excel. 13:04 Adjusting confidence level for accurate predictions 14:43 Three methods for forecasting in Microsoft Excel
HI SIR THANK YOU FOR TEACHING EXCEL FOR BEGINNERS HI I HAVE ONE SMALL QUERY CAN YOU HELP ME WITH IT IN EXCEL FORECAST SHEET ITS SHOWING TIMELINE IS NOT EVENLY SPACED DATES AND NUMBERS MUST HAVE CONSISTENT GAP BETWEEN POINTS
I started understanding and love data analytics because of you. Even in my free time i keep watching your videos. Thankyou so much for sharing your knowledge and teaching us. Hope ill land my first data analyst job soon
Hey Rishabh For the last 4 years I have been using google sheets and there is the same formula called growth but this video is great for actual forecasts. Thanks
Thank u rishbah bhaiya, your videos are very helpful for beginners like me who is afraid of forecasting and data analysis. I'm getting confident after watching your videos and practicing the dummy data. You taught all the concepts in a very simplistic manner. Kindly upload more project videos on excel and power BI where multiple concepts are used. Doubt regarding forecast - Is it APPLICABLE TO DATA IN A UNIFORM INCREASING OR DECREASING PATTERN OR WE CAN USE FORECASTING EVEN FOR RANDOM DATA AS WELL? God bless you
Glad you liked it ✅️ Most of the time we apply forecasting to a dataset that follows a trend (inc or dec), but still u can apply it to a normal time series dataset
Bro plz make more videos related yur day to day work in data analytics field . it will really benificial for us . I m eagrly vwaiting for yur videos . Lots of thnks
Your videos are excellent & so easy to understand. The way you teach makes even complicated theories look easy. Please keep posting more such videos for Business analyst professionals.
Hiii Rishabh I m anand.i complete my graduation (bachelor in art). I have experience as marketing executive,now I want transition in data analytics,do you mentor me how I handle this gap .
SIR PLEASE TELL ME HOW CAN WE FORECAST IN A ANY EXCEL SHEET HAVING DATA IN (1 TO 8) ROWS AND IN (1 TO 6) COLUMNS AND ALL DATA IN DIGITS WHAT IS THE NEXT NO
Hi Rishabh, I am following your videos on different topics and learning very new things and this video is really one of the best that can help us to show our skills to someone as well and to use them in our business or job daily basis.
Hi Rishabh. Thanks for the amazing content. Also a humble request. Kindly make some more tutorials/projects on time series analysis, cohort analysis, sentimemt analysis, a/b testing, hypothesis etc because nowdays even for the data analyst fresher jobs , this questions are asked more often.!!!!
Tqq soo much for this excel course.👏🙏 Learn a lot. I have two qus plz reply. 1. What is the short cut key used to select large number of data without choosing header? 2. In your excel sheet in data tap a forecast option available but in my data tap there is no forecasting option? Plz reply my qus. Tqq so much for this journey towards data analyst.. And power pack lesson.. 🎊🎊
Hi Can you explain me how can we do the forecasting on Monthly basis? like for example I have sales data for January, February then what will be the sales for march,april,,, Similarly yearly,,,,
Good question, first thing excel mei you have limit of data Excel mei u can't customize your model Excel u can't combine multiple models to get better results Excel mei u can work on data processing in depth compared to ml, etc etc
Thank you so much, Rishabh.I have completed the Data Analyst course, but your explanation is beyond those lectures. Awesome videos.I loved the end-to-end projects which help me a lot to understand things better.
i am new subscriber of you please train all of us in excel skills according to the freelancers. and also let us know,what kind of project clients need to be done by us.
I mean unka email id pc main hai sir, aur mera smart phone main hai, mene apko bhi mere khud ke cellphone Main bhi aapka channel subscribe kiya hai sir.
Thanks sir for excellent video, but I was not able to completely understand forecast with excel ..pls make more videos on forecasting with excel and more easy and accurate videos with respect to sales forecasting as mostly forecasting is used for fmcg sales employees on everyday basis pls bring it soon we need to practice