Microsoft Excel Dashboard
Face to face, or online delivery
Face to face: 6 hours (1 day)
Online: 4 hours (2 x 2 hours live interactive tutorial sessions)
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.
For further information please email firstname.lastname@example.org