Full Project in Excel with Interactive Dashboard | Excel Tutorial for Beginners
In this video will learn data cleaning, processing, analysis and dashboard creation in Excel. Complete data analytics project for data analyst in Excel.
Excel Dataset Download (direct): bit.ly/3X381ok
Excel Dataset Download (google drive): bit.ly/3Ypatqu
Excel GitHub Link: bit.ly/40vbJtI
➖➖➖➖➖➖➖➖➖➖➖➖➖
SUBSCRIBE!
Do you want to become a Data Analyst? This channel is all about learning data science skills, tips and projects. My goal is to help you learn everything you need to start or switch your career into data science. So, what are you waiting for..
👍 Subscribe Now: bit.ly/3Fc7Gc6
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content⭐
00:00 Intro
00:43 Project Intro
01:20 Sample Questions
01:54 Excel Data
02:16 Data Cleaning
06:27 Data Processing
10:17 Data Analysis
31:32 Interactive Dashboard
34:56 Insights
35:55 Next Steps
36:49 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
More Excel Tutorial videos:
🔖Forecasting in Excel - Must Skill for Data Analyst
• Forecasting in Excel -...
📢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 Tutorial 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 #dataanalystproject
Related keywords:
data analyst project
data analyst project for beginners
data analyst portfolio project
data analysis project
data analyst projects for resume
data science project,
data analyst excel project
excel tutorial
excel tutorial for beginners
end to end project for data analyst
excel project for data analyst
excel project
report in excel
dashboard in excel
Пікірлер: 1 800
Hi folks, in case anyone facing issue to download the excel Vrinda Store dataset can use this google drive link: bit.ly/3Ypatqu
@randomguy5183
Жыл бұрын
Thank you, Rishabh bhaiya. This link is working. 😃
@Prashant_Kumar_Srivastav
Жыл бұрын
Hii rishabh sir..I have doubt..Can you please suggest me..what is the use of python (numpy,pandas, matplotlib) in data analyst job.. because same work we can do easily in POWER BI.. And for automation also done by macros and vba in Excel..
@deepakrai6824
Жыл бұрын
Bhaiya ye dataset view only hai, pls give me access, need to complete this project today.🙏🙏 Request send kr rakha hu already
@faizakhan7073
Жыл бұрын
Tableau project b bna do please
@nurulhuda3203
Жыл бұрын
@@deepakrai6824 bhai apne kiya dataset download? O b sirf 3months ka hai na?
Brother you're soooooooooooooooooooo talented I swear. I have never got powerbi, excel and sql clearly but with your videos you made everything crystal clear...please please keep posting such content. I am watching you every single day :)
@irfanhasan1515
Жыл бұрын
Correct ..bhai
@shalunegi14dec
10 ай бұрын
Do uh know SQL Can uh help me
BRUH, this is the only video over 30min which i watched NON-STOP without moving a muscle!!!!!!!!! I am glad I found you!
@RishabhMishraOfficial
7 ай бұрын
Glad you liked it ✅️ keep learning n keep growing 🚀
You are the best teacher for any beginner. Randomly found out about your videos and they are all so simplified..can't tell you. Please keep uploading videos to make this easy for people like us.
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✅️
@ZaidAhmad-mu7si
Жыл бұрын
@@RishabhMishraOfficial plzz tell us how can we get valuable certificates we want...
Wow, this Excel dashboard tutorial is exactly what I needed! You have covered almost all the essential topics in just a short amount of time. Amazing! Thanks for sharing your expertise with us!
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful! ✅️
@ZaidAhmad-mu7si
Жыл бұрын
@@RishabhMishraOfficial brother plzz tell if there is any certificate or not..for excel from your side..how wwe will get recognised certificates
@kousik8042
Жыл бұрын
@@ZaidAhmad-mu7si do projects instead of collecting certificates
@ZaidAhmad-mu7si
Жыл бұрын
@@kousik8042 but employer ask for standard certificates as well..also certification gives value to linkedin and cv
@anjalijain1870
9 ай бұрын
can a beginner do this tutorial????///
Sir Thanks for your extensive and easy-to-understand lectures. I have learned Power BI and Excel from your KZread lectures, these are very helpful.
This is what every fresher and learner who is in starting zone want.. Thank you sir for this type of video it helps many fresher for making their project.
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful ✅️
This video was everything I needed to understand dashboard creation. So beautifully explained! BIG THANK YOU :D
Hi Rishabh! your video on Excel Dashboard is very helpful same as Power BI. I am leaning some new skills quite easily. Thank you for sharing your wonderful Data Science skills. God Bless you.
We need teachers like you. Thank you so much sir for making this awesome video. You nailed it !
@RishabhMishraOfficial
10 ай бұрын
Glad you liked the content ✅️
Hey Rishabh, you just nailed it. One of the best video on making interactive dashboard, you made everything crystal clear. You presented everything from the very basic and It was worth watching your video. May God bless you and have a great future ahead.
@RishabhMishraOfficial
9 ай бұрын
Glad it helped ✅️
I really appreciate all the sincere efforts for making this kind of content and Brother you don't have an idea how you are changing the lives of common people .. Thank you so much ...!!
@RishabhMishraOfficial
Жыл бұрын
I appreciate that! Keep learning n keep growing 🚀
You are a great tutor. Liked your way of explaining, content, Visuals.
Seriously sir i am very thankful to you I was searching for such content which is understandable for beginners like me that have no actual idea about data analyst how does perform his task thank you very much sir keep making videos god bless you
@RishabhMishraOfficial
Жыл бұрын
Glad it helped you, all the very best :)
Really appreciate your efforts. This is definitely going to help me add weight to my resume
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful!
Watching this KZread video has been incredibly enlightening for me, and I've learned so much from it. Thank you for sharing such valuable content!
@RishabhMishraOfficial
5 ай бұрын
Glad it was helpful! ✅️
I have done this project. I have learned a lot from this End to End Project. It is recommended by my side to other folks for praticing the excel skills. thanks
what an Amazing video it was. Learned a lot of things. Did your one hour excel video first before getting in this and that made me grasp things really fast. Now will do Powerbi as I've already did SQL and Python
@kazeenakathoon7205
Жыл бұрын
Python from wherr did you study? " pls reoly
Hi Rishabh, Great Dashboard, as always great explanation, crisp, concise and clear. Great content, you're a guiding light to many others like me, I really appreciate your efforts, keep it up.
@RishabhMishraOfficial
9 ай бұрын
Glad it was helpful ✅️
Bhaiya yaar kya si bataya h aapne me 4 din se paresaan tha do aur channels pe mene dekha whaa wo log slicer me itna problem create krwa de re the......but finally my dashboard is ready 👍👍👍👍. Thank you thanks a lot
Bhaiya bhut logo ki video dekhi but aapke jaisa koi nai hai
Amazing video, covered all important topics within 38 mins and is very informative.
@RishabhMishraOfficial
11 ай бұрын
Glad you liked it! ✅️
Good job 👍👍👍 Keep educating like this with great examples
@RishabhMishraOfficial
Жыл бұрын
Thank you, I will ✨️
rishabh bro great content once again ♥️this, Kindly provide these kind of projects which tells us real life work of data analyst that how data analyst works and kindly share problems with solutions to solve those problems, So we will gain knowledge of the field Rishabh hope you will enlighten us Thanks 👍
Your lectures are very insightful and helped a lot, thank you👍😊
To get the drop-down arrow for each column & apply filter use shortcut:- Ctrl+Shift+L 😊
@amanrana9571
10 ай бұрын
thanks!!
@ranjitodedra.
9 ай бұрын
thanks, bro this was really helpful!
@h.a.r.i.
9 ай бұрын
What should I use for paste as values
@mayushdwivedi
4 ай бұрын
just copy whole column then paste as value ,,, 😁😆 ik it has been 5 months @@h.a.r.i.
@alinajoy2980
4 ай бұрын
thankss
This Project helped me a lot and Finally i made a project on Excel and Boost up My confidence level . Thanks a lot for this .🙏🙏🙏🙏🙏
@RishabhMishraOfficial
Жыл бұрын
Glad to hear that! 🚀
Simply amazing, crustal clear, calm, no unnecessary commentary, very crysp and understandable oresenation and walkthrough.....🙏 Saadar Pranaam.
@RishabhMishraOfficial
Жыл бұрын
Glad you enjoyed it! 😉
This video was everything I needed to understand dashboard creation. So beautifully explained! BIG THANK YOU SIR🙏🙏🙏👏👏👏
Not only created the dashboard but also shared the insights ❤️❤️
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✨️
@arshittyagi3035
Жыл бұрын
"I created a slicer for 1st pivot table and I would like to connect it to other pivot tables. However, when I go to Slicer --> Report Connections, there is only one pivot table. " How to fix this issue?
@shreejipaliwal1215
Жыл бұрын
@@arshittyagi3035 i think you made mistake in creating pivot table or maybe you do not make separate pivot table
@user-bc6ti2pt3w
3 ай бұрын
@@arshittyagi3035I am having same issue how to solve it ??
Only because of you . I learnt sql , python and power bi and got placed in it company as team leader mis with decent package thanks 👍🙏
@amangurjar9714
8 ай бұрын
Bhaiya please help i am tier 3 engineering college I am applying for internship in data analyst but companies not responding please help
@RishabhMishraOfficial
8 ай бұрын
Glad to hear that ✅️ congratulations ✨️🚀
@swanandiw3802
5 ай бұрын
in case power sql and power bi is good can i get job ...plz reply
Thanks Rishab for your amazing explanation. Nice teaching style.
Great great content!! Simple and to the point!
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it! ✅️
With just one video bro I have not only created an impressive excel project but learned alot related to Pivot Tables. Thankyou for the information you are providing us.
@RishabhMishraOfficial
Жыл бұрын
Glad to hear that u learned something.. 🚀
@saumilgupta2383
Жыл бұрын
In data cleaning process HOW he is SAYING BY SIMPLY LOOKING ONLY SOME VALUES IN FILTER that all values are correct THERE IS SIGN STATING NOT ALL ITEMS ARE SHOWN THERE there CAN BE SOME TEXT OR SOMETHING DIFFERENT SPECIAL CHARACTERS CAN BE THERE IN DATASET Also there can be empty data
made my first data analysis project, THANKYOU SO MUCH
@RishabhMishraOfficial
6 ай бұрын
Glad it helped! Keep learning n keep growing 🚀
just start learning data analytics was doing course of excel which is now completed and i have done one project as well but for 2nd project i find u , by seeing your playlist u made me ur subscriber because ur videos will surely help in project creation of sql, tablaeu etc.
Thank You Bhaiya Most Needed Video to Get Start for Data Analyst Learning
just finished this awesome excel project😌😌 your way of explaining was quite easy and interesting. Thanks, Rishabh 👍👍
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✨️
@rahulrao2880
Жыл бұрын
how to download this sheet, it is available only for views. sir, please give me a access to edit this sheet
@sanchitkanojia5460
Жыл бұрын
Bhaiya mere excel mein kaafi feature nhi hai like combo chart etc. Kyuki older version hai. New version kaa kuch jugaad ho sakta hai??
@vg146
6 ай бұрын
i also wanted to do this project but the shared data is having only 3 months of data and in the video there is whole year data ,is you worked on 3months of data only?
Great content 👍 definitely adding this in my CV
@sushilKumar-nh4bx
Жыл бұрын
Eshank Bhai good morning. Bhai ji data analysis ke bare me aapse kuchh Jankari lena tha. So please aap apna contact no. Sand kijiye Bro
@sameerazmi3241
Жыл бұрын
Bro how can I will add this my cv it means what should I write in my cv about this project please help me??
@excel_assist
Жыл бұрын
How to add this in CV?
@arjumandshahin6074
10 ай бұрын
Yes same que
@arjumandshahin6074
10 ай бұрын
@@sameerazmi3241did u add in ur cv?
Thank you so much Rishabh. I found your channel is one of the best for all who are looking for job in data domain. I really liked all your content. You are a true gem. You don't talk unnecessary things, all content is on point and helpful.
@RishabhMishraOfficial
5 ай бұрын
Glad you liked the content n it's helpful ✅️
Dear Rishabh sir, thankyou for the video. It is a great video. Rishabh sir, I wanted to make a small request - sir , kindly conduct a session to develop a project management dashboard as well using Excel. Thanks
You deserve 1m subscribers ❤
I don't usually comment on videos but you have done amazing job. Haven't watched such a informative video till date. Thank you for the video.
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✨️ thanks ✅️
Certainly! Here's a corrected version of your sentence: "I recently found your channel. I have taken many payment courses, and trust me, you are among the top 5 of the previous tutors. All the very best, bro."
Hey, this series of yours is extremely helpful. I honestly couldn't have come across it at a better time. I just want to know one thing, for the first question, why did you take 'Amount & Order ID' and not 'Amount & Quantity'. From the question I understand that it is asking for the quantity sold so wouldn't it be better if we use quantity and not order ID. If you could explain this it'd be really helpful.
@RishabhMishraOfficial
Жыл бұрын
yes you can use quantity as well. But in this video i just wanted to check the count of orders (not sum), so it doesn't matter which column u use for calculating count. But you can also make a chart like Total Amount (sum) vs Total Quantity (sum)
@niveditabisht8426
Жыл бұрын
@@RishabhMishraOfficial Understood. Thank you!
Brother one request, please upload more SQL, python projects, and also how to apply for interview and tips, projects which are already in your channel is very helpful, great work😊
@RishabhMishraOfficial
Жыл бұрын
Noted ✅️
This was really insightful !
More appreciated 👍 More power to you 💖 Thanks for sharing this with us..
I don't speak or understand Hindi but found the video to be very helpful. This will count as my second data analytics project soon to be uploaded on Github. :)
@RishabhMishraOfficial
4 ай бұрын
Glad you liked ✅️ 👍
Ctrl +shift+l.. for filter
Sir seriously you are amazing ..your way of teachung , delivering sessions and covering every single bit of information related to the project is amazingggg...u are awesome and please make power bi projects more and more and SQL projects..I am ready to watch ur new project videos so desparetly and u are awesomeeeeee sir..u are very humble and ur nature is sooooooo diffferent....keep posting projects we are here to learn with u...god bless u
By seeing your video sir first time I made this project Alhamdulillah Same out put came as you shown in this video . Thank you very much sir.
Sir in ur link there are only 3 months like ( april,may,june) but in ur video there are all 12 months, So its only 3 month data not annual data
@RishabhMishraOfficial
Жыл бұрын
Its full data
@nurulhuda3203
Жыл бұрын
@@RishabhMishraOfficial there r only 3 months?and if I am directly downloading it from 1st link.. In date columns showing###### in all columns.. I lost my excitement 🙃
@KshitijaChilbule-qt7rw
23 күн бұрын
@@nurulhuda3203 same
@richasingh4098
22 күн бұрын
@@nurulhuda3203 just increase the size of the column and u will be able to see the whole date
@vimalsharma5051
18 күн бұрын
Thanks bro
Bhai me hi seekhne ke chakkar Me 10 baar dekh chuki hu 😂😂😂
@hi_nick_j
9 ай бұрын
Fir shikhe ki nahi
@babagin
9 ай бұрын
करत-करत अभ्यास के, जड़मति होत सुजान रसरी आवत जात ते सिल पर परत निसान
@mrinocent2436
9 ай бұрын
Mai bhi 7-8 bar dekh chuka hu abhi tk complete nhi hua🥲
@Gareeb_
8 ай бұрын
Bhaiya me 20 baar dekh chuka hu or hamesha se download hai
@arvindjha2153
8 ай бұрын
Digital marketing ka v ek practical video bana dijiye. Project k sath
Brother you have done it so smoothly, I have switching my career to Data Analytics and your videos and guides are helping me allot. Let's see coz I'm at Intermediate level of Excel, and then Power BI, SQL and lastly Python. just hope for best. Thank You for your videos.
What a great session like podcast.. Hope more videos will come on Excel in adavce method... Thanks a lot bro 👍👍🤜🤜
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it 👍
Hi sir, I want to know how I can showcase my project when it's done and what I should write in my resume.
Dear @Rishabhanmishra Your Explaination is Awesome Till Now I Had No Idea How Does This Pivot Table and V Look Up Works You Taught Me in Such a Easy Manner Since One Week I Am Following You Seriously.God Bless You.
you rocked it brother, best video , thanks.
Thank you for this video. Learning a lot from your videos.
fantastic sir, got the general idea, more help full than besic data anlyst describing videos
boht boht dhanyawad, tutorial hindi mei n short rakhne k liy....bade tutorial follow along krte krte boht time nikal jata hai n pura nhi follow krne k karan se mann bhi hatt jata tha sikhne se.
@RishabhMishraOfficial
Жыл бұрын
Glad you liked it ✨️
Thank you brother, for share a valuable video for making dash board and analysis.
Wo मां बहुत लक्की है जो आपके जैसा बेटा पाई जो अपने सभी छोटे भाइयों को आगे बढ़ाने में इतना मदद kr रहे हैं धन्यवाद Rishav भैया आपको भगवान हमेशा तरकी दे आप खूब आगे बढ़ो❤❤❤
Rishabh sir i have try this as you explain in the video thank you so much for the detail showing this.
Thanks a lot! Great video. Will surely add this in my resume !
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful! ✅️
Thank you for the wonderful job .
Wow cool data analysis.Thanks for sharing with us Rishab.Appreciate your efforts 🤩
Thank u..hepled a lot...keep making more such videos.😄😍😍
This was so helpful and amazing! Thank you for this
@RishabhMishraOfficial
8 ай бұрын
Glad it was helpful! ✅️
Thank you so much for sharing such a valuable content!! Kindly bring more such projects, Thanks once again!!!
@RishabhMishraOfficial
Жыл бұрын
More projects to come! 👍
Great explanation brother bring more such video to help beginners to learn best analysis 👍
BRO,EXCELLENT. WHAT A SIMPLE WAY TO ANALYSE A MASSIVE PROJECT IN 38 MIN
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful! ✅️
Thank you for the end to end project, made this and I tend to show this in my interviews
@RishabhMishraOfficial
7 ай бұрын
Glad you liked it ✅️
Great, thank you❤
Really amazing thank you very much really your teaching method is awesome
Bhaiya sach me bohot kadak video tha, itnaa mast clear hua h na ki puchiye mat , rating 100 me 100 👏🏻👏🏻
"THANKU SO MUCH SIR", the way you teach. it's very simple and get to easy. keep it up ❤❤❤❤❤❤❤❤❤❤
@RishabhMishraOfficial
Ай бұрын
Glad you liked ✅️
This is my first Project in my career as a beginner that helped me to understand how it works by using Excel skills, Thank U so much for your effort to learn us. I have done every step U have learned us in this amazing video and made my own analysis using the Excel file that You have attached it. You U Again ana Again and Again😍😍😍😍😍😍😍
@RishabhMishraOfficial
Жыл бұрын
Awesome 👌 Keep learning n keep growing 🚀
@ZaidAhmad-mu7si
Жыл бұрын
@@RishabhMishraOfficial how will we get cert of excel and this project we made..what we will put in resume..
Your Videos are far better than udemy and coursers courses! Great help!!
@RishabhMishraOfficial
7 күн бұрын
Glad you like them! 👍
Successfully completed this amazing video❤
My favourite channel for data analytics
Great Sir thank you soo much🥰
Thank you very much. yo explain and execute it very briefly, comprehensively and in a simple way. I love it. Thanks again
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful! ✅️
Very nicely explained. You make things understandable and interesting be it SQL,POWER BI or EXCEL
@RishabhMishraOfficial
8 ай бұрын
Glad you liked ✅️ python series is coming soon
Extremely helpful video!! Thank you so much.
@RishabhMishraOfficial
4 ай бұрын
Glad it was helpful! ✅️
Thank you Rishabh for this amazing video. Just finished with this Project and then decided to write this. You explained each point so well.
@RishabhMishraOfficial
3 ай бұрын
Glad it helped ✅️
Thank you so much!
Brilliant Video Really Helpful. Thanks A Ton
@RishabhMishraOfficial
5 ай бұрын
Glad it was helpful! ✅️
This video is really helpful specially for beginner level data analysis project experience.I saw many videos of data analysis projects and wanted to follow up but got stucked in the middle because most of them explain the things in a complicated manner .But you are really amazing ❤️ Your explanation was really simple that helped me to understand the things very clearly .Thank you so much . I'm gonna add this project on my LinkedIn profile 🎉
@RishabhMishraOfficial
5 ай бұрын
Glad it was helpful! ✅️
no words for your appreciation, please keep it up sir. we need some critical as well as advance projects in Excel.
@RishabhMishraOfficial
9 ай бұрын
Glad you liked ✅️ n noted ✅️
Thank You So much Bro for your videos and your consistency. Really It's too useful for every one to use basic excel and do some analysis. keep sharing your knowledge and teaching bro. Thank You so much for the project.
@RishabhMishraOfficial
10 ай бұрын
Glad you liked ✅️
Your Content is informative and easy to understand. Nice explanation, in a single video i have learned how to make dashboard. Thank You.
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful! ✅️
Amazing content. Explained really nicely, Thank you.
@RishabhMishraOfficial
Жыл бұрын
Glad it was helpful! ✅️
bro u are really gr8...I'm following ur roadmap for data analytics and trying to learn each and every skill from ur channel which is in the roadmap...lots of love bro💗💗
Thanks a lot, bhaiya the whole playlist was a solid insightful playlist. :) I wish you the best and looking forward to learn more from your channel.
@RishabhMishraOfficial
11 ай бұрын
Glad you liked ✅️
This is one of the best videos I have seen for Excel Projects.
@RishabhMishraOfficial
Ай бұрын
Glad you liked ✅️
Thankyou so much for this video .
Very nice content, to the point and wonderful delivery method. Keep up your good work and best of luck.
@RishabhMishraOfficial
Жыл бұрын
Glad you liked ✅️
You are such a pro and an honest guide!
@RishabhMishraOfficial
10 ай бұрын
Glad you liked it ✅️