Visit our "Search the ER&L 2015 Program" page to peruse all the accepted and peer-reviewed sessions for the 10th Anniversary Electronic Resources and Libraries Conference, February 22-25, 2015.
Click to view information about ER&L 2015 Online and Austin registration.
Pre-Conference Workshop 1: Excel for Librarians: Utilizing the Power of Excel to Track and Display Usage
Conference Track
2. Collection Development & Assessment
Keywords
excel, librarians
Learning Objectives
- Following this session, participants will be able to use conditional formatting to quickly analyze usage over-time
- Following this session, participants will be able to create basic pivot tables
- Following this session, participants will be able to present the data in visually meaningful and appealing ways
Abstract
For years, Librarians have been responsible for the collection and presentation of library usage data. Gathering usage is not only time-consuming it is difficult to find meaningful ways to analyze such large amounts of data. Often it is even more difficult to present the data in a way that is both visually appealing and easy to understand. The objective of this workshop will be to provide librarians with several tips and tricks to inputting, analyzing, and presenting data using Excel. Librarians will learn how to use conditional formatting, pivot tables, joining functions, as well as other features within Excel. Lastly, I will present the audience with a dashboard that can be created using customized Excel spreadsheets.
Presenters
![[photo]](https://secure.gravatar.com/avatar/7848e5dfc47819fb4c654485d5ab78d3.png?d=https://proposalspace.com/images/no_photo.png&r=PG&s=50 "Lanette Garza, Trinity University")