I have been getting a number of enquiries about Dashboards in Excel 2013, I knew how to create charts and pivot charts but not quite what the customer was after. So recently I went on a Microsoft Power BI course delivered by Burningsuit. It was a great 2 days and learnt quite a bit. Well see for yourself as to what I now know and will be soon be able to help others.
Below you will find a Dashboard created with a link to an Excel 2013 file based on KITT Consultancy’s Training services for the last 2 financial years.
You can click on any of items, such as a dot on the map, a column bar, or filter by year. By doing anyone of these you will the display change according to the filter.
If you would like a better visual then click on the double arrows above on the bottom right.