How to use formulas/functions

15

minutes

View all courses

>

Formulas, functions, averages and ranking in Google Sheets

>

How to use formulas/functions

>

Next Lesson

>

Next Course

Choose a lesson

How to use formulas/functions

15

min

How to calculate average, median and mode

14

min

How to calculate percentage change

12

min

How to rank data

12

min

How to calculate rate

18

min

About this lesson

Instructors

More Courses

About this lesson

In this video you will learn: 1) What are formulas/ functions and how you can use them in Google Sheets 2) How to add numbers in Google Sheets using the SUM formula 3) How to troubleshoot common function errors in Google Sheets.

In this lesson you will learn:

1. What are formulas/ functions and how you can use them in Google Sheets

2. How to add numbers in Google Sheets using the SUM formula

3. How to troubleshoot common function errors 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

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