Numbers

You’ve started crunching data and you’re looking for enhanced or faster results. This one-day course will teach you powerful spreadsheet analysis skills for everyday data-driven reporting.

This is a hands-on workshop designed to support storytelling, taught by Crina Boros, award-winning, freelance journalist and a data journalism trainer affiliated with the Centre for Investigative Journalism and Data Harvest.

It was conceived with reporters, NGO workers, researchers and academics in mind.

Participants will learn powerful Excel functions that would allow them to dig deeper, quicker and manipulate data for reporting - pivot tables, LookUps, If Clauses and a brief introduction to statistics.

This is a workshop for intermediate Excel users. The workshop is designed to upgrade spreadsheet journalism competence and to help participants integrate computer-assisted reporting into their routine.

Preparation

Pre-requisites: Participants wishing to enrol should already be comfortable with Excel functions and basic tools.

Software: Participants should bring their laptop, for which they should have admin rights. We will be using Excel. Windows users: your Excel can be as old as 2010, but not older. Mac users: your Excel version needs to be no older than 2016. Linux/Ubuntu users: Open Office / Libra will not be able to carry all technical requirements. Excel can be installed from here or here. Google spreadsheets, Excel Online or Excel on a tablet / smart phone will not be sufficient.

Email the trainer with any pre-course questions and let the organisers know which operating system you’ll be using.

Course structure:

  • Mine deeper for stories with Pivot Tables;

  • Find and match data or join tables with LookUp functions;

  • Follow your leads with IF and COUNTIF;

  • Brief introduction to relational statistics – correlations;

  • Data Lab – your data, your questions – a freestyle session.


Getting there

This course will be held at The Bridge, 81 Southwark Bridge Road, London SE1 0NQ.


About Crina Boros

Nominated for the Paul Foot Awards 2017, Crina Boros is an award-winning freelance reporter and a data journalism trainer affiliated with the Centre for Investigative Journalism (CIJ) – she trains computer-assisted reporting internationally.

She has covered cartels and corruption in the fishing industry for Greenpeace UK, women’s rights and climate change for the Thomson Reuters Foundation, abuse of migrant workers for BBC, murky money for ICIJ’s Swiss Leaks team, money laundry for OffshoreAlert and public funding and asylum seekers for Exaro News among many.

She is also part of Investigate Europe consortium of cross-border journalists and is responsible for the data journalism training tracks at Data Harvest and CIJ’s London-based Summer Conference.