Excel for Data Cleaning

Among other skills, in this workshop you will learn how to:

• Eliminate extra spaces

• Find and treat blank cells

• Remove duplicates

• Highlight or remove errors

• Change text to lower, upper or proper case

• Use text to columns to parse data

Georgetown University students, faculty and staff are welcome to attend. Registration and participation require a georgetown.edu, gunet.georgetown.edu or medstar.net email address.

The workshop will be presented by Jonathan Hartmann, Director of Clinical Integration Services & Data Discovery for Dahlgren Memorial Library.