Course

Data Cleaning in Excel

Ended Aug 7, 2023
2 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

Term: Fall 2023

Date: August 7th, 2023

Time: 9:00am - 11:00am

Location: Online Only

Instructor: Nathaniel Porter

Presented By: University Libraries (LIB)

 

Description:

More people work with data in spreadsheets than any other form, using software like Excel and Google Sheets. Spreadsheets provide relatively low-barrier tools like pivot tables and charts to summarize and analyze such data, but often there are inconsistencies or the data are stored in ways that are hard to analyze. 

This hands-on workshop helps learners identify and practice addressing common data problems using tools built into Excel and other spreadsheet software, as well as establishing workflows and habits to reduce such issues from the start. 

No experience is necessary, but learners will need access to a computer with Zoom and a recent version of Microsoft Excel or other spreadsheet software installed. This workshop is part of the Library Carpentry curriculum and is recommended for anyone who works with data in spreadsheets.

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