Reduce Steps in Power Query - Tips Only the Pros Know!
Excel Off The Grid
0:00 / 0:00
Reduce Steps in Power Query - Tips Only the Pros Know!
25 615 просмотров · 11 месяцев назад
Excel Off The Grid
72,9 тыс. подписчиков
25 615 просмотров · 11 месяцев назад
Sign up for our free Insiders program and get the example file:
Click here: https://exceloffthegrid.com/insiders/
File Reference for this video: 0278 PQ Stop Adding Unnecessary Steps.xlsx
★ Want to become an Excel ninja? Check out our training academy ★
https://exceloffthegrid.com/
★ About this video ★
In this video, we look at two methods for avoiding adding unnecessary steps when adding columns.
(1) Column transformation - This shows how to avoid the "add column shuffle" by transforming columns in their existing position.
(2) Add multiple columns at once - Shows how to add any number of columns with just 2 steps.
00:00 Introduction
00:23 Column transformation
04:11 Add multiple columns at the same time.
07:36 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: / exceloffthegrid
#MsExcel