Excel – Building Dashboards

When

January 22, 2024
10:30 am - 11:30 am
18 spaces left

Where

Online

Contact details: Paul Atwell @ paul.atwell1@nhs.net

Description

How to build a dashboard using PivotTables, PivotCharts, Slicers and Timelines.

Prerequisites
An advanced working knowledge of Excel. Ideally, previous attendance of “Introduction to PivotTables“, “PivotTables Extended“, “Introduction to Creating Charts” and “PivotCharts” courses or equivalent experience.
PLEASE NOTE: This is the 14th course in a suggested series of the 14 Excel sessions available.

Course outline

  • What is a dashboard?
  • Planning for your dashboard
    • Formatting the raw data
    • What do you want from the raw data?
  • Creating the dashboard
  • Filtering the data
    • Using a Slicer
    • Using a Timeline
    • Linking to multiple PivotTables
  • Tidying the screen for the final dashboard
  • Ensuring dashboard is up-to-date

The session will take between 45-55 minutes to complete and is followed by a Q & A which is optional to attend.

Either the booking cut off time has passed, or you are unable to book a place on this event due to security restrictions, please contact NECSU.learning@nhs.net if you believe this to be incorrect.