Intro to Excel and OpenRefine: working with spreadsheets (Library Carpentry)

Term:  Spring 2025

Date: January 14th, 2024

Time: 9:00am - 5:00pm (lunch 12:30-1:30)

Location: University Mall 2104 (directions) & Online

Instructors: Nathaniel Porter & Jesse Sadler

Presented By: University Libraries (LIB)

Description:

Learn best practices for cleaning up messy real-world data in Excel spreadsheets, then level up your data cleaning skills with the power of OpenRefine. This hands-on workshop will cover ways to clean, standardize, and combine spreadsheets in Excel and OpenRefine, as well as touching on tools to improve the quality of initial Excel data entry and for using APIs to enhance data with external sources in OpenRefine. 

The workshop is open to anyone and based on lessons from Library Carpentry. You do not need any experience with the sofware to participate but you will need access to a Windows, Mac or Linux computer. Instructions for accessing course material and installing software will be sent in advance. Lunch and refreshments will be provided for in-person participants. For questions, contact Data Education Coordinator Nathaniel Porter (ndporter@vt.edu).

If you are an individual with a disability and desire an accommodation, welcome! Please email library-event-accessibility-g@vt.edu at least 10 days prior to the event. 

Please Note Only 20 spaces are Available in person, please answer the Canvas email you recieve after registering asking how you plan attend