You might think this is a shameless plug for some fellow MVPs (and it is to some extent) but if you have begun to use Power Query (or ‘Get and Transform’ as some bright spark decided to call it in 2016) or are thinking about it, or if you spend a lot of time cleaning up and manipulating data in Excel, then you owe it to yourself to get this book:
M is for Data Monkey by Ken Puls and Miguel Escobar.
I have only just begun to discover how fantastic the Product Formerly Known as Power Query is and, for an Excel user rather than BI specialist, this book is absolutely invaluable since it approaches tasks that will be familiar to most of us in a way that makes sense. If you don’t already have it, it really needs to be on your shopping / Christmas list. Trust me, you won’t regret it!