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.

Leave Comment

Your email address will not be published. Required fields are marked *

clear formSubmit