Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Query Course : For Beginner to Advanced User
Supporting Excel Files
Excel Files
Who is the Instructor?
Instructor Introduction (2:22)
The beauty of Power Query
Understanding What is Power Query. Why to learn Power Query and what is Covered in Power Query (14:28)
How to Import Data from External Data Sources into Power Query
How to Import Data from Excel File (5:55)
How to Import Data from another files and folders (6:55)
Loading and Refreshing Data
How to load and Refresh a query as per Data Modeling (7:44)
Define the multiple Transformation Steps
How to do Column Transformation in Power Query (8:59)
How to do Row Transformation in Power Query (7:21)
How to do in built transformation in Power Query
How to do Text Transformation (7:02)
How to do Numbers transformation (3:09)
How to do Date transformation (2:43)
How to do Conditional Column transformation (2:10)
How to Consolidate and Append Data
How to Append Multiple Worksheets within the same Excel file (11:33)
How to find the Relationship between Append, Duplicate/Replicate and Referencing of multiple Queries (2:49)
Learn about Importing data from files in a folder (7:29)
Learn about Importing data from multiple excel files in a folder (5:18)
How to create Dynamic List of files stored in a folder (2:27)
How to Change the file path for source data (1:58)
How to use Merge feature to combine Multiple Joins in Power Query
What are the Multiple JOINS in power query (8:19)
What are the Different Joins in Power Query (11:46)
Fundamentals of M: The Formula Language for Power Query
Learn what are the roots of M, the Formula Language/ Power Query Formula Syntax (5:11)
Learn about the Text functions in Power Query (8:00)
Learn about the Date functions in Power Query (6:53)
Learn about the Conditional Functions in Power Query (7:03)
Case Studies
Using Power Query to Convert the Financial Statement Data into a Table (7:14)
Converting the Payroll Data into a Tabular format with Power Query (6:40)
How to pull Stacked Data from the Address Book to the Excel? (6:42)
How to apply Multiple filters on single column using Merge Query Option (6:23)
How to Convert a Row data set into a Tabular Format using Power Query? (5:17)
How to get data from Multiple lookup Values using Power Query (9:40)
Invoice/Order data Modeling (Converting Pivoted Data using Unpivot Function) with Power Query (4:43)
Shape and Combine Data from Multiple Sources in Power Query. Here, Sales analysis using MaxIF, MinIF, (20:34)
Power Query Objects
List all the object and functions in Power Query and how it can be used (11:42)
How to Record as object and details about the Record functions in Power Query (9:16)
Table & other objects and Table functions in Power Query (3:10)
Quick Recap on What are the Power Query Objects (1:15)
Advanced Case Studies
Learning to Extract only relevant data in Power Query (12:43)
How to Create a dynamic Calendar table (5:57)
Mode of Calculating and finding Individual sales to total sales percentage (7:56)
How to apply Multiple filters on single column (3:34)
Bonus
What are the Conditional Functions? (4:13)
Using the Extract & Transform Column (4:58)
How to Record as object and details about the Record functions in Power Query
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock