Get Started in CAR with these Excel Tutorials

Dipping your toe into Computer-Assisted Reporting? We know most newsrooms don’t offer training in this area, so we have put together some video tutorials demonstrating relatively simple Excel functions to help you wrangle spreadsheet data and find meaning in your numbers.

Are you dipping your toe into computer-assisted reporting and data analysis? Looking to have a few simple Excel functions demystified?

We know most newsrooms these days don't offer training in this area (actually, we have worked in newsrooms where managers didn't think reporters needed access to Excel at all!). So we have put together a few video tutorials demonstrating relatively simple Excel functions which can help you wrangle spreadsheet data and find meaning in your numbers.

Excel concatenate

To start, ICIJ reporter Kate Willson takes you through Auto Fill: a simple yet powerful way to build tables. We also use them, like you see in this tutorial, to add clarifying labels to confusing or dirty data. 

Secondly there is Sorting and Filtering. Sorting allows you to group similar data together, whereas filtering allows you to drill down deeper in the data. We use filter to crosscheck our data too, to make sure we have the number or rows we expect, or to identify how many black entries to consider. 

Willson also demonstrates Concatenation to join data from multiple cells. This comes in handy particularly when writing lengthy SQL queries. For example, if you want to filter records by more than one criteria, typing can be repetitive.  By using the "Concatenate" function in Excel, you can automate the statements. This will not only save time, but it will make it less likely that you'll introduce mistakes into the query.

Finally Willson demonstrates Pivot Tables, a powerful tool to show trends in the raw numbers. It's also nice for those who prefer to interact with data visually. 

None of these tutorials will turn you into a Computer-Assisted Reporting wizard overnight, but they offer a great start to get you comfortable in Excel.

View all four training videos in How To Use Simple Excel Functions for Data Analysis, part of ICIJ's Resources library.

Want some extra resources to learn about Computer-Assisted Reporting? Try:

 Subscribe to The ICIJ Global Muckraker by email or get the RSS feed

 


FinCEN Files
AWARDS

Lessons from award-winning FinCEN Files and Luanda Leaks investigations

Jul 23, 2021
European Parliament and EU flag
FINCEN FILES

EU to propose watchdog to tackle anti-money laundering failures exposed by FinCEN Files

Jul 16, 2021
Protesters in London outside the Chinese Embassy
CHINA CABLES

As global pressure over human rights abuses in Xinjiang picks up, China remains defiant 

Jul 15, 2021
MONEY LAUNDERING

On the decline since Panama Papers, Malta punished for dirty money reputation

Jul 08, 2021
Isabel dos Santos and Sindika Dokolo
LUANDA LEAKS

Dutch court sides with report calling dos Santos-linked energy deal an ‘act of corruption’

Jun 28, 2021
Dubai
MIDDLE EAST

Facing global pressure, UAE to begin fining violators of new corporate transparency rules

Jun 21, 2021
ICIJ is dedicated to ensuring all reports we publish are accurate. If you believe you have found an inaccuracy let us know.