UCL Learning Portfolio

 

DSD: Excel Essential Skills - WORKSHOP 3
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 2 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 2.

IMPORTANT:

Once you have been invited to enrol, and 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:
  • 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
Planned for 16/11/2022 Register Interest

Register Interest in future dates Register Interest

Back to MyLearning Catalogue