M is for (Data) Monkey (Holy Macro! Books, 2015)

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.