Back to resources

Using Excel for statistics: Short videos on working with charts

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 data set OECD.stat (2017) Municipal waste, generation and treatment April 2017.

The data set used in the videos is not related to any exam specification; it has been chosen to illustrate the techniques.

  • video icon

    Inserting a time series chart in Excel

  • video icon

    Cleaning data for a time series chart in Excel

  • video icon

    Freezing panes in Excel

  • video icon

    Cleaning data, chart types and labels in Excel

  • video icon

    Moving a chart to a new sheet in Excel

Related resources

Popular

Ritangle 2024

Questions and answers from our Ritangle 2024 competition

Proving the Pythagorean Theorem

Explore the Pythagorean Theorem in ancient texts in order to better appreciate how maths has developed in a range of diverse cultures.

Maths games from around the world

Appreciate maths from other cultures by exploring games with a focus on problem-solving and strategy.

The Big Earth Data Project: Atmosphere: The Hole in the Ozone Layer KS4/5

A suite of hands-on activities to engage and inspire students to look at current environmental challenges faced today, funded by the UK Space Agency

Popular Searches

About MEI Data Science and AI Resources Support for educators
Skip to content