Forecasting in Excel - Must Skill for Data Analyst | Excel Tutorial

[@gunjangandhi4405]

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 😊😊

[@RishabhMishraOfficial]

Noted ✅️

[@thecosmos1121]

​@@RishabhMishraOfficial yes sir pls we are waiting ❤

[@krishnapatel9216]

Ya , really nice point

[@05ashis]

Instead of reels I started watching your video, love your teaching style

[@RishabhMishraOfficial]

Glad you liked it ✅️ all the very best brother 👍

[@learndigitalmarketinwithChetan]

bhai ye banda gajab hai....Thanks for the knowledge.

[@RobinnHood722]

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

[@RishabhMishraOfficial]

Glad you liked it, all the very best brother 👍

[@AsiaBibitipsandbenefits]

Same here, i skipped the movie today and kept watching his videos, he is just amazing...

[@phalangmiki]

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

[@thisiskaushal]

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!

[@AnnuAK12]

i still see lecture from targeting 500 or 1000 likes now reaching beyond PAR it. congratulation Rishabh from Myside ( Business Analyst)

[@mdmustfa6726]

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

[@Opinionofageek]

Thank you! No complex jargon, simple and necessary

[@RishabhMishraOfficial]

Glad it helped! ✅️

[@adityasalunke3977]

Need more people like you who teach such imp skills for those who can't afford to pay lakhs of rupees for courses.

[@maheswarmishra8050]

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.

[@sahilKhan-wj8sc]

You are great in it after watching your video i started doing Business analyst.

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@manendrakumar1878]

Thanks Risabh. You have explained the forcasting perfectly.

[@RishabhMishraOfficial]

Glad you liked it

[@sipradas5869]

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.

[@voradeepika]

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.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@ZaidAhmad-mu7si]

​@@RishabhMishraOfficialyou dont provide certificates???

[@janniferroy9807]

Just a gem of a person you are Rishabh , Really appretiate your time and effort making these videos which are really helpful.

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@soumyajeetmitra6958]

Wah! bhaiyya! badhiya sikhaya apne

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@nsdashok]

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....

[@RishabhMishraOfficial]

Glad you liked it n learnt something from this video 👍 Keep learning n keep growing 🚀

[@yashkhandelwal2405]

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.

[@RishabhMishraOfficial]

Yess that's true.. 💯 keep learning n keep growing 🚀

[@mdkaish95]

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.

[@niaprasad4374]

Happy to see.. Your channel is growing Sir😊

[@RishabhMishraOfficial]

Thank you so much 🙌

[@SuperVishalchhabra]

Wondering what was I doing in excel so far...thanks for making this video

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@Mr_AbdulRehman]

Well explained. Made very easy to understand. Appreciate it.

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@supreme.pinnacle]

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) 😭💖

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@rituraj5249]

Thanks a lot Rishabh bhaiya, your videos are very informative. Grateful to having your such videos in simple way.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@babagin]

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

[@shaileshsingh3926]

Hey Rishabh bro Thanks for incredible video Me to fan ban gya hu apka

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@vikasOSA]

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

[@RishabhMishraOfficial]

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

[@rohitKumar-hu2ez]

Thank you Rishabh. Very helpful!!

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@MukulPatro]

Your teaching style and examples are amazing rishab bhaiya... Keep making more videos like this..👍

[@RishabhMishraOfficial]

Glad you liked ✅️

[@pritammishra9850]

Accha laga.. Short simple

[@karmanaydhir4932]

Thanks brother god bless you

[@indian35556]

Nice Rishab. I have never seen this in excel. Great

[@maheswarmishra8050]

Mujhe Aapka Brinda Store Wala Videos Bahut Pasand Aaya, Aur Main Ne Apke Video Dekh Ke Boh Project Ready Kiya Hai.

[@RishabhMishraOfficial]

Super awesome brother, keep learning n keep growing 🚀

[@maheswarmishra8050]

@@RishabhMishraOfficial Will Do Sir. Just Need Your Help Sir.

[@maheswarmishra8050]

@@RishabhMishraOfficial Bese Yeh Mera Papa Ka Naam Hai Sir, Mera Good Name Hai SuryaKant Mishra.

[@maheswarmishra8050]

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.

[@puripratham6593]

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

[@RishabhMishraOfficial]

Okay noted ✅️

[@jatinsharma4293]

Sir, this is so much informative, sir I want a more videos forcasting because I want more knowledge forcasting.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@akhiljain4793]

You are just brilliant

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@ashishbhatt7742]

Thanks for sharing insights

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@niaprasad4374]

Pls keep motivating us nd uploading moren more informative videos

[@RishabhMishraOfficial]

I will try my best 🙌

[@vaijayantigulve4883]

Amazing...!! Thank you once again.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@amritabiswas5785]

Great video, Rishab! Thanks for all your hardwork, it's really exciting to learn this way! :)

[@RishabhMishraOfficial]

Glad you liked it! ✅️

[@kidsatschool.5]

wow I love this forecasting feature. Its so cool

[@holycow810]

thank you from Pakistan.

[@Adityaprajapati910]

Hey Rishabh, Well explained. Made very easy to understand. Thankyou for this valuable content😍

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@ushmaverma9093]

the last method really helped in my thesis. Thankyou sir please tell me that after this how to find the result

[@RishabhMishraOfficial]

Glad it's helpful ✅️

[@sumant542]

Thanku for this valuable content, make one long video and cover all the concepts which are important for Data Analyst.

[@RishabhMishraOfficial]

Glad you liked it ✨️ n noted ✅️

[@mcrazestudios]

Excellent Presentation with good examples 👏🏻 I was easily able to understand the concepts. Thank you so much 🧡

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@harshitverma1263]

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.!!!!

[@RishabhMishraOfficial]

Okayy noted ✅️

[@azizahmedkhan669]

i also have the same request for sir.

[@debanjanabiswas111]

This is so cool! Thank youu!!😊

[@RishabhMishraOfficial]

Glad you liked ✅️

[@Justzchill]

bruv, this video is really owesome

[@rithikahuja8203]

Very informative video best explanation ❤❤love to see your way of teaching

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@ishaeconomy1172]

Very nicely explained

[@RishabhMishraOfficial]

Glad you liked ✅️

[@rohitbhat136]

just subscribed u Rishabh bhai , thankyou for ur efforts

[@RishabhMishraOfficial]

Glad you liked ✅️ n welcome aboard 🚀

[@vivek-kumar-rai]

Great tutorial. 👌

[@planetarchives]

very informative. thankyou. this has helped me clear my doubts to a great extent.

[@SheetalKumari-lk1vv]

Thanks for the video ❤

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@maheswarmishra8050]

Awesome Sir Yeh Video Bhi Jabardast Tha

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@akhileshbutola5523]

It's so cool man. Please keep it up 👍

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@swagatikadas369]

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.. 🎊🎊

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@darshanapawar399]

Really amazing explanation please upload more videos related to data analytics

[@RishabhMishraOfficial]

Okayy noted ✅️

[@ashutoshpatil2637]

Insightful 👍

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@theani21]

Great video, please make more videos like this.

[@RishabhMishraOfficial]

More to come! ✅️

[@mohammed_Ansar]

Bhai, super super super.......

[@RishabhMishraOfficial]

Glad you liked ✅️

[@rupaliarora5005]

Amazing content Rishabh.. really enjoying, it's easy to understand. Keep making such videos 👏

[@MoNiKa-29-RN]

very informative video...Thank u sir

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@VivekPandey927]

Thank you sir 🙏 Sir make a video on SAP

[@avkashsharma2699]

Superb Video.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@ihgamingfun6295]

Very very nyc 🗽🗽🗽 bro 👍👍🤜🤜

[@RishabhMishraOfficial]

Glad you liked ✅️

[@sanjeevkumawat9694]

Well explained bro... helped a lot

[@RishabhMishraOfficial]

Glad it helped ✅️

[@mohammadadnanhayat8343]

Thank you so much.....

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@lakshmikanth1988]

@10:43 after implementing polynomial method how can we get the 7 days forecasted values as like forecast method? please help me, thanks

[@nitindogra6195]

Rishabh bhai when you are forecasting periods 11:35 , how to get the output in excel like numbers instead of just visually

[@ritu7907]

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

[@mirzab6475]

good yar bht ala

[@manurajput5883]

Thank you sir

[@RishabhMishraOfficial]

All the best 👍

[@eshanksharma7616]

Great content 👍

[@RishabhMishraOfficial]

Glad you liked it! 👍

[@diptip8015]

Hi sir, plz interval wise forecast bataye.

[@piyushgupta5617]

U r great !

[@naumanmahmood7830]

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.

[@aamirsiddiqui8276]

Excellent.

[@aditidhiman9432]

Hi Rishabh In my Excel 2013 there is no option of forecast. What I have to do??

[@mohammedsameer7231]

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

[@RishabhMishraOfficial]

That means, there are missing dates in your data. Pls check it n then use forecasting

[@PoojaGupta-gu2hc]

loved all your video tutorials

[@RishabhMishraOfficial]

Glad you liked ✅️

[@aviagarwal7288]

Please make the video for all shortcut on excel

[@WingsFacts23]

Sir please start complete cause of data analytics with all tools

[@RishabhMishraOfficial]

Okayy noted ✅️

[@nikitasrivastava5993]

Yes please

[@surajar3912]

Is this playlist good enough to get a job or else do we need more!?

[@surajar3912]

I'm speaking particularly for excel

[@pratapd4589]

Awesome

[@RishabhMishraOfficial]

Glad you liked ✅️

[@mohammadasad8028]

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,,,,

[@RishabhMishraOfficial]

Yes you can change the frequency from daily to monthly. Or you can do the sum of your daily forecast values

[@mohammadasad8028]

@@RishabhMishraOfficial I tried it, even getting the desired result in Yearly Basis but for monthly it is giving value error,,

[@RakeshMen-u4z]

Hindi version of Kevin. Nice.

[@sumitnerkar4101]

Sir forcasting analyst k par kya question puch skte h

[@pravallikanatra8728]

Hey need help : how to actually get values in the 2nd method ? like maybe from the equation but couldn't figure it out

[@dkj9929]

Great

[@SatishKumar-py3ro]

Sir how to find summary model of polynomial in excle pls

[@swastidalmia]

Hey, can you tell if the Forward Forecast feature is in Google Sheets or not?

[@praveenpanwar1045]

Interesting buddy

[@rithikahuja8203]

Bhaiya please there is a request you also make videos on python please ❤❤

[@RishabhMishraOfficial]

Coming soon. Working on it

[@kspatel212]

What if there are multiple variables of 'known ys'?

[@vishnupp5944]

Thanks

[@RishabhMishraOfficial]

Glad you liked ✅️

[@chinmayasahu8923]

Can you please create a project on forecasting

[@RishabhMishraOfficial]

Noted ✅️

[@studentstruggle7450]

Bhaiya power bi with python me advance for casting laiye

[@RishabhMishraOfficial]

Okayy noted ✅️