Provider web pages

 

UCL Learning Portfolio

 

DSD: Excel Essential Skills programme (self-paced) - Worksheet 2 Review (ISESSW2R) 
Course Description:

Our series of Excel Essential Skills worksheets take a new a new approach to learning by presenting you with a problem to be solved and encouraging you to use your prior experience, web searches and in-application help to find a solution to the task.

Anyone who wants to complete the self-paced Excel Essential Skills programme should attend a short Orientation session, where the facilitator will introduce the format, guide you to the location of the course materials and point you in the direction of where to find help.

You then complete the worksheets at your own pace, however, if you get stuck on a particular step, you can attend one of our drop-ins for help.

Once you have completed the tasks for a particular worksheet, you can access the `worked example? by marking the tasks as complete in Moodle. You can attend a follow-up Review session where the trainer will go over the tasks and you will have the opportunity ask any further questions.

By the end of each worksheet, you will have improved problem-solving skills, an increased knowledge of the topic, a `worked example? of how you might have completed the worksheet and some resources and guidance for further learning.

IMPORTANT: Once you have enrolled, you will need to click on the play button under 'My current enrolments' in My Learning to join at the time of the live session. You will also receive an email containing the direct joining link at least a day before the session.

Please note: We would encourage those who are new to Blackboard Collaborate to join 15 minutes early in order to test out their connection/audio and help will be offered to sort out any problems. Participants are welcome to join any time within the first 15 minutes of the advertised start time. The actual session will start on the hour.


Objectives:
On successful completion of the tasks in Worksheet 2 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
17/11/2021 - 17/11/2021  (Enrol between 01/10/2021 and 15/11/2021) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue