Did you find this page helpful?

Thanks for letting us know!

Your feedback has been received! Take our 2-minute survey to give more detailed feedback
Oops! Something went wrong while submitting the form.
The Fundamentals of Data Journalism
Training module

Spreadsheets: Easy maths

Live training:

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.

 attendee limit

Register now

Registration closed

The words “easy” and “maths” in the same sentence? Nope, we are not pulling your leg. You can do data journalism - easily - without a maths degree.

Created & Presented by:

Media Hack Collective

Attendee limit:

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.

In this module, you will learn about the common functions (formulas) that you will use regularly when working with data in Google Sheets. The best part of formulas? They do all the heavy work and save you time.

Module videos

This module contains short videos with accompanying presentations and resources.

Introduction to functions (formulas)

In this introductory video to formulas, you will learn how to start doing your own calculations… and how to troubleshoot when things don’t quite go according to plan.

Formulas: Average, Mean, Median and Mode

Average/mean, median and mode are very useful formulas to know. In this video, we will discuss what they mean and things to look out for when working with them.

Formulas: Percentage change

Want to measure the degree of change over a period of time? We’ll show you how you can do this with the percentage change formula.

Formulas: Rank

In this video, we’ll show you how you can order your data by hierarchy with a formula called rank.

Formulas: Rate

Rate per 100,000 is frequently used when making comparisons. In this video, we’ll show you how you can apply this formula to COVID-19 data.

Module resources

Download and explore all the resources that are used in this module

Module documents and resources

Sign up for our newsletter