Would you like to receive notifications about more lessons?

Close icon
Sign-up to Africa Data Hub Newsletter for updates on training.

Training

How to clean, summarise and analyse data

How to summarise data

9

minutes

View all courses
>

How to clean, summarise and analyse data

>
How to summarise data
>

Next Lesson

>
Next Course

Choose a lesson

How to structure data

8

min

How to filter data

6

min

How to sort data

4

min

How to summarise data

9

min

How to create a pivot table

9

min

About this lesson
Instructors
More Courses

About this lesson

In this video you will learn: 1) What is summarising data and why do we do it 2) How to use the SUM function in Google Sheets to summarise data 3) How to use pivot tables to summarise data in Google Sheets.

In this lesson you will learn:

1. What is summarising data and why do we do it

2. How to use the SUM function in Google Sheets to summarise data

3. How to use pivot tables to summarise data in Google Sheets.

Lesson Resources

Download icon

Resources used in this lesson are available to download

Download resources

More courses

Formulas, functions, averages and ranking in Google Sheets

You can do data journalism without a maths or data science degree. In this course, you will learn how to do simple calculations in Google Sheets that will help you calculate and communicate data as evidence in your story telling.

5

lessons

1h 11min

Sorting and cleaning data for journalism

This course will teach you where and how you can source data for your journalism stories, how to clean and organise data so that it’s ready for analysing and visualising in your data story.

5

lessons

46:13min

Tools for visualising data in journalism

Visualisations bring the “ooooh” factor to data-driven journalism, but their purpose is greater than simply making your story “pretty”. This course will teach you where and how you can source data for your journalism stories, how to clean and organise data, as well as how to visualise data using simple charts.

2

lessons

38:78min

View all ADH courses

Be the first to know about our new training material!

Africa Data Hub seeks to lower the barriers that African journalists face to access and use data in their storytelling around health and development.

This work is supported by the Bill & Melinda Gates Foundation.

Data resources
Mapped data
Vaccine Tracker
COVID-19 Observer
Data Repository
Knowledge and feedback
Glossary
Attribution Guide
User survey
Cookie policy
Code of conduct
Newsletter
Our Brand
Contact
info@africadatahub.org
Social media
© Africa Data Hub. Open Cities Lab is a non-profit organisation DSD: 255-261NPO / PBO (18A): 930067929. The ADH project is Licensed under a Creative Commons Attribution 4.0 International License.