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