Data

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

February 16, 2023, 1:00 pm to 3:00 pm

Date: Thursday, February 16, 2023
Time: 1:00pm - 3:00pm
Presenter: Cairo Sanders
Location: Online

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.

https://libcal.library.ubc.ca/event/3714766

  • Data
  • Research Commons

First Nations land acknowledegement

We acknowledge that UBC's two main campuses are located on the traditional, ancestral and unceded territories of the xwmə0– kwəyˇəm (Musqueam) and Syilx (Okanagan) peoples, and that UBC’s activities take place on Indigenous lands throughout British Columbia and beyond.

Research Data Management @ UBC

UBC Vancouver & UBC Okanagan
Vice-President, Research and Innovation | UBC Library | Office of the Chief Information Officer,
Website rdm.ubc.ca

UBC Crest The official logo of the University of British Columbia. Urgent Message An exclamation mark in a speech bubble. Caret An arrowhead indicating direction. Arrow An arrow indicating direction. Arrow in Circle An arrow indicating direction. Arrow in Circle An arrow indicating direction. Chats Two speech clouds. Facebook The logo for the Facebook social media service. Information The letter 'i' in a circle. Instagram The logo for the Instagram social media service. External Link An arrow entering a square. Linkedin The logo for the LinkedIn social media service. Location Pin A map location pin. Mail An envelope. Menu Three horizontal lines indicating a menu. Minus A minus sign. Telephone An antique telephone. Plus A plus symbol indicating more or the ability to add. Search A magnifying glass. Twitter The logo for the Twitter social media service. Youtube The logo for the YouTube video sharing service.