Library Juice Academy

Online Professional Development for Librarians

Excel for Librarians

Instructor: Erin Crane

Dates: August 7 to September 1, 2017

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, analyzing free text data, and assessing print and electronic collection use.

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 pay using a purchase order, please contact us by email to make arrangements.