Computing

To be added to our waiting list for future course dates please email businessgrowth@ayrshire.ac.uk

In management information systems, a dashboard is an easy to read, often single page, real-time user interface, showing a graphical presentation of the current status and historical trends of an organisation’s key performance indicators to enable instantaneous and informed decisions to be made at a glance. Excel Dashboards allow the user to slice big data sources into easy-to-understand information formats.

This course is suitable for those with a good working knowledge of Excel at intermediate to advanced level. It is not suitable for beginners to Excel.

The course is suitable for those using Microsoft Office 2016 or above.

This course will cover the following:

• Preparing the data with Power Query
• Designing the dashboard
• Building a dashboard using pivot tables and charts
• Filtering the dashboard
• Adding interactivity with macros and formulae
• Protecting the dashboard

On completion of this course participants will have a better understanding of how to present and analyse data to help users make informed decisions.