Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files) скачать в хорошем качестве

Complete Excel Tutorial for Data Analysis 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... 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... #Chandoo #excel