Excel – Introduction to Pivot Tables

Date/Time: Tuesday, 28th June 2022 - 3:30 pm - 4:30 pm
Location: Online
Available Spaces: 14
Contact Details: Marc Watson: marc.watson@nhs.net

Description

Introduction to Pivot Tables and some of their basic features.

Prerequisites
A good working knowledge of Excel.

Course outline

  • Inserting a simple PivotTable
    – Single Column/Row heading
    – Values
    — Formatting value
    — Sum/Count/Average values
    – Formatting
  • More advanced PivotTable
    – Multiple row/column headings
    – Filtering
    — Pivot Table Filters
    — Slicers
  • Refreshing Pivot Table data
  • Basic PivotTable options

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.