Excel Power Query - Get & Transform
Offered By: YouTube
Course Description
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
Related Courses
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera