TBLC logo
This webinar will demonstrate features of Excel that can make data easier to both read and analyze. Presenter, Karen Kohn, will walk through each step using a report generated from the ILS. The first half of the session will focus on viewing lists of items and ways to manipulate a list for better readability. Participants will learn tips that can make Excel spreadsheets easier to read for those who don’t necessarily work in Excel regularly. The second half of the session will explore ways to transform data for analysis, including: importing fields from one spreadsheet into another, finding duplicates, splitting columns that have multiple values, and using conditional formatting to help visualize data.
At the end of this webinar, attendees will be able to:
  • Create filters in Excel and use them to count and sum subsets of a spreadsheet
  • Filter a column in a spreadsheet by text, number, or color
  • Create a pivot table
  • Use formulas to do basic arithmetic in Excel
  • Import data from one spreadsheet into another
  • Use conditional formatting to find duplicates or outlier values, and to create simple data visualizations
  • Split cells that contain multiple values, e.g., multiple ISBNs
This session is intended for paraprofessionals and librarians. It is meant for people who don’t necessarily work in Excel regularly, however people in the library who use Excel for analysis will also benefit.

Presenter: Karen Kohn is Collections Analysis Librarian at Temple University in Philadelphia, PA and the author of Collection Evaluation in Academic Libraries: A Practical Guide for Librarians (Rowman & Littlefield, 2015). She has published articles in College & Research Libraries, Journal of Academic Librarianship, Journal of Documentation, and Collection Management and presented at the Charleston Library Conference and the Acquisitions Institute at Timberline Lodge. She is the instructor of the online course Introduction to Collection Analysis, offered through Library Juice Academy. She has an MLS from the University of Illinois at Urbana-Champaign and an MA in Sociology from Temple University.

In partnership with TBLC,  webinars originally presented to their membership can now be found and accessed through Florida Library Webinars.

If you have questions about a session, contact TBLC.