Power Pivot for all! Well, sort of.

Many of you will have seen the recent UserVoice update about Power Pivot, which is, of course, good news – if somewhat late, as some others have commented already.

However, that announcement seems a little misleading to me, based on what I’ve been told: it is only coming to the subscription versions of Office (i.e. Office 365) and the forthcoming Office 2019. So if you have a 2013, or non-subscription 2016, SKU which doesn’t already have Power Pivot, you’re not going to get it. It pretty much goes without saying that there will be no change for Mac Office users. Still, at least you’re no worse off!

Power Query book

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!