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

The engagement editor's mission: to advance the work of our California media partners, furthering public knowledge, storytelling, engagement and connection around community health and health policy issues in diverse communities. The ideal candidate will have both journalism and community engagement experience. Go to this link to apply.

We're looking for journalists who think big and want to gain new insights into the effects on vulnerable children  and their families of poverty, trauma and toxic stress. The all-expenses-paid 2017 National Fellowship, which provides five days of intensive workshops, field trips and discussions, along with $2,000-$12,000 grants for reporting and community engagement and six months of mentoring. Click here for details. Deadline: March 24.

CONNECT WITH THE COMMUNITY

Member Activities

Max commented on a post

Join the conversation.

Paul Keckley has shared a blog post

Read it.

Jamie Hopkins has shared a fellowship project

Read it.

Marissa Ortega-Welch has shared a blog post

Read it.

Halona Black joined the community

Connect with Halona Black
More Member Activities

Follow Us

Facebook


Twitter

CHJ Icon
ReportingHealth