๐๐ป Download the example file used in the lecture
www.oppadu.com/์์
-ํ์์ฟผ๋ฆฌ-๊ธฐ์ด-์ด์ ๋ฆฌ/
โญ Power Query basic summary lecture that even beginners can easily follow - Live 36 full video
โข ์์
LIVE 36ํ - ํ์์ฟผ๋ฆฌ ๊ธฐ์ด ...
โค๏ธ Oppadu Excel official website: www.oppadu.com
๐ Go to Excel Community: 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
4 ะฐะฒะณ 2024