How to Clean, Analyze and Present Data with Excel (FREE Adv. Course) @chandoo_
How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)  @chandoo_
Uploaded June 2023 | Updated November 2026, 2 days ago
You asked for it. Here is my free course on advanced data analytics.
πŸ’₯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-data-file.xlsx
Completed workbook - chandoo.org/wp/wp-content/uploads/2023/06/data-analysis-03.xlsx



⏱ 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 - youtu.be/v2oNWja7M2E
5 key skills you need to be a GREAT data analyst - youtu.be/gVr9f1GJdZc
5 Excel Skills you need to focus on - youtu.be/cEuq_9CsHIY
15 Excel functions you should know - youtu.be/B5hayFelHDU

My playlist on data analysis - youtube.com/watch?v=gVr9f1GJdZc&list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R

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 - instagram.com/chandoo.xlsx

Have a beautiful day πŸŒΌπŸŒžπŸ˜€

#DataAnalysis #Excel
How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)Excel Secrets: Shorten Long Formulas by 80%β€”A Trick Youll Love!How to calculate Compound Interest in Excel - Formula with Examples πŸ’»Unlock Hidden Insights with DAX: Create Best-in-Category Metrics Easily!How to make a Column Chart with TOTALS in Excel (perfect for data analysis)Learn SQL + Database Concepts in 20 Minutes35 Must have Excel ShortcutsExcel Data Cleaning TrickπŸ’‘for uneven rows of data #EXCELPower Query MAGIC! ⚑Auto-Categorize Text Like a PRO!Stop Dragging in Excel, there is a BETTER way!UNPIVOT: Data Cleaning Power Tricks πŸ’‘Powerful trick to get data from any folder in Excel (works even after renaming!)
Chandoo |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER