Completed
How Power Query Will Change the Way You Use Excel
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Excel Power Query - Get & Transform
Automatically move to the next video in the Classroom when playback concludes
- 1 How Power Query Will Change the Way You Use Excel
- 2 Convert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query)
- 3 Easily Import Data from Web to Excel (2 Practical Examples)
- 4 Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)
- 5 Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query)
- 6 Excel Dynamic Filled Map Chart with Power Query
- 7 Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)
- 8 Consolidate & Clean Multiple Excel Sheets in One Pivot Table
- 9 How to Calculate Hours Worked with Excel Power Query (& Properly Sum time)
- 10 Properly Convert PDF to Excel
- 11 How to Merge Excel Files with Different Headers in Power Query | List.Accumulate
- 12 How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data
- 13 How to Import Emails From OUTLOOK to EXCEL & why you want to do that!
- 14 Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!)
- 15 3 Ways to Switch Data in Columns to Rows in Excel (Multiple Values)