Data Journalism – Google Sheets – Hands-On
This three-part hands-on express data journalism course will introduce you to the basics of data analysis in Google Sheets. Suitable for beginners.
Google Sheets 1:
Data journalism introduction: The basics: use Google Sheets to carry out basic calculations and percentage increases
Google Sheets 2:
Finding your top line: sorting and filtering in Google Sheets/Excel Handy/fun tools: (split, concatenate, using simple formulas)
Google Sheets 3:
Quick-smart data summary/analysis using pivot tables. Merging datasets (VLookUps)
We advise you to attend the entire course: Google Sheets 1-3, especially if you are a beginner.
These sessions are intended as a methodical guide to the use of Google Sheets in finding stories.
Finding Stories in Data (Thu 30 June) covers similar skills, but in Excel and also focuses on integrating data into storytelling. You do not need to do both Data Journalism-Google Sheet and Finding Stories in Data. Select one only.
Own laptops are required. Please create a Google Drive account, if you do not have one already.
- 29 June 2022 09.30–14.00