[Metadatalibrarians] Excel for Librarians

Rory Litwin rlitwin at gmail.com
Tue Jul 25 05:32:40 PDT 2017

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 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.

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.

You can register in this course through the first week of instruction (as
long as it is not full). The "Register" button on the website 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 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: inquiries at libraryjuiceacademy.com

For a list of all of the courses being offered next month, please go to:

Library Juice Academy
P.O. Box 188784
Sacramento, CA 95818
Tel. (916) 905-0291
Fax (916) 415-5446

inquiries at libraryjuiceacademy.com

Demo course:



Check out our jingle:

Subscribe to our mailing list

More information about the Metadatalibrarians mailing list