Back to resources

Using Excel for statistics: Short videos on cleaning data and dealing with missing data

These short videos demonstrate useful techniques for using Excel for statistics in GCSE and A level Mathematics, including the large data sets. Most are less than 5 minutes in length.

These videos use the World bank data set. 

This data set is not related to any exam specification; it has been chosen to illustrate the techniques.

  • video icon

    Missing data: unmerging cells in Excel

  • video icon

    Cleaning for missing data by filtering in Excel

  • video icon

    Issues with missing data in Excel

Related resources

Popular

Maths Week England 2026: Higher Tier GCSE Maths Quiz

Celebrate Maths Week England 2026 with this engaging Higher Tier GCSE Mathematics quiz, created by Cath
Popular

Calculator Crunch 2026

Our Calculator Crunch is a fun way to continue to engage Year 6s with maths whilst
Popular

MEI Conference 2026 session resources

Session resources from the MEI Conference 2026 The MEI Conference 2026 took place at Keele University,
Popular

Ritangle 2025

Ritangle 2025 took place from 8 October to 5 December 2025, with 1,854 teams taking part.
Skip to content