When your colleagues see what you can do with Power Query and Power Pivot they’ll think you’re performing some kind of Excel magic! In this webinar I’m going to show you how to use Power Query to get data from multiple sources, filter and clean it, send it to Power Pivot and create relationships between data tables.
What is an Excel Dashboard and how does it differ from a report? Let’s first understand what is an Excel dashboard. An Excel dashboard is one pager (mostly, but not always necessary) that helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it.
Create impressive, interactive, & easy to read visual reports in our Excel Dashboard course. Learn in-demand skills and take your career to the next level
I have been using PowerPivot in Excel 2010. My understanding was (via PowerPivot Pro blog) that Power Pivot would NOT be available in Excel 2013 in all versions; my recollection is that it was only going to be available in certain enterprise subscription editions.