UCL Learning Portfolio

 

DSD: In a Nutshell: Excel functions we should all know
Course Description:
This is a one-hour demonstration that introduces some of the Excel functions (both basic and advanced) that we could all benefit from knowing.

Prerequisites:

A basic understanding of navigating spreadsheets and editing cell contents. We will be using the most recent versions of Excel (O365, 2019).

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:
Topics covered will be selected (depending on time!) from:
  • datedif
  • xlookup
  • if
  • sumif
  • averageif
  • concatenate
  • left/right
  • choose
  • convert
  • remove duplicates
Intended Audience:
All students and staff.
Target Audience: All
19/01/2023 - 19/01/2023  (Enrol between 21/11/2022 and 17/01/2023) Enrol

10/03/2023 - 10/03/2023  (Enrol between 21/11/2022 and 08/03/2023) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue