Getting Started with Pivot Tables (Mar 8)

J+ is a series ofaffordable and convenient digital skills workshopsby the Craig Newmark Graduate School of Journalism at the City University of New York. It is for working journalists, freelancers, photographers, video journalists, and other communicators who want to advance in their careers, change jobs or simply tell engaging, impactful stories in today’s media overload.

GETTING STARTED WITH PIVOT TABLES
with Jenny Ye
Class meets Thursday, March 8 from 6:30 to 9 pm
The cost for this workshop is $49; or $39 Early Bird rate before February 1
Pivot Tables are a powerful, no-code-necessary, tool used by all data journalists to analyze data in a spreadsheet. If you want to group data by a column (e.g. by zip code or by company), or multiple columns (e.g. by race AND gender), pivot tables will come in handy.
 
In this evening workshop, we will cover:
 
<UL>
<LI CLASS="MsoNormal">When and when not to use a pivot table</LI>
<LI CLASS="MsoNormal">How to set up pivot tables in Microsoft Excel and Google Sheets</LI>
<LI CLASS="MsoNormal">Summing, counting, averaging, and getting minimum and maximum values with Pivot Tables</LI>
<LI CLASS="MsoNormal">Sorting and filtering data with Pivot Tables</LI>
</UL>
 
What to bring: You will be provided with a computer outfitted with Excel in one of our computer labs. If you have Excel on your laptop and prefer to bring it, please do so.
Level: Beginner; prior knowledge of Excel is helpful but not necessary
 
<HR>
<IMG SRC="https://cdn.evbuc.com/eventlogos/196801588/jennyye2-1.jpeg"> 
About Jenny Ye
Jenny Ye is the Data Director of the WNYC Data News team. She works closely with reporters and editors on data driven stories, from research to visualization. She is a native New Yorker, and studied Computer Science and Ethnic Studies at Harvard College. She tweets <A HREF="https://twitter.com/thepapaya" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">@thepapaya</A>. 
<HR>
 
For concerns or questions about this workshop, please e-mail pd@journalism.cuny.edu

CUNY Graduate School of Journalism

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Getting Started with Pivot Tables (Mar 8)

More events from J+

Follow organizers to get events picked for you

Still looking for the right event?

Explore all events in New York and filter by date, category, and more to find the perfect fit.

Getting Started with Pivot Tables (Mar 8)

More events from J+

Follow organizers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in New York and filter by date, category, and more to find the perfect fit.