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. If you have previously attended our Intro to Data Analysis with Excel workshop, you can join us to continue with the intermediate exervises. 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
  • 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, March 12, 2024
Time:
10:30am - 12: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 has closed.

More events like this...

 

Event Presenter(s)

Digital Scholarship Commons