Full Project in Excel with Interactive Dashboard | Excel Project | Excel Project from Start to End

In this Excel video you will learn requirement gathering, data cleaning, processing, analysis and dashboard creation in Excel. Complete data analytics project for data analyst in Excel.
This video is specially made for beginners, intermediates, freshers, college students and recent pass outs. It will help in learning new skill. This video will help in getting a good hold on tools like Excel. By practicing this tool and developing similar dashboards one can even start with freelancing on international platforms.
Developing similar end to end deploy ready projects will help freshers/ beginners understanding the work flow of a project.
📱Book a 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
📱For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
📱Follow me on Facebook - profile.php?...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
Data Download - docs.google.com/spreadsheets/...
⭐Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Data Analyst Roadmap 2.0 video - • Data Analyst Roadmap 2...
Details mentioned below-
email- [e-mail]
WhatsApp - [phone]
#exceltutorial #dataanalytics #dataanalystproject
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
Steps Covered-
1. Requirement gathering from client
2. Identify the Stakeholders of the Project
3. Data cleaning as per the requirement
4. Data Processing by adding some customized columns in data
5. Data Analysis by Pivot Tables and Excel Functions
6. Data Visualization to create charts and custom sheets to show the insights
7. Report/ Dashboard creation from start to end
00:00 Introduction
01:03 Project Intro
02:27 Requirement Gathering
04:39 Stakeholders in Project
05:50 Metadata
07:19 Data Cleaning
12:15 Data Processing
15:03 Data Analysis
21:40 Data Visualization
32:57 Dashboard Building
01:30:47 Filter Panel
01:37:05 Panel Creation
01:39:25 Data Analysis Sheet Creation'
01:42:31 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-
Tableau Dashboard-
Sales Overview Dashboard - • Tableau Dashboard from...
HR Dashboard - • Tableau Dashboard from...
Ecommerce Sales Dashboard - • Build Tableau Dashboar...
IPL Dashboard - • Tableau Dashboard | IP...
Customer Complaint Dashboard - • Tableau Dashboard | Cu...
Power BI Dashboard
HR Dashboard - • Power BI Dashboard fro...
Excel Dashboard
IPL Dashboard - • Excel Dashboard (Hindi...
Ecommerce Sales Analysis - • Dynamic Excel Dashboar...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- [e-mail]
WhatsApp - [phone]
➖➖➖➖➖➖➖➖➖➖➖➖➖
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,
Disclaimer: All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for.
Data used in the video is a demo data, modified data and does not belong to any real time industry/ company/ government etc. Data used is only for practice purpose.

[@ipnnemkhan]

A to Z . Excel dashboard learning the greatest tutorial I have ever seen

[@datatutorials1]

Thanks for your support 😊

[@pabitramohanty30]

​@@datatutorials1 l

[@aduntoridas010]

Yeah, If you're a beginner you cant even start this project. How the hell do you even open the data to excel?

[@user-pz5gs5kv8k]

Done finishing your tutorial, it was worth my time! So helpful and informative. Please make more such content!

[@TheManOfTheHourEveryHour]

I've learned more following along with this than any of the courses I've taken. Tysm!

[@elijahxavion9509]

This is my 2nd iteration in learning to create excel dashboards! Just finished it and I learned a ton! Thank you for this content brother!

[@datatutorials1]

Glad it was helpful!

[@njamrutharikka4105]

Completed Second project on Data Analysis with Excel.Thank you so much for the wonderful guidance and helping me towards the steps to reach my goal.😀

[@abhasabessolo8323]

Thank you very much. This is the best Excel dashboard I have completed. Thank you very much.

[@esthermelihanah]

Wow!! Good job. Thank you for doing this. I has increased my confidence level in building dashboard.

[@kunalkumaraiml2365]

wow what a project, learn lot of insightful things. Thank you so much.

[@kylemunsami6039]

Thank you brother. What an amazing tutorial. I learned more than I expected. Really informative, well explained and clearly delivered. God bless you. Love from South Africa.

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@maheshrathod204]

"It was truly a wonderful journey of learning. I am a working professional and can't dedicate much time to this. Your video was almost 1.4 hours long, so I finished this project within 3 days by dedicating 1 to 1.5 hours per day. Thank you so much, and I am looking forward to hearing from you."

[@nyati-rd8rk]

Thank you man, you've helped me complete my first excel project.

[@victorialatavish4266]

Thank you ! I learned so much! I'm a retired teacher who is changing careers. Your video helped me so much in understanding data analysis.

[@datatutorials1]

Glad it was helpful!

[@christopherkabwe7076]

Wow, thank you so much for this great lesson. This is a must watch on excel dashboard.

[@user-nk2le3xb8t]

Thank you for this project.i learned a lot from this

[@Mr.Potato23]

Great tutorial buddy, learned a lot from this project tutorial.

[@analytical_lab]

This is beautiful. Thank you. I just added this to my resume

[@datatutorials1]

Cool

[@habibkhanjadoon1150]

I appericiate your video. Although I am using excel from last 10 year for calculation but I learned aloat in data analytics perspective as well as accounts related few things from your video. Habib fro Pakistan for you 🎉

[@sandrambonani2564]

Fantastic stuff! Keep up the good work!

[@user-sl7uj9de2y]

Thank you so much for this tutorial, it was worth watching the whole video, being a newbee in data analysis field have learnt so many things.

[@himanshutiwari1935]

At 10:10 Data cleaning is also required in Junction control, where "Auto traffic sigl" should be replaced with "Auto traffic signal"

[@echodelta7680]

Correct

[@noluthandosibiya982]

Noticed that too@@echodelta7680

[@AmandaCV_]

It's a lot more in that column, at least 4-5 different errors

[@ezehconfidenceadaeze6189]

Thank you so much for this guided project🙂

[@user-hf8tn8to4f]

Project added to my portfolio, Thanks

[@yashsmartboy]

This is amazing dashboard, thanks for sharing this.

[@geraldineorieoma7169]

This was super helpful. Really gave me the boost I needed. Thank you sir

[@jmaxlinestandard2592]

This is really amazing. I've learnt a lot. Thanks for this

[@thegirlwhowanders6436]

I really enjoyed this video. Taught me a lot. Thank you.

[@tosinwilliams9343]

Pls make more excel projects I really do enjoy learning it and how you make it simple❤❤❤

[@deborahchepkoech8120]

Awesome presentation and so inspiring keep up the good work!!

[@priyankapatil5800]

Very informative and explained in detail. I liked the detailing and how every point was explained. Thankyou Sir. I have learned alot !!!!!

[@datatutorials1]

Glad you liked it ✨

[@RoshniMishra-zg5ot]

awesome...all details has been shown..thank you sir..

[@user-ur4un3lb3i]

it was second dashboard, nice explanation and well designed. I Completed it. Thanks for this , Love❣

[@shumettefera3258]

This is So Helpful and shows that you are knowledgeable & gifted to be a teacher!

[@datatutorials1]

Thanks for these kink words 🙂

[@Kkone.]

Thank you, Brother. I learned a lot. 🙏🏼

[@AstorSkywalker]

Thank you very much Sir. I learned a lot!

[@koushikbhowmik6759]

This is so much helpful. Thank you.

[@saurabhvadnerkar]

Very helpful tutorial thanks, man!

[@srirajmavila5234]

Bro you are doing an amazing job, this is awesome, thank you so much for sharing the great knowledge

[@shersingh1130]

Thank you Bhaiya for teaching us how to make a highly interactive Dashboard👍

[@chimabu00]

Completed !! Thank you !!

[@dyoll78]

Thank you for this presentation! It helps a lot sir.

[@pranjalsingh5765]

Amazing learning lesson thank you very much ❤❤

[@Young_Leader_Coding_Community]

simple and easy tutoriall i like its beginner friendly

[@satyamkumar1534]

Thanku so much sir ❤️🙏please keep uploading more and more projects like that so we could learn it... 🙏😃

[@olufowokemiodeyemi8608]

Indeed you’re a great teacher. Thank you very much🙏🏻

[@isiaqabdulqaudriadedayo6588]

Please, how do you access the raw data. I didn't see link to download it.

[@jitendrabhatt4964]

Thank you for tutorial, really helpful.

[@suryamanikantaponnada7583]

Thank you Anna For your wonderful explanation 👍

[@TataNaresh]

Wow cool dashboard 🤩

[@shubhamlodha7462]

I appreciate your recognition of efforts in providing assistance and guidance, Thanks !!

[@datatutorials1]

Thanks for kind words, keep supporting

[@shubhamlodha7462]

@@datatutorials1 I am having a small query,if you solved it really appricable. In Accident Data Slicer I am not getting option to select all pivottables it just shows pivote tables of KPI not others, please help me out.

[@pradipbhatta4986]

Landed into best learning platform. Just finished this project. Thank you

[@datatutorials1]

Glad it helped!

[@rehansaif7854]

Thanks so much. I learnt a lot trying to replicate this.👍

[@SithuChill]

Good Job and clear explanation, Keep it up

[@ikinursiyanto-dj7500]

thank you for shared knowledge

[@muraliiyer7850]

good learning. nice to learn more.

[@aditjain6580]

Thank you for Your Efforts

[@Salempasanga8807]

Wowwww.... Excellent....

[@bhagyashree3279]

Thank you so much sir for this useful video 👍👍👍👍

[@neelamkushwaha1703]

Thankyou So much.. it Indeed was a great session

[@ishitajaiswal4357]

Nice Excel Project

[@Tubtatoosan-tr4wz]

Thank you, this was excellent

[@bloodyred633]

The greatest excel project i've ever seen..thanks a lot for the detailed information

[@datatutorials1]

You are most welcome

[@ziddneyyy]

thank you so much, I hope every good deeds from the people u close with or even stranger woud be paid back to you, Aameen.

[@datatutorials1]

Thanks dear 😊

[@elaineshan]

Thanks for sharing. The dashboard is beautiful

[@datatutorials1]

Glad you liked it ✨

[@Karansingh-xw2ss]

What an amazing video for creating Dashboard in Ms Excel. I found it very useful and it gave me more confidence for building a Dashboard.

[@bolumekenejoan6360]

so true its same with me.

[@bolumekenejoan6360]

I finished creating exact dashboard and i must confess this was really good. I mean I learned what I didn't learn from paid course in one day and practiced for less than 5 days. Thank you so much @datatutorials

[@FelixTola-Winjobi]

Did you notice that in the Accident_Index column, many of the cells have 2.01E+12? What did you do about it?

[@shafiqurrehman8476]

@@FelixTola-Winjobi turn them into number format instead of scientific notation.

[@vivekjangle1010]

Great sir ji ..it's really helpful🤝🤲

[@Wealth2025]

this is cool, thanks lots of love from kathmandu,Nepal

[@user-oq7xp8lp1s]

Thank you so much, For such a detailed and learning dashboard

[@datatutorials1]

Glad you liked it ✨

[@shujashakir9952]

Great work!

[@technofreak-tl5zd]

Great work every beginner should watch this video

[@datatutorials1]

Thanks for the comment, keep supporting 🙂

[@ahmadouourydiallo3667]

This is great, thank you

[@eswarsai8293]

thanks for the project sir, it was very helpful

[@Shivam-ow8sd]

full of insights , knowlageble session , it took me around 4+ hrs to complete , but learnt so much . Thankyou so much for this effort

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@rajeshkumarjha7306]

Thanks a bunch bruh....With respect to Video

[@harunrhimu]

Learn by doing. At last, I finished within 2/3 hours of investing. I think at least I know something in Excel to create charts and present them in a well-organized way. Thanks a lots

[@balachandar.s8744]

how u get this dataset bro?

[@asomya87]

I totally enjoyed working on this project alongside. It took me more than 2 hours to complete, but learn't a lot. Great work!

[@datatutorials1]

Glad you enjoyed it!

[@SandeepK75551]

Love you bro for providing such an informative and detailed video. Eagerly waiting for your next video

[@datatutorials1]

Glad you liked it ✨

[@shuchijha8124]

Really helpful, Thanks 😊

[@myspace9995]

This was very enlightening. Thanks so much. I learnt a lot trying to replicate this.👍

[@datatutorials1]

Great, glad you liked ✨🙂

[@myspace9995]

@@datatutorials1 You can't imagine how much I learnt from this video alone. Now I plan to go through all your videos one after the other. Please keep them coming. Thanks, once again.

[@officialmrblaq8789]

I enjoyed every bit of this tutorial. Thank you so much man. You covered alot of important things

[@datatutorials1]

Glad you enjoyed it ✨

[@mrtharunprao]

Thank you for this complete detailed end to end Data analysis project... Thank you once again.. Please upload the complete project on healtcare and FMCG industry. Please it's a request. Thank you

[@wwpharmacist]

😃 I have learned alot . Keep the good stuff 👍

[@dsgaming8133]

Completed your tutorial thank you sir

[@oreoluwababatola8551]

Thank you!

[@sujoymondal6977]

I watched this video without skip ,your teaching method is too nice, thankyou ♥️

[@philipaniche2451]

this is fantastic

[@jjk435]

Hey I believe that right after using the formula for months and years, we must change results in value format because sometimes if we remove certain data from a row, it might end up changing the values associated with the formula

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@providentheightmotivations1067]

Bro Thank so much for your videos , they are super, well explained and above all industry standard . Keep the good work.

[@datatutorials1]

Thank you so much 🙂

[@a2arvindaroratherealfanclu8]

awesome video ple make more like this

[@shubhamtiwari4024]

I have learnt a lot through your this video. I already did a few projects earlier but this is the most thorough video of all. Thanks a lot sir.

[@knowledgejarurihai9429]

kzbin.info/www/bejne/n2irf39qeNNgnZosi=7qQRHrlrLFNNoGpf

[@linglingzhang5009]

that's awesome, thank you so much!

[@datatutorials1]

Thanks for watching

[@user-tp4pw4mx4v]

Thank you so much 🙏

[@sumardjo]

thanks sample file easy to be learn.... thanks very much

[@NguyenHien-wk3xz]

That's great, thank you, you helped me lot

[@datatutorials1]

Glad you liked it ✨

[@Skill-tube]

Thank you

[@DasBabu1]

Just oswm sir love

[@markies_gaming]

Very Informative Sir.. Beautiful Dashboard.. Thanks for this Content..I learn a lot for this.

[@datatutorials1]

So nice of you

[@Raven9960]

Thank you sir

[@Mayank_dixit]

Fantastic content 👌

[@datatutorials1]

Glad you think so!

[@nikimath91]

Soo informative Dashboard thanks for detailed explaination.

[@datatutorials1]

Glad you liked !🙂

[@navinjakkula4041]

At 1:19:00 I get some different values of the no of casualties compared to the video I check every possible way to know why it happened so even though it works good . This video made me to do more projects on data analytics keep doing