Computing

Wednesday 31st May - Book here

To be added to our waiting list for upcoming courses 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.

Please note you must have the following set up to progress with this course;

• The latest version of Windows
• Microsoftt Office 2016 or above
• Microsoft Teams
• A working webcam
• A working microphone

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.