★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]

★ Get the example file ★

Sign up for our free Insiders program and get the example file:
[ Ссылка ]
File Reference for this video: 0212 Power Query M code tricks.zip

★ About this video ★
In this video, we look at simple, yet powerful 10 Power Query M code tricks which you can apply today!

0:00 Introduction
0:15 Tip 1: Using line feed
1:41 Tip 2: Rename column by position
2:57 Tip 3: Rename column by position in a nested table
5:09 Tip 4: Rename column based on a list in a nested table
7:00 Tip 5: Expand columns without using column names
8:28 Tip 6: Combine text in a cell with group by
10:17 Tip 7: Group by and ignore case
11:29 Tip 8: Get cell by position
13:01 Tip 9: Multi-step custom column
14:44 Tip 10: Declare column data type when adding a column
15:29 Wrap up

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]

★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]

#MsExcel

свернуть