Skip To Content
Basic Data Cleaning in Excel is a Course

Basic Data Cleaning in Excel

Nov 30, 2022 - Nov 30, 2022
2 credits

Spots remaining: 7

Enroll

Full course description

Term: Fall 2022

Date: November 30th, 2022

Time: 2:00pm - 4:00p

Location: Torgerson 3310 & Online through Zoom

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 a recent version of Microsoft Excel installed. This workshop is based on the Library Carpentry TidyData lesson (https://librarycarpentry.org/lc-spreadsheets/) and is recommended for anyone who works with data in spreadsheets.

Sign up for this course today!

Enroll