Practical Excel for office workers - Power Query Advanced

PowerQuery, the ultimate Excel analysis tool! 🔢
Challenge yourself with advanced skills that are relevant to your work.

Excel Power Query,
If you want to end it properly?

PowerQuery, a powerful data extraction tool supported by Excel! PowerQuery brings the "query" data extraction feature used in Microsoft Access to Excel. Simply put, it's a specialized data processing tool that sits somewhere between Nogada and VBA, capable of handling most data processing tasks .

Students who learned the basics of Power Query through the previous course , “Practical Excel for Real Workers - From Data Processing to Analysis,” have continued to send us requests to learn intermediate or higher-level Power Query skills.

Have you learned the basics of Power Query? Are you looking for advanced skills to use Power Query more effectively in your work? We've prepared a course for those who want to master intermediate Power Query skills . Learn advanced Power Query skills through a variety of practical examples!

Please check before taking the class!

• This course is a continuation of the course "Practical Excel for Working Professionals - From Data Processing to Analysis." Please note that you must have studied the previous course before taking this course, or have completed the previous course's prerequisite course.

Practical Excel for Office Workers -
From data processing to analysis
The ultimate in Excel data analysis!

PowerQuery Advanced Course
Key Features!

1 Intermediate processing skills through the Power Query menu

You can learn various skills necessary for data processing using the PowerQuery menu. Through six practical examples, you'll master various intermediate PowerQuery features .

Intermediate processing skills using 2 M codes

PowerQuery is a feature built with its own code called M-Code (M Language) . Let's practice with eight practical examples of M-Code to learn data processing skills.

In addition, we will look at the basic theory of M-chords so that you can use them well.

Check out more !

_{Using the Power Query menu
Converting long data input into a table in the row direction}

_{Pivot Table by writing M code
Create with 2 layouts}

_{Unpivot without error when inserting a new column}

_{M-code basic theory}

Expected Questions Q&A

Created this course
Are you curious about the knowledge sharer?

Related lectures
Check it out.

It's actually used in the field
Excel Basic for Office Workers (Click)

For new employees who stand out
Excel Training (Click)

VBA Big Picture (Click)

Data Automation (with VBA) (Click)