Excel – Building Dashboards

Date/Time: Wednesday, 10th November 2021 - 2:00 pm - 3:00 pm

Location: Online

Available Spaces: 9

Contact Details: Marc Watson: marc.watson@nhs.net


This is an advanced MS Excel course aimed at showing how you can build a dashboard using Pivot Tables and Charts.

Course outline:

  • What is a dashboard
  • Planning for your dashboard
    • Formatting raw data
    • What do you want from the raw data?
  • Adding columns and rows to raw data
  • Adding pivot tables & charts from raw data
  • Formatting the pivots to show what you need
  • Creating the dashboard
  • Filtering using slicers
    • Linking slicers top multiple datasets
  • Tidying up the screen for final dashboard

The session is booked for 1 hour. 45 minutes of the hour will be the presentation and the last 15 minutes is open for any questions you may have.

It is strongly recommended that you attend the session 5 minutes before the start time. This ensures that the session can start pm time and that no information is missed.

You need to be logged in in order to be able to register for this event.
Please use the login form at the top of the page.