UCL Learning Portfolio

 

DSD: Pivot Tables in Excel - Demo
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, please check that you have received a confirmation email from MyLearning. You will also receive an email with a joining link at least one day before the session.

Courses start on the hour but please join during the 5 minutes prior to this to download resources and test out your connection/audio.

For more details on how to book, cancel and join sessions please visit our practical course information page .


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
19/01/2023 - 19/01/2023  (Enrol between 21/11/2022 and 17/01/2023) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue