MENU

Fun & Interesting

10 Power Query tips EVERY user should know! | Excel Off The Grid

Excel Off The Grid 45,426 7 months ago
Video Not Working? Fix It Now

★ 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: https://twitter.com/exceloffthegrid #MsExcel

Comment