# 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, 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:
• 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
09/03/2022 - 09/03/2022  (Enrol between 02/12/2021 and 07/03/2022) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue