Provider web pages

 

UCL Learning Portfolio

 

DSD: Pivot Tables in Excel - Demo (ISPTED) 
Course Description:

An introductory demonstration session to look at how 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.

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: 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 containing the direct joining link at least a day before the session.

Please note: We would encourage those who are new to Blackboard Collaborate 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:
Topics covered will include:
  • Creating pivot tables,
  • Rearranging pivot tables,
  • Sorting and filtering,
  • Formatting of number values,
  • Grouping,
  • Summarize By and Show Values As features,
  • Pivot charts,
  • Slicers for filtering.
Intended Audience:
This demonstration session is aimed at those wishing to get an overview on how Pivot Tables can be used to manipulate and display their data.
Target Audience: All
17/11/2021 - 17/11/2021  (Enrol between 01/01/1951 and 15/11/2021) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue