Ken Puls

Was good for beginners, power query changed a lot since this book came out, so it was good that I knew which parts I could skip. But it was also kinda bad because there was not much in there that I didn't know (if not in detail maybe).

Don't be put off by the title, this book is full of gold. It is chock full of tips, tricks and traps.

Power Query allows you to automate data cleansing operations on all sorts of Excel data - both internal and external.

Power Query can replace copying and pasting. No need for formulas and macros to get the data right.

Well worth purchasing - it will save you hours of work.