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:
Added soon.
Enjoy the video and download all the workbooks and additional resources here - https://chandoo.org/wp/complete-excel-course-free/
#Chandoo #excel