How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)

You asked for it. Here is my free course on advanced data analytics.
💥Want more... get my Excel School program 👉 https://chandoo.org/wp/excel-school-p...


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) - https://chandoo.org/wp/wp-content/upl...
Completed workbook - https://chandoo.org/wp/wp-content/upl...



⏱ 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 https://chandoo.org/wp/excel-school-p... to sign up today.


My Recommended Excel Books 📚👌:
===============================
https://chandoo.org/wp/best-excel-pow...

😎 SAY HELLO 👋
===============

Apart from YouTube, I frequently post on,
my blog - https://chandoo.org/wp/
twitter -   / r1c1  
Instagram -   / chandoo.xlsx  

Have a beautiful day 🌼🌞😀

#DataAnalysis #Excel