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

 


RUSSIA

New US sanctions target trust companies and corporate service providers for the first time

May 12, 2022
European Parliament
Accountability

Pandora Papers shed light on ‘gatekeepers’ of dirty money says European watchdog

May 09, 2022
MONEY LAUNDERING

As US pledges renewed fight against dirty money, head of financial crime agency says funding shortfalls have caused delays

Apr 29, 2022
Pandora Papers on screen
AWARDS

Pandora Papers investigation receives National Headliner Award, other honors

Apr 27, 2022
IMPACT

Lawmakers in US push to uncover riches shielded by state secrecy laws

Apr 21, 2022
IMPACT

Sweden’s anti-corruption agency launches investigation into suspicious Ericsson payments in Iraq

Apr 20, 2022
ICIJ is dedicated to ensuring all reports we publish are accurate. If you believe you have found an inaccuracy let us know.