How to create a pivot table

9

minutes

View all courses

>

How to clean, summarise and analyse data

>

How to create a pivot table

>

No items found.

>

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 a pivot table is and how it can be used to calculate, summarise and analyse large datasets 2) How to create a pivot table in Google Sheets 3) How to analyse and structure data using a pivot table in Google Sheets.

In this lesson you will learn:

1. What a pivot table is and how it can be used to calculate, summarise and analyse large datasets

2. How to create a pivot table in Google Sheets

3. How to analyse and structure data using a pivot table in Google Sheets.

Lesson Resources

Resources used in this lesson are available to download

Download resources

Lesson instructor

Tegan Bedser

Tegan Bedser is a project manager for training and editorial projects at Media Hack Collective (MHC).

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

Knowledge and feedback

Contact

info@africadatahub.org

Social media