*Cross posted to multiple lists*
ALCTS webinar: Excel for Technical Services: Introductory
Date: Wednesday, April 22, 2020
All webinars are one hour in length and begin at 11 am Pacific, noon Mountain, 1 pm Central, and 2 pm Eastern time.
This is part one of a two-part series. Excel for Technical Services: Intermediate is the companion to this webinar.
Description: 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.
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. 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.
*****************
Registration fees for one webinar: ALCTS Member $43; Non-member $59; Group rate $129
Registration fees for both webinars: ALCTS Member $69; Non-member $95; Group rate $206
For additional information and access to registration links, please go to the following website:
http://www.ala.org/alcts/confevents/upcoming/webinar/042220
ALCTS webinars are recorded and registrants receive a link to the recording shortly following the live event.
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
Posted on behalf of the ALCTS Continuing Education Committee.