UCL Learning Portfolio

 

DSD: Excel Essential Skills programme (self-paced) - Worksheet 3 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:

Once you have enrolled, please check that you have received a confirmation email from MyLearning. You will also receive an email with a joining link at least one day before the session.

Courses start on the hour but please join during the 5 minutes prior to this to download resources and test out your connection/audio.

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 Worksheet 2 you will be able to:
  • Name a cell or range of cells and make changes to names
  • Use conditional formatting
  • Use aggregate functions to find minimum, maximum and average values
  • Use Excel's Quick Analysis tool
  • Use the IF and AVERAGE IF functions
  • Use Excel's Insert Function wizard
  • Perform calculations involving dates
  • Use a function to round values up or down
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