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

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk