Excel for Technical Services: Introductory

Wednesday, 4/22/2020
  • 2:00 PM-3:00 PM (Eastern)
  • 1:00 PM-2:00 PM (Central)
  • 12:00 PM-1:00 PM (Mountain)
  • 11:00 AM-12:00 PM (Pacific)
ALA and ALCTS are committed to supporting our members, staff, and all librarians and library workers during these uncertain times. We will continue to offer online learning opportunities, and will do our best to accommodate the remote needs of our attendees. We will also continue to offer group registration, providing individual logins for each group member registered for ALCTS webinars. Please contact ALCTS with any questions or concerns.

This is part one of a two-part series. Excel for Technical Services: Intermediate is the companion to this webinar.

This is the first of a two-part session showing features of Excel that can make data easier to both read and analyze. The presenter will walk through each step using a report generated from the ILS. The session will focus on viewing lists of items and ways to manipulate a list for better readability. It will show tips that could make Excel spreadsheets easier to read for those who don’t necessarily work in Excel regularly.

Learning Outcomes

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

Who Should Attend

Paraprofessionals and librarians. It is meant for people who don’t necessarily work in Excel regularly.


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. In January 2020 she will be teaching the online course Introduction to Collection Analysis through Library Juice Academy. She has an MLS from the University of Illinois at Urbana-Champaign and an MA in Sociology from Temple University.










Participant ($USD) ($USD)
ALCTS Member (individual) 43 69
Nonmember (individual)       59 95
Groups. Applies to group of people that will watch the webinar together from one access point. 129 206

All webinars are recorded and the one-time fee includes unlimited access to the webinar recording. All registered attendees will receive the link to the recorded session so if you are unable to attend the webinar at the time it is presented, you will have the opportunity to listen to the recording at your convenience.

How to Register

To Complete the series webinar online registration, please click here. Sessions are listed by date and you must log in. 

To Complete the individual webinar online registration form, please click here.  Sessions are listed by date and you must log in.


Contact us to register:

Call 1-800-545-2433 and press 5 to reach our customer service representatives or

Register by mail for the session you would like to attend. (If you receive an error message after clicking the "register by mail" link, right-click the link and save the form to your computer.)

ALCTS Code of Conduct

Please review the ALCTS Statement of Conduct before registering.

Tech Requirements

Computer with Internet access (high-speed connection is best) and media player software. Headphones recommended.

ALCTS webinars are presented through GoToWebinar. Check to see if your system supports GoToWebinar.

Test your connection or audio.




For questions about registration, contact ALA Registration by calling 1-800-545-2433 and press 5 or email registration@ala.org.

For all other questions or comments related to the webinars, please contact alctsce@ala.org.