Pre-Conference Workshop 1: Excel for Librarians: Utilizing the Power of Excel to Track and Display Usage

Sunday, February 22, 2015 at 1:00 PM–5:00 PM CST

Workshop - Salon A

Conference Track

Keywords

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.