-
Business
Microsoft Excel Dashboard
-
Attendance
Face to face, or online delivery
-
Duration
Face to face: 6 hours (1 day)
Online: 4 hours (2 x 2 hours live interactive tutorial sessions)
What's Involved
This course is suitable for those with a good working knowledge of Excel at intermediate level.
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 will cover the following:
- Designing the dashboard
- Using formulas and formatting
- Creating pivot tables and charts
- Creating slicers
- Working with data across multiple worksheets
- Recording macros to enable interactivity
- Protecting the dashboard
By the end of this course participants will have a better understanding of how to present and analyse data to help users make informed decisions.
Book
Click here to see if this course is currently scheduled, or contact us to register interest.
Enquiries
For further information please email businessgrowth@ayrshire.ac.uk
