Attendance / Duration
1 Day (9:00am - 4:00pm)Overview
Start Date: Wednesday 18 November 2026. 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
£185
Enquiry
For further information or to be added to our waiting list for future course dates please email engage@ayrshire.ac.ukCourse Dates
- Wednesday, 18 November 2026 (09:30 - 16:30)
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.