Skip to main content.

Excel Basics for Analyzing Health Data

With the explosion of public health data online, more journalists than ever need analytical tools in their daily work. Think of data as just another source to interview, along with people and documents. Using a spreadsheet for simple tasks makes a journalist better at finding a story, fending off bogus ideas and sharpening the questions they can ask people. This webinar aims to give newcomers a basic grounding in using a spreadsheet (Excel) to do simple data cleanup and analysis for journalism. This webinar will be led by Paul Overberg.


Paul Overberg

has been a data journalist for more than 20 years, most recently at USA TODAY. He specializes in analyzing demographic trends but has worked on data about everything from Obamacare to stream flows. He has taught data journalism at American University and for professional groups including Investigative Reporters and Editors, Associated Press Media Editors, the Reynolds Institute for Business Journalism at Arizona State and the Society of Professional Journalists.  

WHEN: July 7, 2015, from 10 to 11 a.m. PT / 1 to 2 p.m. ET


Suggested reading —

Excel basics for journalists: 

How journalists can use Excel to organize data for stories,” by Josh Hatch, Poynter

Excel I – Sorting and filtering,” Linda J Johnson, IRE.org

Excel functions for journalists:

My Favorite (Excel) Things,” by Mary Jo Webster, Minneapolis Star Tribune

Excel 2: Rates and Ratios,” by Denise Malan, IRE.org

Excel data cleanup for journalists:

My Favorite (Excel) Things,” by Mary Jo Webster, Minneapolis Star Tribune

Associated data and examples:

Excel Tricks 2014 handout data (spreadsheet) 

YouTube videos:

Sarah Cohen videos on filtering, pivot tables, importing

The Age of Insight: Telling Stories with Data

            The Health Matters Webinar series is supported by the National Institute for Health Care Management Foundation. The Center for Health Journalism is solely responsible for the selection of webinar topics and speakers.

Announcements

Join us on March 22 for a daylong briefing on the U.S. Census. Participants will learn about the challenges facing counters, efforts to delegitimize the U.S. Census, how the climate of fear in immigrant communities might impede a good count, and discuss reporting and census data analysis strategies.  

What’s the difference between Medicare-for-all and Medicare-for-some? Are these realistic policy proposals, or political blips on the screen? Sign up here for our next Health Matters webinar!

If you're a journalist with big ideas who wants your work to matter, the Center for Health Journalism invites you to apply for the all-expenses-paid National Fellowship -- five days of stimulating discussions in Los Angeles about social and health safety net issues, plus reporting and engagement grants of $2,000-$12,000 and six months of expert mentoring.

CONNECT WITH THE COMMUNITY

Follow Us

Facebook


Twitter

CHJ Icon
ReportingHealth