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.

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
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
30/04/2024 (14:00PM) - 30/04/2024 (15:00PM)  (Enrol between 16/02/2024 and 28/04/2024) Enrol

28/05/2024 (10:00AM) - 28/05/2024 (11:00AM)  (Enrol between 16/02/2024 and 26/05/2024) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue