UCL Learning Portfolio


DSD: Advanced statistics with Excel 2016
Course Description:

This is not a statistics course. Participants must already have adequate statistical knowledge.

The purpose of this course to introduce you to the functions in the Microsoft Analysis ToolPak and to consolidate your skill in building complex formulae by hand. The course covers major descriptive measures, some parametric tests, chi-square testing of association and linear regression.

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 OR attend our Excel 2016 Essential Skills course or Excel Essential Skills Workshops 1, 2 and 3 prior to attending this course.


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 Blackboard Collaborate 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.
At the end of this course you will be able to:
  • Activate the analysis tool-pak
  • Perform simple descriptive statistics
  • Compare means for two groups
  • Conduct a chi-square test
  • Conduct an ANOVA
  • Compute regression coefficients
  • Carry out regression using the tool-pak
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: All
24/02/2022 - 24/02/2022  (Enrol between 02/12/2021 and 22/02/2022) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue