Library Juice Academy

Online Professional Development for Librarians

Excel for Librarians

Instructor: Erin Crane

Dates: Not currently scheduled

Credits: 1.5 CEUs

Price: $175

Librarians work with data that they collect or access through a variety of sources (the integrated library system, the electronic resources administrative interfaces, surveys administered, etc.), but often stop short of the "analysis piece." This course will teach librarians how to take advantage of Microsoft Excel (or a similar program with similar functions) in analyzing 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 formula) 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, and assessing print and electronic collection use.

Software requirement: Excel 2010 or above is recommended.

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

Please contact us to arrange a special session of this class for a group of seven or more, with a negotiable discount, or to be notified when it is next scheduled.