Visually Present Data - The Power of Microsoft Dashboards
Attendance / Duration
1 Day (9:30am - 4:00pm) ONLINE
Cost & ITA Funding
ITA Funding has closed for 22-23 and will re-open soon. To find out more about funding please visit our ITA Page.
Book / Enquiry
Wednesday 31st May - Book here
To be added to our waiting list for upcoming courses please email email@example.com
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.
31 May 2023