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

 


IMPACT

The Denver Art Museum to return four artifacts to Cambodia after Pandora Papers investigation coverage of indicted art dealer

Oct 17, 2021
Baker McKenzie
IMPACT

Pandora Papers investigation prompts new scrutiny of law firms’ role in offshore abuses

Oct 13, 2021
IMPACT

Political and business links to Pandora Papers roil parliaments, anti-corruption and tax authorities as global fallout swells

Oct 12, 2021
IMPACT

Czech prime minister’s party narrowly loses re-election days after Pandora Papers revelations in surprise outcome

Oct 09, 2021
IMPACT

136 countries agree to global minimum tax for corporations in ‘historic’ OECD deal

Oct 08, 2021
IMPACT

Chilean President Sebastián Piñera to be criminally investigated due to Pandora Papers revelations

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