UCL Learning Portfolio


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

This is a one hour, online session hosted in Microsoft Teams.


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
Course Contact: Digital Skills Development isd-digiskills@ucl.ac.uk
Further Information: https://www.ucl.ac.uk/isd/services/learning-teaching/learning-teaching-services/digital-skills-development/digital-skills
Register Interest in future dates Register Interest

Back to MyLearning Catalogue