Library Juice Academy

Online Professional Development for Librarians

Excel for Librarians

Instructor: Erin Crane

Dates: September 2nd through October 11, 2019

Credits: 2.25 CEUs or 22.5 PDHs

Price: $250


Librarians work with data that they collect or access through a variety of sources, but often stop short of the "analysis piece." This course will teach librarians how to use Microsoft Excel (or a similar program with similar functions) to analyze data that is commonly collected in a library setting. After taking this course, the participants will be familiar with more advanced Excel functions and tools (such as pivot tables, filters, conditional logic, the VLOOKUP function, and number formatting) and understand how to apply them to their everyday work. Common tasks that can be managed with Excel that are covered in this course include determining collection duplication, calculating cost-per-use, assessing print and electronic collection use, and reviewing student assessment data.

Software requirement: Excel 2010 or above is recommended.

This course can be taken as one of eight courses needed to earn our Certificate in Cataloging and Technical Services, but can be taken as a stand-alone course as well.

Erin Crane

Erin Crane is the E-Resources and Instruction Librarian at Germanna Community College. In the past, she was the E-books Librarian for a large, primarily online university for 5 years. Her primary responsibilities included acquiring e-books, managing the demand-driven acquisition program and budget, negotiating licenses, and gathering and assessing usage statistics. In her new position she handles the management of e-resources of all types. She received her master degree in Library Science from the University of North Carolina at Chapel Hill, and her research interests include the contribution of e-resources to library value, the effectiveness of demand-driven acquisitions, and copyright and scholarly communication.

Course Structure

This is an online class that is taught asynchronously, meaning that participants do the work on their own time as their schedules allow. The class does not meet together at any particular times, although the instructor may set up optional sychronous chat sessions. Instruction includes readings and assignments in one-week segments. Class participation is in an online forum environment.

Payment Info

You can register in this course through the first week of instruction (as long as enrollment is not full). The "Register" button above goes to our credit card payment gateway, which may be used with personal or institutional credit cards. (Be sure to use the appropriate billing address). If you want to pay with Paypal, or if your institution wants us to send a billing statement or wants to send us a purchase order, please contact us by email to make arrangements.