UCL Learning Portfolio


DSD: Advanced statistics with Excel (Campus-based)
Course Description:

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

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

The course consists of one two-hour face-to-face campus-based 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 Excel skills OR attend our Excel Essential Skills Workshops 1, 2 and 3 prior to attending this course.


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.

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
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