Excel & Power BI Data Analysis Complete Class in One Video - 365 MECS 04

Download Excel Zipped Folder with all files: Course taught by Excel MVP and Highline College Professor, Mike Girvin. Topics in video: 1. (00:00) Introduction 2. (03:52) What is Data Analysis? 3. (04:37) Sorting and Filtering. Example 1 & 2 4. (13:24) FlashFill. Example 3. 5. (15:58) Standard PivotTable with Summarize Values By and Show Values As calculations. Example 4. 6. (20:25) Power Query to import, clean, transform and refresh data and load to Excel Worksheet. Complete Introduction to Power Query. Example 5. 7. (34:07) First look at Power Query’s Functional Language: M Code 8. (55:05) Power Query to Import and combine 12 tables into one table and load directly to a PivotTable Report & Excel Chart Visualization. Example 6. 9. (01:10:18) Excel Line Chart Visualization based on PivotTable 10. (01:14:04) Data Modeling for Examples 7, 8 & 9 11. (01:17:51) XLOOKUP function, PivotTable and Excel Charts to bu