10 Power Query tips EVERY user should know! | 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 10 Power Query tips that every user should know.

How many did you know? Let me know in the comments.

0:00 Introduction
0:21 Tip 1 Default load settings
1:09 Tip 2 Close & Load greyed out
1:50 Tip 3 Rounding errors (?)
2:39 Tip 4 Edit auto generated column names
3:06 Tip 5 Disable auto Changed Type steps
3:54 Tip 6 Adding documentation
4:43 Tip 7 Phantom errors
5:08 Tip 8 Connect to folders efficiently
5:49 Tip 9 Avoid the double refresh
6:25 Tip 10 Reusing queries
6:57 How did you do?


★ 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