Tidy up your data: Using MS Excel & Power Query to transform and organize your data Online
Tidy up your data: Using MS Excel & Power Query to transform and organize your data / Cairo Sanders (UVic)
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.
- Date:
- Thursday, February 16, 2023
- Time:
- 1:00pm - 3:00pm
- Time Zone:
- Pacific Time - US & Canada (change)
- Online:
- This is an online event.
- Event URL:
- https://libcal.library.ubc.ca/event/3714766
- Audience:
- Open to Everyone
For Love Data Week 2023, libraries at SFU, UBC, UNBC, and UVic are collaborating to offer a series of talks and workshops. All events will be hosted online via Zoom and registration is open to everyone. We look forward to seeing you soon! A full list of events can be found at the UBC Library Research Commons.
Image credit: Paul Lesack (UBC)