Back To Schedule
Wednesday, November 6 • 9:00am - 12:00pm
Excelling with Excel: Advanced Excel Functions for Collection Analysis

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Cost: $110, add to your Conference Registration

Microsoft Excel offers useful features and formulas that potentially allow Acquisitions and Collection Development Librarians to work smarter, not harder. Using journal cancellations as a workplace scenario, the presenters will provide attendees with step-by-step instructions for organizing data and completing basic calculations with Excel. The presenters will demonstrate how to use several advanced Excel functions including pivot tables, vlookup, and select formulas. Participants will learn how to import and export data, combine and compare data from different sources, and formatting data to communicate more effectively. The session will be held in a classroom with computers (Addlestone Library Room 122), so attendees will be able to follow along by downloading an Excel file with sample data specifically created for this hands-on workshop.

avatar for Denise Pan

Denise Pan

Associate Director, Technical Services, University of Colorado Denver
Since 2008 Denise Pan supports student, faculty, and staff success in the role of Associate Director of Technical Services for the Auraria Library. This tri-institutional academic library serves the University of Colorado Denver, Metropolitan State University of Denver, and... Read More →
avatar for Gabrielle Wiersma

Gabrielle Wiersma

Head of Collection Development, University of Colorado Boulder

Wednesday November 6, 2013 9:00am - 12:00pm EST
Room 120, Addlestone Library 205 Calhoun Street, Charleston, SC 29401

Attendees (0)