UCL Learning Portfolio


DSD: Intermediate statistics with Excel 2016
Course Description:

This is not a statistics course nor is it a basic Excel course. Participants must have an adequate statistical understanding and hold the pre-requisite Excel skills listed in our Moodle course.

This course is aimed at those who would like to learn how to write formulae and use functions in Excel for basic statistical purposes. The course includes major descriptive measures, the computation of variance by hand and correlations.

The course consists of one two hour on-line session.


There are a number of pre-requisites for this course. Please visit the Digital Skills Development Moodle course for details.

You should ensure that you have all the relevant pre-requisite skills prior to attending this course.

IMPORTANT: Please ensure you are using Desktop@UCL or the UCL VPN when booking because you need to be on the UCL network to use the system.

Once you have enrolled, you will need to click on the play button under 'My current enrolments' in My Learning to join at the time of the live session. You will also receive an email from ISD containing the direct joining link a day before the session. Please check your junk folder as these emails are occasionally tagged as spam.

We would encourage those who are new to Microsoft Teams to join within the first 15 minutes of the advertised start time in order to test out their connection/audio. The actual session will start on the hour.
Topics covered will include:
  • Measures of location
  • Measures of diffusion
  • Measures of shape
  • Frequency
  • Correlation
  • worksheet and data management
  • simple tables
Intended Audience:
This course is aimed at those with statistical knowledge who wish to learn how to use Excel to carry out statistical analysis of their data.
Target Audience: UCL Staff only
Register Interest in future dates Register Interest

Back to MyLearning Catalogue