Pre-Workshop Videos & Activities

This workshop is primarily hands-on practice with Excel and Power Query in order to learn to use key features of the software. To participate fully please do the following before the workshop:

Video [9 minutes]

• OPTIONAL - How Power Query Will Change the Way You Use Excel (9 min)
  

Video [4 minutes]

• OPTIONAL - Principles of tidy data (9 min)
  

Downloads [5-10 minutes]

• If you don’t have the latest version of Microsoft Excel, you can request a UVic licensed and paid-for version of Office 365 here POWER QUERY IS ONLY ON EXCEL 2019
  - Then download the Office installer here
  - Please login with your UVic NetLink ID credentials. Please note that you will need to enter in your NetLinkID@uvic.ca, and not just your NetLinkID.

NEXT STEP: Introduction to Hands-On Activities

---