Excel: Introduction to Data Analysis
In this self-paced, hands-on introduction to data analysis with Excel, workshop participants learned to perform various data analysis tasks which are outlined below in the "earning criteria."
Issued on 20 Mar 2026 by
University of Victoria Libraries Digital Scholarship Commons
Issuer
University of Victoria Libraries Digital Scholarship Commons
dscommons@uvic.ca
The UVic Libraries Digital Scholarship Commons helps the UVic community pursue their passions and tell their research stories in engaging ways. We offer workshops and help with data analysis software, generative AI tools 3D printers, laser cutters, and more. The DSC provides a welcoming and inclusive space for the UVic community.
Criteria
Participants completed the following Excel tasks and activities:
- Enter date data into rows & columns
- Name and identify rows & columns
- Sort data, using the filter button
- Find and replace data (data cleaning) & know when Open Refine would be a more appropriate tool.
- Change categorical data (e.g., male, female) into numerical data (e.g., 1, 2)
- Use the following functions: SUM, SUMIF, INT, COUNTA, COUNTIF, VLOOKUP, CONCATENATE, VALUE, LEN.
- Track changes in excel
- Use these statistical functions: AVERAGE (Mean), Standard Deviation, MEDIAN, MODE, COUNT, Standardize, Sample Variance, Kurtosis, Skew, MIN, MAX, Range.
- Produce basic graphs, histograms and scatter plots and edit them (e.g., add title, change axes names, colours, sizing etc)
Workshop website: https://uviclibraries.github.io/excel/#introductory-excel
