Students Staff

Learning activity

Description
TitleExcel: pivot tables
CategoryDigital Skills
OverviewIMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. PREPARATION FOR THE TRAINING The Zoom link is: https://essex-university.zoom.us/j/96925927663 This training is delivered using Excel 2016. Participants wanting to follow along, should make sure they have the software installed before the session starts. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE PivotTables allow you to calculate, summarise, sort, and format your data quickly and easily to see comparisons, patterns and trends. In this session you’ll create and manipulate a variety of PivotTables to answer questions of your data, and finally produce some PivotCharts to create dashboards to visualise your data. - Creating a PivotTable - Configuring a PivotTable - Pivoting a PivotTable - Sorting/filtering data - Changing the data field summary - Creating and manipulating Pivot charts For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.
Learning outcomes
  • Learn how to create a PivotTable
  • Discover how you can visualise your data using Pivot charts
  • Understand how you can manipulate data in a PivotTable
Schedule
Book Event 1
PresenterSally Swaine
LocationITex6 Task Booklet: https://bit.ly/IT-ex6-tasks
Campuszoom
Date and time10:00 to 12:00 Wednesday 9 June 2021
Duration02:00
Available places15
Book Event 2
PresenterSally Swaine
LocationITex6 Task Booklet: https://bit.ly/IT-ex6-tasks
Campuszoom
Date and time12:30 to 14:30 Thursday 8 July 2021
Duration02:00
Available places19
Book Event 3
Presenter
LocationITex6 Zoom link: https://essex-university.zoom.us/j/96925927663
Campuszoom
Date and time10:00 to 12:00 Wednesday 11 August 2021
Duration02:00
Available places19
Book Event 4
PresenterSally Swaine
LocationITex6 Task Booklet: https://bit.ly/IT-ex6-tasks
Campuszoom
Date and time10:00 to 12:00 Wednesday 8 September 2021
Duration02:00
Available places20
Book Event 5
PresenterSally Swaine
LocationITex6 Task Booklet: https://bit.ly/IT-ex6-tasks
Campuszoom
Date and time10:00 to 12:00 Wednesday 13 October 2021
Duration02:00
Available places20
Book Event 6
PresenterSally Swaine
LocationITex6 Zoom link: https://essex-university.zoom.us/j/96925927663
Campuszoom
Date and time10:00 to 12:00 Wednesday 10 November 2021
Duration02:00
Available places20
Book Event 7
PresenterSally Swaine
LocationITex6 Zoom link: https://essex-university.zoom.us/j/96925927663
Campuszoom
Date and time10:00 to 12:00 Wednesday 8 December 2021
Duration02:00
Available places20
Booking instructions
University of Essex employeeUse the link provided above to book your place via HR Organiser.
Partner institutionPlease discuss with your point of contact at your Partner Institution in the first instance.
Student Union contractors; PhD studentsPlease contact the Organisational Development team.