Power Query made easy - learn the power of Quick Steps | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ About this video ★
In this video, we look at how to use a custom functions library to make Power Query easier for longer by providing ridiculously easy transformations for tricky situations.

INCLUDES:
0:00 Introduction
0:43 Example data
1:16 Power Query Quick Steps
2:50 Initial transformations
3:01 Remove null columns
3:44 Remove top rows until search value found
5:29 Flatten multiple header rows
6:37 Multiple find and replace actions in one step
7:58 Standard Power Query transformations
9:42 Update source data
10:18 Wrap-up

Get Power Query Quick Steps:
https://exceloffthegrid.com/academy

Learn about Power Query Quick Steps:
https://exceloffthegrid.com/quick-steps

★ 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