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!
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
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.
started watching your videos for fun but now watching daily and opted to build my career as DATA ANALYST as i'm enjoying these vidoes along with the practical work
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.
Sir you are great. This time many doubt for learner but no any person guide. Many course charge high amount.most people can't afford it. Then they future stop while they have potential to do it.
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.
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.
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
Thenkuuuu soo much sir for this explanation !! 💗 Genuinely speaking you don't deserve 300k actually you deserve 30 million for this level of content. ( Just Telling from bottom of my heart) 😭💖
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....
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
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.!!!!
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.
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.. 🎊🎊
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.
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
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
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,,,,
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 😊😊
Noted ✅️
@@RishabhMishraOfficial yes sir pls we are waiting ❤
Ya , really nice point
Instead of reels I started watching your video, love your teaching style
Glad you liked it ✅️ all the very best brother 👍
bhai ye banda gajab hai....Thanks for the knowledge.
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!
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
Glad you liked it, all the very best brother 👍
Same here, i skipped the movie today and kept watching his videos, he is just amazing...
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
i still see lecture from targeting 500 or 1000 likes now reaching beyond PAR it. congratulation Rishabh from Myside ( Business Analyst)
Thank you! No complex jargon, simple and necessary
Glad it helped! ✅️
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.
Need more people like you who teach such imp skills for those who can't afford to pay lakhs of rupees for courses.
You are just brilliant
Glad you liked the content ✅️
started watching your videos for fun but now watching daily and opted to build my career as DATA ANALYST as i'm enjoying these vidoes along with the practical work
Thanks Risabh. You have explained the forcasting perfectly.
Glad you liked it
You are great in it after watching your video i started doing Business analyst.
Glad you liked it ✅️
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.
Wah! bhaiyya! badhiya sikhaya apne
Glad you liked it ✅️
Sir you are great. This time many doubt for learner but no any person guide. Many course charge high amount.most people can't afford it. Then they future stop while they have potential to do it.
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.
Glad you liked ✅️
@@RishabhMishraOfficialyou dont provide certificates???
Just a gem of a person you are Rishabh , Really appretiate your time and effort making these videos which are really helpful.
Glad you liked the content ✅️
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.
Yess that's true.. 💯 keep learning n keep growing 🚀
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
Happy to see.. Your channel is growing Sir😊
Thank you so much 🙌
Thanks a lot Rishabh bhaiya, your videos are very informative. Grateful to having your such videos in simple way.
Glad you liked ✅️
Well explained. Made very easy to understand. Appreciate it.
Glad it was helpful! ✅️
Thank you Rishabh. Very helpful!!
Glad it was helpful! ✅️
Thenkuuuu soo much sir for this explanation !! 💗 Genuinely speaking you don't deserve 300k actually you deserve 30 million for this level of content.
( Just Telling from bottom of my heart) 😭💖
Glad you liked the content ✅️
Nice Rishab. I have never seen this in excel.
Great
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....
Glad you liked it n learnt something from this video 👍
Keep learning n keep growing 🚀
Great video, Rishab! Thanks for all your hardwork, it's really exciting to learn this way! :)
Glad you liked it! ✅️
wow I love this forecasting feature. Its so cool
This is so cool! Thank youu!!😊
Glad you liked ✅️
Amazing...!! Thank you once again.
Glad you liked ✅️
Thanks for sharing insights
Glad it was helpful! ✅️
bruv, this video is really owesome
very informative. thankyou. this has helped me clear my doubts to a great extent.
Thanks brother god bless you
Your teaching style and examples are amazing rishab bhaiya...
Keep making more videos like this..👍
Glad you liked ✅️
thank you from Pakistan.
Hey Rishabh bro
Thanks for incredible video
Me to fan ban gya hu apka
Glad you liked the content ✅️
It's so cool man. Please keep it up 👍
Glad you liked it ✅️
just subscribed u Rishabh bhai , thankyou for ur efforts
Glad you liked ✅️ n welcome aboard 🚀
Great tutorial. 👌
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
Thanks for the video ❤
Glad you liked it ✅️
Pls keep motivating us nd uploading moren more informative videos
I will try my best 🙌
Wondering what was I doing in excel so far...thanks for making this video
Glad it was helpful! ✅️
Accha laga.. Short simple
Hey Rishabh,
Well explained. Made very easy to understand.
Thankyou for this valuable content😍
Glad you liked it ✨️
Insightful 👍
Glad you liked it ✅️
Very nicely explained
Glad you liked ✅️
Sir, this is so much informative, sir I want a more videos forcasting because I want more knowledge forcasting.
Glad you liked ✅️
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
Okay noted ✅️
Amazing content Rishabh.. really enjoying, it's easy to understand. Keep making such videos 👏
Excellent Presentation with good examples 👏🏻
I was easily able to understand the concepts. Thank you so much 🧡
Glad it was helpful! ✅️
Very very nyc 🗽🗽🗽 bro 👍👍🤜🤜
Glad you liked ✅️
Very informative video best explanation ❤❤love to see your way of teaching
Glad you liked it ✨️
Superb Video.
Glad you liked ✅️
Great video, please make more videos like this.
More to come! ✅️
Thanku for this valuable content, make one long video and cover all the concepts which are important for Data Analyst.
Glad you liked it ✨️ n noted ✅️
Thank you sir 🙏
Sir make a video on SAP
Bhai, super super super.......
Glad you liked ✅️
very informative video...Thank u sir
Glad it was helpful ✅️
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.!!!!
Okayy noted ✅️
i also have the same request for sir.
Really amazing explanation please upload more videos related to data analytics
Okayy noted ✅️
Awesome Sir Yeh Video Bhi Jabardast Tha
Glad you liked it ✨️
Great content 👍
Glad you liked it! 👍
the last method really helped in my thesis. Thankyou sir please tell me that after this how to find the result
Glad it's helpful ✅️
Well explained bro... helped a lot
Glad it helped ✅️
Mujhe Aapka Brinda Store Wala Videos Bahut Pasand Aaya, Aur Main Ne Apke Video Dekh Ke Boh Project Ready Kiya Hai.
Super awesome brother, keep learning n keep growing 🚀
@@RishabhMishraOfficial Will Do Sir.
Just Need Your Help Sir.
@@RishabhMishraOfficial Bese Yeh Mera Papa Ka Naam Hai Sir, Mera Good Name Hai SuryaKant Mishra.
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.
Thank you so much.....
Glad you liked it ✅️
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.. 🎊🎊
Glad you liked it ✅️
good yar bht ala
U r great !
Excellent.
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.
Thank you sir
All the best 👍
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
@10:43 after implementing polynomial method how can we get the 7 days forecasted values as like forecast method? please help me,
thanks
loved all your video tutorials
Glad you liked ✅️
Hi Rishabh In my Excel 2013 there is no option of forecast. What I have to do??
Awesome
Glad you liked ✅️
Interesting buddy
Rishabh bhai when you are forecasting periods 11:35 , how to get the output in excel like numbers instead of just visually
Great
Please make the video for all shortcut on excel
Hey need help : how to actually get values in the 2nd method ? like maybe from the equation but couldn't figure it out
Nice
Thanks
Glad you liked ✅️
Hi sir, plz interval wise forecast bataye.
Hey, can you tell if the Forward Forecast feature is in Google Sheets or not?
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
That means, there are missing dates in your data. Pls check it n then use forecasting
Sir how to find summary model of polynomial in excle pls
Is this playlist good enough to get a job or else do we need more!?
I'm speaking particularly for excel
Sir please start complete cause of data analytics with all tools
Okayy noted ✅️
Yes please
i could not use third method. as it says data not evenly distributed. it wants 7 days apart data in office 365
Bhaiya please there is a request you also make videos on python please ❤❤
Coming soon. Working on it
What if there are multiple variables of 'known ys'?
What to do if I want to forecast sales of top 10 category in the graph. So how to do that??
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,,,,
Yes you can change the frequency from daily to monthly.
Or you can do the sum of your daily forecast values
@@RishabhMishraOfficial I tried it, even getting the desired result in Yearly Basis but for monthly it is giving value error,,
how to find y value with r squared equation 0.0007x3-92.124x2+4E+.6X+10,what is the value of x?since they are years like 28-12-2023