Excel Power Query - Get & Transform

Explore the powerful capabilities of Excel Power Query in this comprehensive 2.5-hour tutorial. Learn to streamline your workflow by converting columns to rows without formulas, importing data from the web, combining multiple Excel files, and transforming text effortlessly. Master techniques for creating dynamic filled map charts, unpivoting data with multiple headers, and consolidating sheets into a single pivot table. Discover how to calculate work hours, convert PDFs to Excel, merge files with different headers, and import messy accounting data. Gain insights on importing Outlook emails to Excel and utilizing custom data types. By the end of this tutorial, you'll be equipped with essential Power Query skills to simplify complex data tasks and enhance your Excel proficiency.

How Power Query Will Change the Way You Use Excel.
Convert Columns to Rows in Excel (NO Transpose, NO Formulas - SIMPLY UNPIVOT in Power Query).
Easily Import Data from Web to Excel (2 Practical Examples).
Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder).
Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query).
Excel Dynamic Filled Map Chart with Power Query.
Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query).
Consolidate & Clean Multiple Excel Sheets in One Pivot Table.
How to Calculate Hours Worked with Excel Power Query (& Properly Sum time).
Properly Convert PDF to Excel.
How to Merge Excel Files with Different Headers in Power Query | List.Accumulate.
How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data.
How to Import Emails From OUTLOOK to EXCEL & why you want to do that!.
Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!).
3 Ways to Switch Data in Columns to Rows in Excel (Multiple Values).