Microsoft has released Power BI desktop edition for FREE.
Power BI allows you to create reports and dashboards from lots of different sources.
It is not an add-in to Excel, it is a standalone application.
You can download it at the link below.
Click the here to go to the Microsoft site to Download Power Bi Desktop
It is a straight forward process to install.
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.
This website is a great resource for the DAX formula language used in PowerPivots in Excel 2010 and Excel 2013. The site contains solutions to common reporting requirements in PowerPivot Reports They have also published a book based on the content which is cheap as a Kindle edition, I have recently bought it.
27 Excel experts discuss Excel and its future with Business Intelligence.
Some great insights – worth a read.