Forecasting in Excel - Must Skill for Data Analyst | Excel Tutorial
Вставка
- Опубліковано 31 лип 2024
- Forecasting in Excel - Must Skill for Data Analyst | Excel Tutorial.
Forecasting is a must skill for any data science enthusiast. Learn step-by-step how to forecast in Excel using 3 methods
1. function
2. graph trendline
3. forecast sheet
🔗 Worksheet used in this video: bit.ly/3WyawPs
👍 Subscribe Now: bit.ly/3Fc7Gc6
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content⭐
00:00 Intro
00:14 What is forecasting
00:29 Forecast methods
00:42 Understanding Data
01:18 Method 1: Formula
03:56 Method 2: Graph-Trendline
12:01 Method 3: Forecast Sheet
14:48 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
Videos Related to Excel for data Analysis :
📢Full Excel Tutorial in one Video: • Excel Tutorial For Beg...
🔖Excel Tutorial Playlist: • Excel for Beginners | ...
➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣
👉Instagram: / rishabhnmishra
👉LinkedIn: / rishabhnmishra
👉Twitter: / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
More SQL for data science Videos:
📢Full SQL Tutorial in One Video: • SQL Tutorial for Begin...
🔖SQL Portfolio Project: • Data Analyst Portfolio...
🔖Most Asked SQL Interview Question: • Most Asked SQL Intervi...
🔖SQL Tutorial Playlist: • SQL Tutorial In Hindi
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!
#exceltutorial #dataanalytics #forecasting
Related keywords:
Forecasting in Excel Tutorial
Excel FORECAST Function
excel tutorial
data analyst skills
data analysis
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst
excel project for data analyst
project for beginners
excel project
excel tutorial
excel tutorial for beginners
data science project
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
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!
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.
bhai ye banda gajab hai....Thanks for the knowledge.
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
Amazing content Rishabh.. really enjoying, it's easy to understand. Keep making such videos 👏
Thanks brother god bless you
Need more people like you who teach such imp skills for those who can't afford to pay lakhs of rupees for courses.
wow I love this forecasting feature. Its so cool
Great tutorial. 👌
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
very informative. thankyou. this has helped me clear my doubts to a great extent.
Nice Rishab. I have never seen this in excel.
Great
Accha laga.. Short simple
Thank you! No complex jargon, simple and necessary
Glad it helped! ✅️
i still see lecture from targeting 500 or 1000 likes now reaching beyond PAR it. congratulation Rishabh from Myside ( Business Analyst)
Excellent.
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.
Well explained. Made very easy to understand. Appreciate it.
Glad it was helpful! ✅️
Excellent Presentation with good examples 👏🏻
I was easily able to understand the concepts. Thank you so much 🧡
Glad it was helpful! ✅️
Amazing...!! Thank you once again.
Glad you liked ✅️
U r great !
bruv, this video is really owesome
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.
This is so cool! Thank youu!!😊
Glad you liked ✅️
Thank you Rishabh. Very helpful!!
Glad it was helpful! ✅️
Great video, Rishab! Thanks for all your hardwork, it's really exciting to learn this way! :)
Glad you liked it! ✅️
Very informative video best explanation ❤❤love to see your way of teaching
Glad you liked it ✨️
It's so cool man. Please keep it up 👍
Glad you liked it ✅️
Instead of reels I started watching your video, love your teaching style
Glad you liked it ✅️ all the very best brother 👍
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 it was helpful ✅️
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 👍
Thanks for sharing insights
Glad it was helpful! ✅️
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 🚀
Hey Rishabh,
Well explained. Made very easy to understand.
Thankyou for this valuable content😍
Glad you liked it ✨️
Thanks a lot Rishabh bhaiya, your videos are very informative. Grateful to having your such videos in simple way.
Glad you liked ✅️
Happy to see.. Your channel is growing Sir😊
Thank you so much 🙌
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 ✅️
Thanks for the video ❤
Glad you liked it ✅️
Insightful 👍
Glad you liked it ✅️
very informative video...Thank u sir
Glad it was helpful ✅️
Interesting buddy
Your teaching style and examples are amazing rishab bhaiya...
Keep making more videos like this..👍
Glad you liked ✅️
Wah! bhaiyya! badhiya sikhaya apne
Glad you liked it ✅️
Great video, please make more videos like this.
More to come! ✅️
Awesome Sir Yeh Video Bhi Jabardast Tha
Glad you liked it ✨️
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
Well explained bro... helped a lot
Glad it helped ✅️
good yar bht ala
You are great in it after watching your video i started doing Business analyst.
Glad you liked it ✅️
Pls keep motivating us nd uploading moren more informative videos
I will try my best 🙌
Hey Rishabh bro
Thanks for incredible video
Me to fan ban gya hu apka
Glad you liked the content ✅️
Great content 👍
Glad you liked it! 👍
thanks
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 ✅️
Great
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.
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 ✅️
Thank you so much.....
Glad you liked it ✅️
just subscribed u Rishabh bhai , thankyou for ur efforts
Glad you liked ✅️ n welcome aboard 🚀
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
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
Bhai, super super super.......
Glad you liked ✅️
Thank you sir
All the best 👍
Hi sir, plz interval wise forecast bataye.
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 🚀
Really amazing explanation please upload more videos related to data analytics
Okayy noted ✅️
Nice
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.
Awesome
Glad you liked ✅️
Thanks
Glad you liked ✅️
Very very nyc 🗽🗽🗽 bro 👍👍🤜🤜
Glad you liked ✅️
Wondering what was I doing in excel so far...thanks for making this video
Glad it was helpful! ✅️
Please make the video for all shortcut on excel
Hi Rishabh In my Excel 2013 there is no option of forecast. What I have to do??
Rishabh bhai when you are forecasting periods 11:35 , how to get the output in excel like numbers instead of just visually
@10:43 after implementing polynomial method how can we get the 7 days forecasted values as like forecast method? please help me,
thanks
What to do if I want to forecast sales of top 10 category in the graph. So how to do that??
loved all your video tutorials
Glad you liked ✅️
What if there are multiple variables of 'known ys'?
Sir forcasting analyst k par kya question puch skte h
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 ✅️
Need to fix top rows for forecast formula
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.
i could not use third method. as it says data not evenly distributed. it wants 7 days apart data in office 365
👍🏼
admirably underscored
Why regression analysis only gives R2 value of linear trend
Hey , Miara excel ma last wala option forecast nai hai am using the WPS Office so what should i do now
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
love from pakistan
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
Can you please create a project on forecasting
Noted ✅️
Sir please start complete cause of data analytics with all tools
Okayy noted ✅️
Yes please
Mera trendline ke according R2 change naahin ho rahe sir
Bhaiya please there is a request you also make videos on python please ❤❤
Coming soon. Working on it
Bhaiya power bi with python me advance for casting laiye
Okayy noted ✅️
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 .
Is this playlist good enough to get a job or else do we need more!?
I'm speaking particularly for excel
Hi Risabh bhai, can we use this forecasting as a project for a Data analyst job?
Yes, you can