진짜 현업에서 쓰이는 직장인의 실무 엑셀 - 데이터 가공부터 분석까지
배영자
현재 엑셀의 가장 트렌디한 방법으로 데이터를 효율적, 과학적으로 가공, 분석함에 '표준'이 되는 과정입니다.
중급이상
Excel, MS-Office
BEST
Practical Excel for office workers - Power Query Advanced
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)
Reviews from Early Learners
What you will learn!
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.
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.
What is Power Query?
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!
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
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 !
Converting long data input into a table in the row direction
Create with 2 layouts
Expected Questions Q&A
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.
Created this course
Are you curious about the knowledge sharer?
Bae Young-ja
I am the CEO of Data Design Lab and work as a VBA instructor and developer.
- VBA Development and Lectures
- Data Visualization Designer
- Operates the YouTube channel 'Excel Design'
- Publication of the book 'VBA Secret Note'
Related lectures
Check it out.
Recommended for
these people
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
8,995
Learners
347
Reviews
219
Answers
4.9
Rating
6
Courses
안녕하세요, 반갑습니다.
VBA 강사 및 개발자 배영자입니다.
유튜브 '엑셀디자인' 채널 운영 중.
Curriculum
All
16 lectures ∙ (4hr 2min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
23 reviews
5.0
23 reviews
Myeong-dong LeeReviews 4
∙
Average Rating 5.0
5
100% enrolled강사님의 이전 강의에서 배운 내용을 바탕으로 파워쿼리를 실무에 잘 적용하고 있습니다. ^^ 그런데 종종 예상하지 못한 에러가 발생(열 이름 변경 등) 해서 난감했었는데, 이번 강의를 통해서 파워쿼리의 자유도를 높일 수 있게 되었습니다. 특히 매개변수 개념과 table 내 index 열을 추가하는 기능은 매우 유용한 것 같습니다. 그럼 다음 강의에서 뵙겠습니다. ^^
- 배영자Instructor
안녕하세요, 명동님 :D 광속으로 끝내셨습니다. 명동님의 대단한 집중력과 실행력, 저도 배우겠습니다. 말씀하신 내용들을 살펴보면 파워쿼리를 실무에서 상위 몇%에 해당하는 파워유저답게 적용하고 계시는군요. 더불어 저도 같이 진화하길 소망합니다. 건강하세요~ 희망 드림
- chunho.park
Reviews 1
∙
Average Rating 5.0
5
50% enrolled심화 과정도 실무와 연계하여 설명 주셔서 많이 도움이 되고 있습니다! basic 과정부터 다시 한번 들어볼 생각입니다~
- 배영자Instructor
basic 과정이 내용이 많아서 지루하실텐데...반복을 하실 계획이라고 하시니..대단하십니다. 감사합니다 (✿◡‿◡)
- fenought
Reviews 1
∙
Average Rating 5.0
5
100% enrolled파워쿼리 사용자 정의 함수나 매개변수 사용법 등은 유튜브 무료 강좌에서는 배우기 힘든 과정입니다. 평소 파워쿼리의 기본 기능만 사용했었는데 Advanced 수강 후 업무에 많은 도움이 될 거 같습니다.
- 배영자Instructor
fenought님, 감사합니다. 현업의 복잡한 데이터셋 핸들링은 파워쿼리만으로는 부족한 경우가 많습니다. vba or python, rpa 툴로 업무 전체 자동화 까지도 욕심을 내보시면 좋겠다는 생각을 해봅니다. 화이팅입니다 (∩^o^)⊃━☆
- duk-ho.kang
Reviews 3
∙
Average Rating 5.0
$59.40
엑셀디자인's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[초급] 기본 튼튼 워드 정복하기 강좌강의 썸네일](https://cdn.inflearn.com/public/courses/329990/cover/ed18b59c-c8d7-46be-979e-ebcbe140ccf0/329990.png?f=avif&w=420)
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
