Back To Schedule
Monday, November 4 • 1:00pm - 4:00pm
PivotTables are easier than you think! Simple Yet Powerful Data Visualizations for Librarians with Excel

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Registration Cost: $150

Librarians and library staff work with data collected from a variety of sources however data collection doesn’t always translate to data analysis or reporting. Lack of time, budgetary constraints prohibiting the purchase of data visualization software, and potentially steep learning curves regarding using advanced features of existing software to create meaningful data visualizations can all impact individuals’ ability and/or willingness to analyze collected data using data visualizations.

In this session, we will walk all workshop attendees through the process of turning their library data (no matter how disorganized) into meaningful data visualizations using PivotTables in Excel. We will start off the workshop by discussing types of data that are best visualized with PivotTables, using examples of PivotTable visualizations created with our library’s data. We’ll discuss basic data cleaning, and specific concerns to consider when prepping your data for visualizing with Pivot Tables. We’ll share potential limitations of pivot tables and issues that you can encounter when building PivotTables. BYOD (Bring Your Own Device) is encouraged and time will be provided for workshop attendees to create their own data visualizations with the assistance of the workshop presenters.

avatar for Monica Rysavy

Monica Rysavy

Director of Course Operations, Forte Labs
Monica D.T. Rysavy, Ph.D. is the Director of Institutional Research and Training for Goldey-Beacom College in Wilmington, Delaware. In this role she leads all institutional research and data analysis projects for the College. Her office provides faculty and staff training support... Read More →
avatar for Russell Michalak

Russell Michalak

Director & Assistant Professor, Goldey-Beacom College

Monday November 4, 2019 1:00pm - 4:00pm EST
Laurens Room, Francis Marion Hotel 387 King Street, Charleston, SC 29401