You can learn advanced Excel Power Query skills that help you process data efficiently and scientifically, and apply them in practice. (Power Query menu and M code, Advanced Course)
You can learn intermediate processing skills by utilizing Power Query's menu in various ways.
You can learn the basic theory of M Language.
You can learn various processing skills using M code.
PowerQuery, the ultimate Excel analysis tool! 🔢
Challenge yourself with advanced skills that are relevant to your work.
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!
Practical Excel for Office Workers -
From data processing to analysis
The ultimate in Excel data analysis!
The “Power Query Advanced” course
It consists of two parts.
1) Intermediate processing skills through the Power Query menu
2) Intermediate processing skills using M code
You can learn various skills necessary for data processing using the PowerQuery menu. Through six practical examples, you'll master various intermediate PowerQuery features .
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.
Q. Do I have to take the previous Power Query Basic course beforehand?
Let me ask you a question.
First, can you give me at least two reasons why I should use PowerQuery instead of Excel functions and features?
Second, can you freely apply the file integration, sheet integration, and merge functions using PowerQuery to your work?
Third, did you know that when you load a query table into a worksheet, there is an option called 'Create Connection Only'?
If you can answer all three questions above, you can proceed directly to this course without any prior learning.
Q. How is this course different from the Power Query Basic course ?
First, this course covers M-Code (M Language).
Secondly, while the Basic course only covers simple example samples to learn basic concepts, this Advanced course covers example samples organized in a table format similar to actual practice.
Q. To learn M Code (M Language), do I need to learn the grammar like I would a programming language?
To be clear, I don't think that's necessary. If that were the case, Microsoft would have commercialized M-code as an independent programming language.
PowerQuery internally converts our input into M-code when the user clicks a menu and processes it. Since you can view this converted code in the Advanced Editor or Formula Bar, detailed processing can be done directly by making minor modifications to the already generated code. This lecture will teach you how to do this.
I am the CEO of Data Design Lab and work as a VBA instructor and developer.
Who is this course right for?
For those looking for a course beyond the basics of Power Query
Those who want to learn various practical skills and know-how of Power Query
Need to know before starting?
Power Query Basics
9,098
Learners
353
Reviews
223
Answers
4.9
Rating
6
Courses
안녕하세요, 반갑습니다.
VBA 강사 및 개발자 배영자입니다.
유튜브 '엑셀디자인' 채널 운영 중.
All
16 lectures ∙ (4hr 2min)
Course Materials:
All
24 reviews
5.0
24 reviews
Reviews 4
∙
Average Rating 5.0
5
Based on what I learned in the instructor's previous lecture, I am applying Power Query well to my work. ^^ However, I was often embarrassed because unexpected errors occurred (such as changing column names), but through this lecture, I was able to increase the freedom of Power Query. In particular, the concept of parameters and the function of adding index columns in a table seem very useful. See you in the next lecture. ^^
Hello, Myeongdong-nim :D You finished it at the speed of light. Myeongdong-nim's great concentration and execution, I will learn from you too. Looking at what you said, You seem to be applying Power Query in the top few percent of power users in your field. I also hope that we can evolve together. Stay healthy~ Hope
Reviews 3
∙
Average Rating 5.0
5
I am taking this course after the basic course. It is really helpful in practice! I would like to see a Power Pivot course after the Power Query course.
Thank you, Byung-woong o(*^▽^*)┛ You are moving strongly from the beginning of the new year. Fighting!
Reviews 1
∙
Average Rating 5.0
5
The advanced course is also very helpful because it explains things in connection with practical work! I plan to listen to the basic course again~
The basic course has a lot of content, so it might be boring... But since you plan to repeat it, you're amazing. Thank you (✿◡‿◡)
Reviews 1
∙
Average Rating 5.0
5
It is difficult to learn how to use Power Query user-defined functions or parameters in free YouTube lectures. I used to only use the basic functions of Power Query, but I think it will be very helpful for my work after taking the Advanced course.
Thank you, fenought. In the field, handling complex data sets is often insufficient with Power Query alone. I think it would be good to try to automate the entire work with vba or python, or rpa tools. Fighting (∩^o^)⊃━☆
Reviews 3
∙
Average Rating 5.0
5
I think it was good to be able to increase understanding of the functions of using M code.
Oh~ You took many classes. Thank you (✿◡‿◡)
$59.40
Check out other courses by the instructor!
Explore other courses in the same field!
![[Pass ITQ Excel A in One Go] in 3 days강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
