Provider web pages

 

UCL Learning Portfolio

 

DSD: Pivot Tables in Excel - Workshop (ISPTEW) 
Course Description:

Pivot tables can be used to analyse, summarize and present large amounts of data. Once a Pivot Table has been created it can be reorganized in various ways using features such as filtering, sorting, changing functions or displaying as a Pivot Chart.

In this introductory workshop you will create several pivot tables and experiment with many useful features using several data lists provided.

Once you have booked on the course you will be able to access all of the online materials in our Digital Skills Development Moodle course.

IMPORTANT: Please ensure you are using Desktop@UCL or the UCL VPN when booking because you need to be on the UCL network to use the system.

Once you have enrolled, you will need to click on the play button under 'My current enrolments' in My Learning to join at the time of the live session. You will also receive an email from ISD containing the direct joining link a day before the session. Please check your junk folder as these emails are occasionally tagged as spam.

We would encourage those who are new to Blackboard Collaborate/Microsoft Teams to join 15 minutes early in order to test out their connection/audio and help will be offered to sort out any problems. Participants are welcome to join any time within the first 15 minutes of the advertised start time. The actual session will start on the hour.
Objectives:
By the end of the session you will be able to:
  • Create and rearrange pivot tables,
  • Sort and filter,
  • Group values such as dates, exam scores,
  • Change formatting of number values,
  • Use the Summarise By and Show Values As functions,
  • Add pivot charts to a table,
  • Use Slicers to filter.
Intended Audience:
This workshop is aimed at those wishing to learn how to use Pivot Tables in Excel to manipulate and display their data.
Target Audience: All
29/10/2021 - 29/10/2021  (Enrol between 01/10/2021 and 27/10/2021) Enrol

30/11/2021 - 30/11/2021  (Enrol between 01/10/2021 and 28/11/2021) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue