Event box

Intro to Data Analysis with Excel

Intro to Data Analysis with Excel In-Person / Online

Note: This workshop is a hybrid workshop and can be attended online or in person.

Are you a UVic student, staff, or faculty member and are interested in using Excel for data analysis? If so this workshop is for you. In this self-paced, hands-on workshop you can choose to learn any or all of the following skills:

  • How to enter the data (rows vs. columns)
  • How and when to use text to columns
  • How to sort data effectively, using the filter button
  • How to find and replace data (data cleaning) - Know about Open Refine.
  • How to change categorical data (e.g., male, female) into numerical data (e.g., 1, 2)
  • How to use these general functions: SUM, SUMIF, INT, COUNTA, COUNTIF, VLOOKUP, CONCATENATE, VALUE, LEN
  • How to track changes in excel
  • How to use these statistical functions: AVERAGE (Mean), Standard Deviation, MEDIAN, MODE, COUNT, Standardize, Sample Variance, Ketosis, Skew, MIN, MAX, Range 
  • Producing some basic graphs, histogram and scatterplot and how to edit them (e.g., add title, change axes names, colours, sizing etc)
  • How to create a basic pivot table
  • How to create a Key Indicator Digital Dashboard
Date:
Tuesday, June 28, 2022
Time:
2:00pm - 3:30pm
Time Zone:
Pacific Time - US & Canada (change)
Location:
Digital Scholarship Commons A308
Library:
Mearns Centre for Learning - McPherson Library (LIB)
Audience:
  Faculty     Graduate students     Undergraduate students     UVic staff  
Categories:
  DSC  
Registration has closed.

Event Presenter(s)

Rich McCue
Digital Scholarship Commons

More events like this...