UCL Learning Portfolio


DSD: Excel Essential Skills - WORKSHOP 2 (Campus-based)
Course Description:

These campus-based workshops take a new approach to learning by presenting you with a problem to be solved and encouraging you to use your prior experience, web searches, in-application help, and fellow participants to find a solution to the task.

By the end of the session you will have improved problem-solving skills, increased knowledge of the topic, a suggested solution to the problem you worked on, and some resources and guidance for further learning.


You must have completed Excel Essential Skills - WORKSHOP 1 before participating in this workshop.


Once you have been invited to enrol, and subsequently enrolled, please check that you have received a confirmation email from MyLearning. You will also receive an email with location details at least one day before the session.

Please arrive 10 - 15 minutes prior to the start of the course to allow time for logging in and downloading resources.

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

On successful completion of the tasks in this workshop you will be able to:
  • Import a text file into Excel
  • Format cells appropriately according to their content
  • Apply multiple level sorting to a dataset
  • Apply filters to a dataset
  • Apply subtotals to a dataset
  • Freeze rows
  • Hide and show columns
  • Create custom views
  • Re-arrange columns
  • Duplicate worksheets
  • Delete rows
  • Transpose data from columns to rows or vice versa
Intended Audience:
These sessions are aimed at students who wish to become highly proficient in using Microsoft Excel.
Target Audience: UCL Students only
Course Contact: Digital Skills Development isd-digiskills@ucl.ac.uk
Further Information: https://www.ucl.ac.uk/isd/services/learning-teaching/digital-skills-development
06/03/2024 - 06/03/2024  (Enrol between 21/11/2023 and 04/03/2024) Enrol

13/03/2024 - 13/03/2024  (Enrol between 21/11/2023 and 11/03/2024) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue