Working with data in Google Sheets

15

minutes

View all courses

>

An introduction to using data in Journalism

>

Working with data in Google Sheets

>

Next Lesson

>

Next Course

Choose a lesson

An introduction to Google Sheets

7

min

Working with data in Google Sheets

15

min

Using data visualisation in journalism

8

min

How to choose the right chart/graph

6

min

How to create charts in Google Sheets

9

min

About this lesson

Instructors

More Courses

About this lesson

In this video you will learn: 1) How to manipulate (hide, insert, freeze) columns, rows, and cells in Google Sheets 2) How to import data from an existing Google Sheet or Excel document 3) How to copy cells from one sheet to another using paste, or paste special in Google Sheets.

In this lesson you will learn:

1. How to manipulate (hide, insert, freeze) columns, rows, and cells in Google Sheets

2. How to import data from an existing Google Sheet or Excel document

3. How to copy cells from one sheet to another using paste, or paste special 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

How to clean, summarise and analyse data

As a journalist, you interview a lot of people for your stories; you should interview your data as if you were interviewing a person. In this course you will learn how to view, edit, and organise data in spreadsheets to inform the questions that your journalism output aims to answer.

5

lessons

36min

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

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