★ 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 ★ 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