A compilation of tricks for MS Excel's PowerQuery add in. See time links below
Includes:
Being able to work in Excel or see a different PowerQuery while working in the PowerQuery screen, making it easier to copy and paste code between PowerQueries or look at Excel while building a PowerQuery 00:00
Easy fix for promoting headers when you know that the column name can change and you don't want to have to edit the PowerQuery every time 02:01
Why 'Begins With, Ends With, Contains' are missing as a filter selection option and how to get them back 04:06
Possible reasons that you receive the Overflow error in PowerQuery even though you know your data should not cause an overflow 05:05