Comprehensive Excel Data Analysis Tutorial in 4 Hours with Free Files
An all-in-one video covering Power Query, Tables, Formulas, Pivots, Charts, and Dashboard creation. Learn, practice, and enhance your Excel skills in just 4 hours with free downloadable files.

Chandoo
437.9K views β’ Dec 26, 2024

About this video
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
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
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
437.9K
Likes
9.6K
Duration
03:56:43
Published
Dec 26, 2024
User Reviews
4.8
(87)