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
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
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.
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.
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 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.
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....
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.
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
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
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) 😭💖
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.
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.!!!!
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.. 🎊🎊
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
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.
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,,,,
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 .
12:22 ye forecast sheet ka option mere nahi aaraha he bhaia. Mere me bhit se option ese nahi aarahe he jese aapke ke excel me he. I am using web excel free wala. Plese help
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...
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
i still see lecture from targeting 500 or 1000 likes now reaching beyond PAR it. congratulation Rishabh from Myside ( Business Analyst)
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 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.
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.
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 great in it after watching your video i started doing Business analyst.
Glad you liked 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???
Thanks Risabh. You have explained the forcasting perfectly.
Glad you liked it
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 ✅️
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.
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 🚀
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 🚀
Wah! bhaiyya! badhiya sikhaya apne
Glad you liked it ✅️
You are just brilliant
Glad you liked the content ✅️
Happy to see.. Your channel is growing Sir😊
Thank you so much 🙌
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
Well explained. Made very easy to understand. Appreciate it.
Glad it was helpful! ✅️
Wondering what was I doing in excel so far...thanks for making this video
Glad it was helpful! ✅️
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 a lot Rishabh bhaiya, your videos are very informative. Grateful to having your such videos in simple way.
Glad you liked ✅️
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 ✅️
Great video, Rishab! Thanks for all your hardwork, it's really exciting to learn this way! :)
Glad you liked it! ✅️
Hey Rishabh bro
Thanks for incredible video
Me to fan ban gya hu apka
Glad you liked the content ✅️
Amazing...!! Thank you once again.
Glad you liked ✅️
Nice Rishab. I have never seen this in excel.
Great
wow I love this forecasting feature. Its so cool
bruv, this video is really owesome
thank you from Pakistan.
Accha laga.. Short simple
Your teaching style and examples are amazing rishab bhaiya...
Keep making more videos like this..👍
Glad you liked ✅️
Thanks for sharing insights
Glad it was helpful! ✅️
Pls keep motivating us nd uploading moren more informative videos
I will try my best 🙌
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.
This is so cool! Thank youu!!😊
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 ✅️
very informative. thankyou. this has helped me clear my doubts to a great extent.
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 ✅️
Thanks brother god bless you
It's so cool man. Please keep it up 👍
Glad you liked it ✅️
Sir, this is so much informative, sir I want a more videos forcasting because I want more knowledge forcasting.
Glad you liked ✅️
Excellent Presentation with good examples 👏🏻
I was easily able to understand the concepts. Thank you so much 🧡
Glad it was helpful! ✅️
Hey Rishabh,
Well explained. Made very easy to understand.
Thankyou for this valuable content😍
Glad you liked it ✨️
Very nicely explained
Glad you liked ✅️
Very informative video best explanation ❤❤love to see your way of teaching
Glad you liked it ✨️
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 ✅️
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.
@10:43 after implementing polynomial method how can we get the 7 days forecasted values as like forecast method? please help me,
thanks
Thanks for the video ❤
Glad you liked it ✅️
Awesome Sir Yeh Video Bhi Jabardast Tha
Glad you liked it ✨️
Superb Video.
Glad you liked ✅️
just subscribed u Rishabh bhai , thankyou for ur efforts
Glad you liked ✅️ n welcome aboard 🚀
very informative video...Thank u sir
Glad it was helpful ✅️
Great tutorial. 👌
Bhai, super super super.......
Glad you liked ✅️
Insightful 👍
Glad you liked it ✅️
Amazing content Rishabh.. really enjoying, it's easy to understand. Keep making such videos 👏
Really amazing explanation please upload more videos related to data analytics
Okayy noted ✅️
Great video, please make more videos like this.
More to come! ✅️
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 ✅️
Well explained bro... helped a lot
Glad it helped ✅️
Very very nyc 🗽🗽🗽 bro 👍👍🤜🤜
Glad you liked ✅️
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
Great content 👍
Glad you liked it! 👍
Rishabh bhai when you are forecasting periods 11:35 , how to get the output in excel like numbers instead of just visually
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 🙏
Sir make a video on SAP
good yar bht ala
Hi Rishabh In my Excel 2013 there is no option of forecast. What I have to do??
Thank you so much.....
Glad you liked it ✅️
U r great !
Excellent.
Thank you sir
All the best 👍
loved all your video tutorials
Glad you liked ✅️
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
Awesome
Glad you liked ✅️
Is this playlist good enough to get a job or else do we need more!?
I'm speaking particularly for excel
95% is standard confidence level. Ideally keep it at 95%.
💯
Hey need help : how to actually get values in the 2nd method ? like maybe from the equation but couldn't figure it out
Please make the video for all shortcut on excel
Sir please start complete cause of data analytics with all tools
Okayy noted ✅️
Yes please
Interesting buddy
Sir forcasting analyst k par kya question puch skte h
Hi sir, plz interval wise forecast bataye.
Hey, can you tell if the Forward Forecast feature is in Google Sheets or not?
Great
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,,
What if there are multiple variables of 'known ys'?
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 how to find summary model of polynomial in excle pls
@RishabhMishra Forecasting sheet ka option hi show nahi ho raha hai MS Excel mel please help!
It will work for time series data. Use the file share in video description
@@RishabhMishraOfficial yes sir i did that. But the option is not available in the Data tab
i could not use third method. as it says data not evenly distributed. it wants 7 days apart data in office 365
12:22 ye forecast sheet ka option mere nahi aaraha he bhaia. Mere me bhit se option ese nahi aarahe he jese aapke ke excel me he. I am using web excel free wala. Plese help
Okk i think it might be due to version you're using, I'm using 365 version
Bhaiya hum web excel use ker rhe he..
@@RishabhMishraOfficial bhaiya ye desktop excel free me nahi ata he kya ? Windows me
@@RishabhMishraOfficial apka bhut bhut thankyou etna sikhane ke leye .