How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)
358,041
Published 2023-06-13
š„Want more... get my Excel School program š chandoo.org/wp/excel-school-program/
In this comprehensive video, learn:
1) How to approach a data analysis project
2) How to systematically clean data
3) Doing EDA with Excel formulas & tables
4) How to use Power Query to combine two datasets
5) Statistical Analysis of data
6) Using formulas like COUNTIFS, SUMIFS, XLOOKUP
7) Making an information finder with your data
8) Male vs. Female Analysis with Pivot tables
9) Calculating Bonus based on business rules
10) Visual analytics of data with 4 topics
11) Analysing the salary spread (Histograms & Box plots)
12) Relationship between Salary & Rating
13) Staff growth over time - trend analysis
14) Regional Scorecard to compare NZ with India
You will also learn below Excel features:
1) Using Tables
2) Working with Power Query
3) Formulas
4) Pivot Tables
5) Conditional formatting
6) Charts
7) Data Validation
8) Keyboard Shortcuts & tricks
9) Dashboard Design
š„š Sample files:
================
Blank data file (perfect for following along) - chandoo.org/wp/wp-content/uploads/2023/06/blank-daā¦
Completed workbook - chandoo.org/wp/wp-content/uploads/2023/06/data-anaā¦
ā± Video Timestamps:
==================
0:00 - Introduction & Topic Coverage
1:50 - Data Cleaning with Excel
6:17 - Ad-hoc Analysis of Data
10:23 - Using Power Query to combine & clean data in one go
21:25 - 5 Business Questions for Data Analysis
23:12 - Quick Analysis of Data - Summaries & Statistics
31:17 - Building an information finder using Lookup Formulas
36:59 - Information Finder v2.0
41:43 - Male vs. Female Comparison with Pivots
48:15 - Calculating Bonus based on Business Rules
51:03 - 4 Data Visualization Themes
52:46 - Understanding the salary spread with histograms & box plots
59:50 - Salary vs. Employee Rating Correlation
1:08:50 - Employee Trend over time
1:19:19 - Creating a Report Card to compare NZ vs. India
What to watch next?
=================
I recommend setting aside sometime to practice what you just learned. But if you are in the mood to watch more, I suggest these videos:
Beginner to PRO Data Analysis Excel Course - Ā Ā Ā ā¢Ā BeginnerĀ toĀ ProĀ FREEĀ ExcelĀ DataĀ Analy...Ā Ā
5 key skills you need to be a GREAT data analyst - Ā Ā Ā ā¢Ā 5Ā keyĀ skillsĀ youĀ needĀ toĀ becomeĀ aĀ GRE...Ā Ā
5 Excel Skills you need to focus on - Ā Ā Ā ā¢Ā TopĀ 5Ā ExcelĀ skillsĀ youĀ shouldĀ focusĀ o...Ā Ā
15 Excel functions you should know - Ā Ā Ā ā¢Ā TheseĀ areĀ theĀ ONLYĀ 15Ā functionsĀ youĀ n...Ā Ā
My playlist on data analysis - Ā Ā Ā ā¢Ā 5Ā keyĀ skillsĀ youĀ needĀ toĀ becomeĀ aĀ GRE...Ā Ā
Want to learn more? Join my Excel School š
=====================================
If you want more step-by-step education & resources to be AWESOME at your work, consider joining my Excel School program. This online class will teach you everything you need for data analysis + reporting roles.
Visit chandoo.org/wp/excel-school-program/ to sign up today.
My Recommended Excel Books šš:
===============================
chandoo.org/wp/best-excel-power-bi-books/
š SAY HELLO š
===============
Apart from YouTube, I frequently post on,
my blog - chandoo.org/wp/
twitter - twitter.com/r1c1/
Instagram - www.instagram.com/chandoo.xlsx
Have a beautiful day š¼šš
#DataAnalysis #Excel
All Comments (21)
-
One of the best tutorials by far because you took several steps further from simple lookup formulas and other type av what I call "typical" tutorials that you can find in most channels. Extremely insightful and useful since it can be used in a lot of business situations when you work in this type of environments. A big thank you from Sweden!
-
Chandoo, bless you and your family. This is an incredible tutorial, I can't thank you enough. Aiming to transition from Carpentry into Data Analysis shortly and you've helped me immensely.
-
Thank you so much, brother. The thing I like about you is that you teach from the basics and share your different perspectives while analysing. May you get your reward in double for the amount of effort you put into this video.
-
Thank you so much Chandoo - ppl may not realize the effort & time it goes into understanding the data then, making a script and then recording video. You're doing noble work for beginner DA!
-
Thanks Chandoo - I've watched many of your shorter videos and find them very helpful and enjoy the entertaining style so I am trying to this longer version one!
-
It's the best video I've ever had in Excel so far. The best part is it went through the whole process. I learnt so much! Thanks a million!
-
Count number of >90k$ staffs: =COUNTIFS(Employee[Salary],">90000"), and the ratio is number of >90k$ staffs/ count of staffs ~= 34%
-
Awesome tutorial. Thank you so much for being clear and detailed in what you are doing (the steps) and telling us different ways we can analyze the data.
-
Thank you so much! I really appreciate that you went through the whole project and explained so clearly as it progressed. Your teaching method is great!
-
Thank you so much, Chandoo! I really appreciated this more in-depth example of cleaning, analyzing and presenting.
-
This is one of the best data analysis tutorials I hv watched step by step so easy to understand
-
Hey, What a great video made by you... We actually need these kinds of videos to help us out. Thank you so much ā¤
-
Thank you chandoo in this video the every part is explained so clearly. Please make such videos more whenever you are available. Once again thank you for your content. Keep it as alwaysš
-
I loved this video. As i am learning to be in the field of data analyst i have already gone through all your videos but this is the best and most helpful as it gives the idea of working in a data set in real life rather than other videos which is more specific in certain topic Please make this kind of videos which is summary of all the topicsā¤
-
You're my idol chandoo, I have learned a lot from your videos. Thank you. Please keep uploading more videos like this.
-
Awesome and clear explanation. Really enjoyed it . Thanks for making it.
-
Thank you Chandoo sir. This course is excellent.!! Very concise and organized!!
-
You're always an expert on it. Just thank you for the knowledge share.
-
After introduction to the topics i realized that this is the most wanted video by me.
-
This is so insightful. I took my time to go through every step. Thank you so much
