| Title | Excel: pivot tables for dashboard reporting |
| Category | Digital Skills |
| Overview | Virtual and in-person sessions are available for this course. Please check when booking.
Virtual sessions will be delivered via 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.
This training is delivered on a Windows machine using the latest version of Excel from the Microsoft Office 365 suite. 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
|
| Presenter | Katherine Trafford |
| Location | ITex6 Zoom link: https://essex-university.zoom.us/j/95697950094 |
| Campus | zoom |
| Date and time | 14:00 to 16:00 Tuesday 14 May 2024 |
| Duration | 02:00 |
| Available places | 14 |
| Presenter | Katherine Trafford |
| Location | IT Lab K (4S.2.8) |
| Campus | Colchester campus |
| Date and time | 14:00 to 16:00 Thursday 27 June 2024 |
| Duration | 02:00 |
| Available places | 17 |
| Presenter | Katherine Trafford |
| Location | ITex6 Zoom link: https://essex-university.zoom.us/j/95697950094 |
| Campus | zoom |
| Date and time | 10:00 to 12:00 Tuesday 16 July 2024 |
| Duration | 02:00 |
| Available places | 19 |
| University of Essex employee | Use the link provided above to book your place via HR Organiser. |
| Partner institution | Please discuss with your point of contact at your Partner Institution in the first instance. |
| Student Union contractors; PhD students | Please contact the Organisational Development team. |