Formulas, functions, averages and ranking in Google Sheets

lessons

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

minutes

Start course

Course introduction

You can do data journalism without a maths or data science degree. In this module, 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.

Course lessons

Course introduction

How to use formulas/functions

min

How to calculate average, median and mode

min

How to calculate percentage change

min

How to rank data

min

How to calculate rate

min

instructors

Tegan Bedser

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

Get started

How to use formulas/functions

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.

Start this lesson

Get feedback

Request assignments to test your skills and get feedback from our instructors.

Email us now for support

course development in partnership with

We believe in the power of data to help us to understand the world around us and improve it. And we know that good visualisations are a powerful way to communicate insights.

FAQ

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