This course aims to teach learners how to utilize Excel Power Query to simplify their work with just a few clicks. By the end of the course, students will be able to convert columns to rows in Excel using Power Query, import data from the web, combine multiple Excel files, transform text, create dynamic filled map charts, unpivot data with multiple headers, consolidate and clean multiple Excel sheets, calculate hours worked, convert PDFs to Excel, merge Excel files with different headers, import and clean accounting data, import emails from Outlook to Excel, and switch data in columns to rows in multiple ways. The course uses a hands-on teaching method, making it suitable for individuals looking to enhance their Excel skills and streamline their data manipulation processes.
Overview
Syllabus
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).
Taught by
Leila Gharani
