Loading Events

« All Events

  • This event has passed.

Tidy up your data: Using MS Excel & Power Query to transform and organize your data

February 16, 2023 @ 1:00 pm - 3:00 pm


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 receive the link 1 hour before the event (registration closes 2 hours before).