엑셀 파워쿼리, 아직도 어렵다고 생각하시나요? | 초보자를 위한 파워쿼리 실전 강의

👇🏻 Download the example file used in the lecture
https://www.oppadu.com/엑셀-파워쿼리-기초-총정리/

⭐ Power Query basic summary lecture that even beginners can easily follow - Live 36 full video
https://youtu.be/LjXwrMM5Q5k

❤️ Oppadu Excel official website: https://www.oppadu.com
📚 Go to Excel Community: https://www.oppadu.com/question

#ExcelPowerQuery #PowerQueryBasics #OppaduExcel

00:00 Start of Excel Power Query lecture
00:42 What is Power Query?
01:58 What can you do with Power Query?
04:24 How can I apply Power Query in practice?
06:32 When working only in Excel without Power Query
09:01 Things you must know before using Pauquery
09:59 How to Download & Install Power Query
11:50 Power Query Practice - Looking at Invalid Data
13:30 Convert range to table
15:40 Running Power Query
19:59 Solving Cell Merge Problems with Power Query
21:05 Power Query Transform vs Column Addition Difference
21:55 Add Margin/Achievement
24:19 Print the completed query
25:25 How to modify an existing query
25:49 Automatically reflect new data
27:19 How to express profit margin as a percentage
28:10How to fix column width in table