Course

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

Ended Aug 15, 2024
12 credits

Spots remaining: 0

Enrollment is closed
Add yourself to the wait list and you'll be auto enrolled when a spot opens

Add to Wait List

Full course description

Please Also Enroll Using Libcal to Attend using this link: https://calendar.lib.vt.edu/event/12684965 

 

Term:  Summer 2024

Date: August 15th, 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