Full Project in Excel | Excel Tutorials for Beginners

In this video we walk through the data cleaning process and dashboard creation in Excel.

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
Instagram: @Alex_The_Analyst
____________________________________________

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

[ranitaghosh]

I don't know how to thank you Alex! For you and your videos, I got my first job today as a Data Analyst. Thank you so much. May God bless you♥️

[atvnbi]

I like how Alex run into problems and walk you through how to solve them. Just as it's done in real life.

[kazeemibrahim]

Your video just taught me how to make my first dashboard. It's amazing how you show the world that everybody is a learner and nobody is just perfect. That is humility in it's purest form. THANK YOU SIR.

[eemartin]

Thank you Alex for the knowledge you are imparting to us. I can listen to you forever. We appreciate you. I used this formula formula to create the age bracket which was much simpler so anyone interested should try it;
=IF(L2<31, "Youth", IF(L2<54, "Adult", "Old"))
OR
IFS(L2<31, "Youth", L2<54, "Adult", L2>=54, "Old")

Note: I just replaced Adolescent and Middle age with Youth and Adult respectively.

With the 10+ Miles issue this is how I handled it; 1. Right-click on 10+ Miles. 2. Click on Move . 3. Select to move to End in this case.

[aliceemma]

Thank you so much for creating these fascinating tutorial videos!
I was just thinking of building a project to showcase my excel skill, and your video just showed up right away!
Have been following this channel for a while, and this is the most informative and supportive channel I've ever seen!
Thank you so much, Alex!

[mj-fmbp]

Timestamps ✅
02:03 Setting up and Cleaning Data
14:00 Making Pivot Tables
29:10 Creating a Dashboard
35:20 Adding Filter Buttons
39:34 Outro

[Aakanksha]

I just completed the entire excel series. It was the first time ever that I created an entire dashboard myself. I feel really good. And as a beginner in the field, the basic steps to learn about cleaning the data and why that step in the cleaning process is being performed played an important role in understanding its importance. Thanks, Alex!

[obinnanwaneri]

Man, your channel is beyond amazing. Thank you for all you're doing for the community. It's really priceless.

[agarwalvishal]

Thank you for the project. I have been looking for such videos lately. Marriedarrtial Singlestatus sounds like a Harry Potter spell.

[benandrew]

Thanks, Alex, for putting all of this content out there; it really helps in improving my skills as an entry-level data analyst. I was able to move the 10+ miles to the bottom without having to edit it to "more than 10 miles" by right-clicking on it and using the move option.

[JennyHartzog-ycem]

I can't even begin to thank you, I finally feel like I can actually navigate Excel. I binged the whole series and just finished the project. I'm now excited to try out my new skills. You are the best!

[PhiGonz]

Something very cool to know when your making dashboards is that if you press "Alt" while your dragging your they will align automatically. This helps a lot to make a cleaner dashboard

[polokomonama]

I just completed the excel series in less than 24hrs leisurely! I have to say as someone who was intimidated by excel for some time, you have not only managed to help me understand it, but somehow made it enjoyable. For anyone who sees this I suggest you go through the entire excel series, believe me it is worth it! Thank you so much Alex for your time and effort!

[xhiah]

I've been doing all i can to self study comp sci and data analytics so i get my first job and fund school and turn my life in a new direction. I quit my job so i can get real time to invest in these aspirations. I'll have a job before October. Thank you for doing all this, education should be free for all and i wish great blessing to you and your family thank you so much for giving to so many what the system refuses to make readily available. When i get the job i will be back here again. A great day to you Alex :)

[munamackenzie]

It felt so great achieving the project and having this complete beautiful dashboard! I thought Pivot Tables, Dashboards and other Excel features were hard which made it intimidating for me to learn Excel, but after finishing your tutorials turned out things are actually easy and simple! Thank you Alex for your time and hard work!

[kelvinkhiew]

Hi Alex!

BIG SHOUTOUT to you for coming up with all these AMAZING REALISTIC videos.
Currently looking for Data Analyst job, and just dropping by your latest video to say THANK YOU!

[ghostofjudah]

Thank you so much for this whole series. You helped me refine my basic skills and create my first dashboard. Amazing work man. Please keep it up!

[AxelYates]

Love the quality of your videos Alex. Thank you so much for everything you do, I know it's not easy.

[becRAHULTHAKUR]

Hey Alex, i just love the way you trying different things to resolve a query and you also shows this in a tutorial so that we can get comfortable with the tutorial

[AkramEl-Araby-wbpt]

I just finished the whole Excel Tutorials for Data Analyists playlist, and it's absolutely fantastic! Really helpful and added a lot to me.

Thanks Alex for the simple yet awesome way of delivering the message!