UCL Learning Portfolio

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.

PREREQUISITES:

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.

• 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