• Business

    Microsoft Excel Dashboard

  • Attendance/Duration

    Delivery Method: Face to Face delivery

    Course Duration: 6 hours (1 day)

    Delivery Method: Online Delivery

    Course Duration: 4 hours total. 2 x 2 hours live interactive tutorial sessions

  • Cost

    For further information on course dates and prices please email businessgrowth@ayrshire.ac.uk

Whats 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.

Funding and Fees

For further information please email businessgrowth@ayrshire.ac.uk

Enquiries

For further information please email businessgrowth@ayrshire.ac.uk

Course Search

Or

Browse all courses Advanced search