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