UCL Learning Portfolio

 

DSD: Excel Essential Skills - WORKSHOP 2
Course Description:

Our 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, an 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.

This Workshop is not available to book here. You will be invited to book onto this workshop once you have completed the tasks in Workshop 1.

IMPORTANT:

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.


Objectives:
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
Planned for 02/11/2022 Register Interest

Register Interest in future dates Register Interest

Back to MyLearning Catalogue