90 mins

Cleaning and Analysing Data

School of Data
This course will introduce you to the practical skills needed to analyse data using spreadsheets, allowing you to start looking for stories in data if you’re a journalist or analysing your data for advocacy or social development if you’re an activist.
About this course:
This course is designed for human rights activists and journalists who would like to use data to support their advocacy work or tell stories. Starting with how to do basic math in a spreadsheet this course covers the most important tools and methods for analysing data and aims to leave you with the practical skills to start exploring your own data. We understand the idea of working with spreadsheets and data can be intimidating, so don’t worry, we’ll be gentle!
What do I learn:
By the end of the course you will have been introduced to some of the most important practical skills for wrangling – using spreadsheets. You will be able to analyse data by sorting and filtering and using formulae and pivot tables. You’ll learn what can go wrong with data and how to avoid this with some data cleaning techniques.
What do I need to know:
This course is suitable for anyone who is interested in getting started with data and all you need to take this course is a computer and internet access.


Milena Marin

Since 2009 Milena Marin has worked at the intersection of technology, data and social good. She is a true data wrangler who has collaborated with countless organisations from around the world to help them make the most of of their data and reach new audiences.

Hannah Williams

Hannah is a graphic designer working in both web and print. She also does copy writing now and again and have worked on a couple of public art projects. Recently she has been trying to focus more on doing work that has a positive social impact.

1.1 Introduction to Cleaning and Analysing Data
1.2 Examining data: range, count and distribution
1.3 Averages: Mean, median and mode
1.4 Normalising data: Comparing things
1.5 Quiz
2.1 Spreadsheets: An overview
2.2 Creating a spreadsheet and uploading data
2.3 Navigating and using the Spreadsheet
2.4 Sorting Data
2.5 Filtering Data
2.6 Quiz
3.1 Introduction to formulae
3.2 Using a formula to add, subtract and multiply values
3.3 Using the built-in functions
3.4 Visualising data - Creating basic charts
3.5 Screencast: Creating basic charts
3.6 Quiz
4.1 Introduction to advanced formulae and pivot tables
4.2 More complex formulae
4.3 Retrieving data: the vlookup function
4.4 Summarising data: Pivot Tables
4.5 Quiz: Formulae and pivot tables
5.1 Introduction to data cleaning
5.2 What can go wrong?
5.3 Summary and best practices
5.4 Quiz: Cleaning Data
6.1 Conclusion

Related courses

  • 60 mins


    Data Gathering for Beginners

    School of Data

    60 mins


    Data Gathering for Beginners

    School of Data
  • Infotimes

    30 mins

Suggested reading

Skip to navigation
  • Privacy
  • Terms