10 awesome Power Query tricks you NEED to know! | Excel Off The Grid

10 awesome Power Query tricks you NEED to know! | Excel Off The Grid

69.605 Lượt nghe
10 awesome Power Query tricks you NEED to know! | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ 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 ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel