UCL Learning Portfolio


DSD: Excel Essential Skills programme (self-paced) - Worksheet 1 Review
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: Please ensure you are using Desktop@UCL or the UCL VPN when booking because you need to be on the UCL network to use the system.

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 from ISD containing the direct joining link a day before the session. Please check your junk folder as these emails are occasionally tagged as spam.

We would encourage those who are new to Microsoft Teams to join w
On successful completion of the tasks in Worksheet 1 you will be able to:
  • Create an Excel workbook
  • Make changes to workbook properties
  • Rename a sheet
  • Enter and edit column headings and row labels
  • Use the fill handle create a series
  • Re-size columns
  • Create simple formulas
  • Use an absolute reference in a formula
  • Format cells appropriately according to their content
  • Add comments to cells
  • Prepare a worksheet for printing
Intended Audience:
These sessions are aimed at students who wish to become highly proficient in using Microsoft Excel.
Target Audience: UCL Students only
Register Interest in future dates Register Interest

Back to MyLearning Catalogue