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

Course Introduction

COURSE INTRODUCTION

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.

Start Course

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

FAQ

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