Where eResource Professionals Learn, Connect, and Grow.

<-- back to Workshop Main Page

Excel for Libraries

Oct 31-Nov 11, 2022

Asynchronous Course Delivery

During the dates listed above, content will be consumed on-demand at attendees’ own pace and live office hours will be hosted. 

$175/ single ticket, $131/ group ticket 

Registered Attendees

See link emailed 10/31. 

Excel is a valuable tool for eResource librarians – from workflow support, to usage data gathering and analysis, to demonstrating library impact. Unfortunately, many of us can’t fit in the time in our day-to-day work to learn advanced Excel techniques that would make us more efficient and effective. In this workshop, attendees will learn a variety of techniques and best practices ranging from general data cleanup tips and tricks, to more advanced topics such as queries, merges, and using data to tell a visual story with charts.

Following the workshop, participants will be able to: 

  • manipulate and analyze excel data to answer questions about their library services and resources.
  • present data in a meaningful way to stakeholders.

AUDIENCE LEVEL: Intermediate

PARTICIPATION:

Course participants will consume the videos on their own schedule during the dates of the conference. Live Office Hours will be hosted during the 2 weeks where participants are encouraged to share their progress (dates TBD). Students will upload homework to a folder that is shared with the instructors where instructors can comment and answer individual questions. A discussion board will be utilized. 

COURSE OUTLINE:

To be shared with registered course attendees prior to course start date.

Meet Your Course Instructors

Jens Arneson
Online Resource Librarian
Eastern Kentucky University Libraries

Jens Arneson is the Online Resources Librarian at Eastern Kentucky University Libraries where he has served in that capacity since 2014. He received a Bachelor of Arts degree from the University of Southern Indiana in 2007, and a Masters of Science in Library and Information Science degree from the University of Kentucky in 2011. Areas of interest in his library practice include: Strategic Planning, Assessment, User Experience, Emerging Technologies, and Electronic Resource Management. He resides in Lexington, KY with his wife and two spoiled smelly dogs.

Kelly Smith
Director of Collections and Discovery
Eastern Kentucky University Libraries

Kelly Smith is the Director of Collections and Discovery at Eastern Kentucky University Libraries, where she has served in various roles since 2005. She received a Bachelor of Fine Arts degree from the University of North Carolina at Greensboro in 1994, and a Masters of Science in Library and Information Science degree from Simmons College in 1997. Areas of interest in her library practice include: Open Educational Practices; Strengths Based Leadership; Strategic Planning; Assessment; Collection Development; Electronic Resource Management; and Process and Change Management.