- Description
- Curriculum
- FAQ
- Reviews
Microsoft Excel Power Query: Master Data Cleaning and Analysis in 2 Hours
“Excel Power Query: Master Your Data in 2 Hours” is a practical and beginner-friendly course designed to help learners efficiently manage, clean, and transform data using Excel Power Query. This course introduces essential Power Query tools and techniques, including trimming, filtering, merging, splitting, pivoting, and unpivoting data. Learners will gain hands-on experience working with the Query Editor, importing data from multiple sources, and using M Language to create advanced transformations. Whether you are handling business reports, databases, or large datasets, this course provides the skills needed to simplify complex data tasks and improve workflow efficiency.
With easy-to-follow lessons and real-world examples, this course is ideal for professionals, students, analysts, and Excel users who want to save time and automate repetitive data processes. By the end of the course, learners will confidently use Power Query to clean and organize data, combine multiple datasets, create reusable functions, and generate insightful reports with Pivot Tables. “Excel Power Query: Master Your Data in 2 Hours” is the perfect course for anyone looking to boost productivity, enhance Excel skills, and master modern data transformation techniques in a short amount of time.
-
1Power Query Intro and Excel versionPreview 4 mins
-
2Power Query and Query Editor Ribbon9 mins
-
3Trim6 mins
-
4Format Dates and Values3 mins
-
5Parsing URLs6 mins
-
6Split Text Fields10 mins
-
7Group By3 mins
-
8Import From Folder7 mins
-
9Doing Auto Cleanup7 mins
-
10Extract Data from Forms14 mins
-
11Extract - Multiple Criteria5 mins
-
12Extract Multiple Worksheets5 mins
-
13Unpivoting Columns6 mins
-
14Pivoting Columns3 mins
-
15Split Columns into Other Columns5 mins
-
16Filtering Rows6 mins
-
17Sorting Columns3 mins
-
18Transform and Add Columns7 mins
-
19Intro to Joins4 mins
-
20Merging8 mins
-
21Full Outer Join6 mins
-
22Right Anti Join9 mins
-
23Convert Reports into Pivot Tables6 mins
-
24Modulo6 mins
-
25M Introduction3 mins
-
26Enabling M in Power Query3 mins
-
27Simple Expressions8 mins
-
28Simple Expressions - Nested Expressions3 mins
-
29Variables8 mins
-
30Functions7 mins
-
31Functions - Reusable Functions3 mins
-
32Functions - Invoking1 mins
-
33Passing Functions9 mins
-
34Passing Functions - keyword each3 mins
-
35Finding the list of M functions3 mins
-
36Using M Functions10 mins
