Event box

Love Data Week: Data Cleaning with Excel

In this workshop, participants will learn to:

  • remove extra spaces in data (e.g., TRIM())
  • remove duplicative data
  • use conditional formatting to locate data errors
  • use data validation
  • combine cells into new columns (CONCATENATE())
  • use XLOOKUP() to combine data from multiple worksheets
Date:
Friday, February 14, 2025
Time:
11:00am - 12:30pm
Location:
Classroom 106 D
Audience:
  Library Employees     Public     UM Employee     UM Student  
Categories:
  Love Data Week     Workshop  

Event Organizer

Profile photo of Brian Young
Brian Young