Excel – Pivot Tables (Extended)

Date/Time: Wednesday, 29th June 2022 - 11:00 am - 12:00 pm
Location: Online
Available Spaces: 10
Contact Details: Marc Watson: marc.watson@nhs.net

Description

Demonstration of advanced functionality when using Pivot Tables.

Prerequisites
A good to advanced working knowledge of Excel.
Ideally, previous attendance of “Introduction to Pivot Tables” course or equivalent experience.

Course outline

  • Calculated fields
  • Grouping
    – Included
    – Manual
  • Options
    – Sorting
    – Column widths
  • Linking pivot tables
  • Using Timelines
  • Slicers

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


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.