Comprehensive Excel Data Analysis Tutorial in 4 Hours with Free Files

Power Query → Tables → Formulas → Pivots → Charts → Dashboard
All in one video. Learn everything, practice the concepts and improve your skills in just 4 hours. This is my holiday gift for you 🎁

📁 Download the files: https://chandoo.org/wp/complete-excel-course-free/

Topics covered in this video:

Power Query
Web scraping
Data cleaning & automation
Adding columns
How to use Excel
Conditional formatting
Quick analysis of data
Autosum
Excel Tables
Excel functions & formulas
COUNTIFS, SUMIFS, AVERAGEIFS
XLOOKUP
FILTER
INDEX
CHOOSECOLS
IFERROR
SMALL, LARGE
SORT, UNIQUE
Statistical analysis of data
Excel pivots
Slicers, timelines
Interactive pivots
Interactive charts
Pivot charts
Pivots + conditional formatting
Excel charts
Excel data model (power pivot)
DAX in Excel
Creating a dashboard in Excel
Chart customization
Using pictures in Excel
Dynamic dashboards
+ hundreds of tips, tricks, shortcuts and ideas 💡

🚀 Learning Progression:

0 - 15 mins: How to use Excel
15 - 48 mins: Power Query and Data Management
49 - 1 hour 50 mins: Excel formulas & functions
1h 50 - 2h 40 mins: Excel Pivot Tables, Slicers & Charts
2h 40 - 4h: Excel portfolio project


🕐 Detailed Timestamps:

00:00 - How to use Excel
14:36 - Power Query and Data Management
49:27 - Excel formulas & functions
1:53:39 - Excel Pivot Tables, Slicers & Charts
2:42:47 - Excel portfolio project


Enjoy the video and download all the workbooks and additional resources here - https://chandoo.org/wp/complete-excel-course-free/

#Chandoo #excel