Ayrshire College homepage
Back to all courses

Microsoft Excel Dashboards - Visually Present Data

This course isn’t currently open for applications, but you can still register your interest.

  • Qualifications Other Programmes
  • SCQF Level SCQF Level 5
  • Study mode Professional Learning
  • Campus Ayr
  • Start date August 2025
More information

Attendance / Duration

1 Day (9:00am - 4:00pm)

Overview

This 1 day 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. Participants will learn how to slice big data sources into easy-to-understand information formats.

Cost

£180

Enquiry

For further information or to be added to our waiting list for future course dates please email engage@ayrshire.ac.uk

What's Involved?

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.

Course Content

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.