Print the page
Add to a Calendar using iCal
Share page on Facebook
Add to Google Calendar
Share page on Twitter
RDM Essentials - Data Cleanup Using Excel Online
We’ve all been there — missing values and rogue inputs in our dataset. And who could forget data that should be in multiple cells squished into a single cell or multiple cells’ data that should really be in one cell. In this session, we’ll dive into practical, anxiety-lowering tips for cleaning up messy qualitative data in Excel.
This fast-paced workshop is meant for students who have basic to intermediate Excel knowledge. We will all work off a common Excel file filled with messy data and learn how to clean it up during the session.
Participants will learn how to:
- transform text to all lower case, all upper case and title case
- remove trailing blank spaces to fix comparability issues
- join data from multiple cells into a single cell
- separate data from a single cell into individual cells
- deal with missing values in your data (time permitting)
- use Data Validation to force Excel to accept only validated entries (time permitting)
- Date:
- Tuesday, October 6, 2026
- Time:
- 12:00PM - 12:30PM
- Time Zone:
- Atlantic Time (change)
- Location:
- 316 - Innovation Hub
- Campus:
- Fredericton
- Audience:
- Faculty/Staff Students
- Online:
- This is an online event. Event URL will be sent via registration email.