• 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

Course Search

Or

Browse all courses Advanced search
arrow icon arrow icon