Microsoft Excel: Learn Power Query Basics!

Focused View

Bash (BizTech Matters)

3:05:49

68 View

01 Welcome to the Power Query Course!.mp4

00:31

02 Excel Power Query - Introduction.mp4

03:04

03 Excel Power Query - Query Editor Ribbon.mp4

08:38

04 Transform Data - Trim in Excel Power Query.mp4

05:26

05 Transform Data - Format Dates and Values in Excel Power Query.mp4

02:15

06 Transform Data - Parsing URLs in Excel Power Query.mp4

05:25

07 Transform Data - Split Text Fields in Excel Power Query.mp4

09:34

08 Transform Data - Group By in Excel Power Query.mp4

02:57

09 Transform Data - Unpivoting Columns in Excel Power Query.mp4

05:19

10 Transform Data - Pivoting Columns in Excel Power Query.mp4

02:18

11 Transform Data - Split Columns into Other Columns in Excel Power Query.mp4

04:04

12 Transform Data - Filtering Rows in Excel Power Query.mp4

05:03

13 Transform Data - Sorting Columns in Excel Power Query.mp4

02:20

14 Transform Data - Transform and Add Columns in Excel Power Query.mp4

06:41

15 From Folder - Import From Folder in Excel Power Query.mp4

06:32

16 From Folder - Doing Auto Cleanup in Excel Power Query.mp4

06:56

17 From Folder - Extract Data from Forms in Excel Power Query.mp4

13:25

18 From Workbook - Extract Multiple Criteria in Excel Power Query.mp4

04:39

19 From Workbook - Extract Multiple Worksheets in Excel Power Query.mp4

04:03

20 Joins - Intro to Joins.mp4

03:31

21 Joins - Merging.mp4

07:42

22 Joins - Full Outer Join.mp4

05:43

23 Joins - Right Anti Join.mp4

08:50

24 Power Query - Convert Reports into Pivot Tables.mp4

05:03

25 Power Query - Modulo.mp4

05:45

26 Bonus Tip - Get a List of File Names.mp4

03:55

27 Bonus Tip - Get File Names Based on User Selection.mp4

12:55

28 Bonus Tip - Add Column from Examples.mp4

06:52

29 Bonus Tip - Group and Rank Items.mp4

07:28

30 Bonus Tip - Joins Data Setup.mp4

03:00

31 Bonus Tip - Full Outer Join.mp4

05:01

32 Bonus Tip - Left Outer Join.mp4

02:55

33 Bonus Tip - Right Outer Join.mp4

02:18

34 Bonus Tip - Inner Join.mp4

01:05

35 Bonus Tip - Left Anti Join.mp4

01:39

36 Bonus Tip - Right Anti Join.mp4

01:50

37 Thank You!.mp4

01:07

Bonus Tips - Exercise Files.zip.zip

Power Query Workbooks.zip

Description

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...

MORE TIME!
Create your own Power Query data transformation from scratch!
Understand the essence of the Power Query cleanups, and see them in action!
See how Power Query is used with real examples!

After this class you will be able to:

Actually SMILE when you open the Power Query Editor :-)
Brag to your friends about how you can use Microsoft Power Query confidently!

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

What You'll Learn?

Business
Data Visualization
Excel
Microsoft Excel
Business Analytics
Power BI
Power Query

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Power Query

Bash (BizTech Matters)

Instructor's Courses

Hi! I'm Bash and over here at BizTech Matters, I love sharing what I know through online classes, with my over 10 years of IT and teaching experience. Whether it's creating websites, programs, spreadsheets, editing photos, or anything computer-related, I ensure that I will give you the tools to succeed.

My goal is to show you the essence behind on whatever I'm teaching you. Hop in for a fun ride into learning in the technology world!

Join me in learning the following this growing list of skills:

- Mastering Top Microsoft Excel Formulas

- Mastering SQL Queries

- Create your own Power BI Dashboard!

- Use Excel Power Query to Clean your Dirty Data

- Use the Top 50 Excel Keyboard Shortcuts!

- Master Excel Vlookup

- How to Create Online Courses from Scratch!

- How to Convert your Skill into an Online Course

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.