When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel: Learn Power Query Basics!
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
This Course Includes
skillshare
0 (0 reviews )
3 hours 5 minutes 
english
Online - Self Paced
course
SkillShare
About Microsoft Excel: Learn Power Query Basics!
Welcome to the Power Query Course!
Excel Power Query - Introduction
Excel Power Query - Query Editor Ribbon
Transform Data - Trim in Excel Power Query
Transform Data - Format Dates and Values in Excel Power Query
Transform Data - Parsing URLs in Excel Power Query
Transform Data - Split Text Fields in Excel Power Query
Transform Data - Group By in Excel Power Query
Transform Data - Unpivoting Columns in Excel Power Query
Transform Data - Pivoting Columns in Excel Power Query
Transform Data - Split Columns into Other Columns in Excel Power Query
Transform Data - Filtering Rows in Excel Power Query
Transform Data - Sorting Columns in Excel Power Query
Transform Data - Transform and Add Columns in Excel Power Query
From Folder - Import From Folder in Excel Power Query
From Folder - Doing Auto Cleanup in Excel Power Query
From Folder - Extract Data from Forms in Excel Power Query
From Workbook - Extract Multiple Criteria in Excel Power Query
From Workbook - Extract Multiple Worksheets in Excel Power Query
Joins - Intro to Joins
Joins - Merging
Joins - Full Outer Join
Joins - Right Anti Join
Power Query - Convert Reports into Pivot Tables
Power Query - Modulo
Bonus Tip - Get a List of File Names
Bonus Tip - Get File Names Based on User Selection
Bonus Tip - Add Column from Examples
Bonus Tip - Group and Rank Items
Bonus Tip - Joins Data Setup
Bonus Tip - Full Outer Join
Bonus Tip - Left Outer Join
Bonus Tip - Right Outer Join
Bonus Tip - Inner Join
Bonus Tip - Left Anti Join
Bonus Tip - Right Anti Join
Thank you and Congratulations!
What You Will Learn?
- Last time you opened a Power Query file and are overwhelmed by the number of things to do. You don't know how to make the best use of your time..
- But it doesn't have to be this way!.
- You Will Walk Away With....
- After this class you will be able to:.
- If you're like me, you use Microsoft Power Query on a daily basis for important tasks, text processing, or reports. Whether it's for business or personal related projects, everyone wants to be able to use Power Query freely and easily..
- We take it up a notch to clean your dirty data and showcase the things you can do in Excel Power Query!.
- Introduction- Excel Power Query Editor Ribbon.
- Transform Data - Trim in Excel Power Query- Format Dates and Values in Excel Power Query- Parsing URLs in Excel Power Query- Split Text Fields in Excel Power Query- Group By in Excel Power Query- Unpivoting Columns- Pivoting Columns- Split Columns into Other Columns- Filtering Rows and adding a "Year" Column- Sorting Data- Transform vs Add Columns.
- From Folder - Import From Folder in Excel Power Query- Doing Auto Cleanup in Excel Power Query- Extract Data from Forms in Excel Power Query.
- From Workbook - Extract Multiple Criteria in Excel Power Query- Extract Multiple Worksheets in Excel Power Query.
- Joins- Intro to Joins- Merging- Full Outer Join- Right Anti Join.
- Tips and Tricks.
- - Convert Reports into Pivot Tables- Modulo.