Excel for Librarians

Program Type:

Online Course
Please note you are looking at an event that has already happened.
Registration for this event is no longer open.

Program Description

Event Details

Four-week Course | December 2 - December 29, 2024

At some point in your library career you will interact with a spreadsheet, be it one that contains data you have entered, someone else has entered, or data you have exported from a system. With Excel, you can easily manage and wrangle structured data, even if it is not in an Excel format. This class will teach the basics of working in Excel, including entering, structuring, manipulating, importing and exporting data. It will also cover some Excel functions and tools for basic data analysis. The class assignments will incorporate practical data tasks that you would encounter in a library or information management setting.

By the end of the class, students will:

  • Learn good practices for data entry, spreadsheet structure, and data organization
  • Understand data formats and how to troubleshoot common formatting errors (such as dates)
  • Be able to sort and filter data and write basic Excel functions
  • Learn how to perform cleanup, quality control, and data validation using Excel’s data tools
  • Learn to import and export data to CSV and tab separated files

 

Presenter: Trevor Smith is the Monograph Collections and Metadata Librarian at Douglas College and an adjunct faculty member at UBC SLIS where he teaches Project Management for Information Professionals. He has mainly worked in Academic libraries but has also worked in Start-ups. Prior to becoming a librarian, he worked in the tourism sector where he developed a railway reporting network using SharePoint and MS Access. He often presents workshops and talks on databases and Project Management.

 

CALL Training Partner for this Event: Library Juice Academy

Additional Information

Enrollment Statement

I understand that a space will be reserved for me in this learning opportunity at a cost to CALL, and if I am unable to attend this learning opportunity, I will cancel my enrollment as soon as possible and before the start date. 

Single Enrollment Disclaimer

I understand that I can register for only one course at a time (no concurrent courses). If I do not attend this course, I understand that I may forfeit the opportunity to enroll in additional CALL courses during this fiscal year.