UCL Learning Portfolio

To access MyHR and MyLearning, you will need to use the UCL VPN or Desktop@UCL.

The booking system is open to anyone with an active UCL userID (e.g. ucccabc). The system requires a training profile on MyHR to allocate your place:

If you use MyHR or MyFinance, you will already have a training profile to enrol.
For all other users, please wait for five minutes after selecting enrol and do not refresh your page. A training profile will be created for you. After this, future enrolments will be quicker.

If you have any questions, please email the course contact below or the relevant course training provider found on the homepage.

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. PREREQUISITES: 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. 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: 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