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.


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


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 .

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
06/06/2023 - 06/06/2023 Join Waiting List

Register Interest in future dates Register Interest

Back to MyLearning Catalogue