Event box
Print the page
Add to a Calendar using iCal
Share page on Facebook
This link opens in a new window
Add to Google Calendar
This link opens in a new window
Share page on Twitter
This link opens in a new window
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