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.