UCL Learning Portfolio

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.

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 .

• 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.