Event box

Data Analysis with Excel

Data Analysis with Excel Online

Note: This workshop is online only.

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 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
  • Create a pivot table
  • Create a basic macro to automate a task
  • Create a Key Indicator Digital Dashboard

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: https://onlineservices.uvic.ca/ (Note: If you are a staff member at UVic and are wanting to install software on a work computer, you may require system admin permission to do so.)

Date:
Tuesday, November 19, 2024
Time:
2:30pm - 4:00pm
Time Zone:
Pacific Time - US & Canada (change)
Online:
This is an online event. Event URL will be sent via registration email.
Audience:
  Faculty     Graduate students     Undergraduate students     UVic staff  
Categories:
  DSC  

Registration is required. There are 26 seats available.

More events like this...