Tidy up your data: Using MS Excel & Power Query to transform and organize your data
This workshop provides participants with a framework to recognize and tidy messy data, and some practical skills in Microsoft Excel and Microsoft Power Query to enable data collection in a tidy format, so that analysis is possible. Hands-on participants must have MS Excel (2019+) with Power Query.
Cairo Sanders is UVic Libraries Data Analyst supporting the Libraries with organizational analysis, including data collection and reporting.
This event is part of Love Data Week 2023, co-sponsored by SFU, UBC, UNBC, and UVic. Registration is open to everyone.
If you have questions, concerns, or accessibility needs please email research.commons@ubc.ca.
This event is online. Registrants will receive the link by email 1 day before the event.
- Date:
- Thursday, February 16, 2023
- Time:
- 1:00pm - 3:00pm
- Audience:
- All Faculty Graduate
- Categories:
- Data Research Commons
- Presenter(s):
- Cairo Sanders
Registration has closed.