Excel for Researchers at WSU Online Online
Important:
This course takes place over multi-sessions. The dates and times are as follows:
- Session 1: Thursday, September 04 from 09:30 AM to 12:30 PM AEST
- Session 2: Friday, September 05 from 09:30 AM to 12:30 PM AEST
Overview:
Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And sometimes there’s too much of it. Frequently, it has errors. We’ll use one of the most widespread data wrangling tools, Microsoft Excel, to import, sort, filter, copy, protect, transform, summarise, merge, and visualise research data. While aimed at novice Excel users, most attendees will walk away with new tricks to work more efficiently with their research data.
‘Clean up’ messy research data Organise, format and name your data Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING) Perform calculations on your data using functions (MAX, MIN, AVERAGE) Extract significant findings from your data (PIVOT TABLE, VLOOKUP) Manipulate your data (convert data format, work with DATES and TIMES) Create graphs and charts to visualise your data (CHARTS) Handy tips to speed up your work
Prerequisites:
In order to participate, attendees must have a licensed copy of Microsoft Excel installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software.
- From:
- 9:30am, Thursday, September 4, 2025
- To:
- 12:30pm, Friday, September 5, 2025
- Time Zone:
- Sydney, Melbourne (change)
- Online:
- This is an online event.
- Event URL:
- https://www.eventbrite.com.au/e/excel-for-researchers-at-wsu-online-registration-1489814337789
- Audience:
- Academics & researchers Post-graduate students Western staff
- Categories:
- Training Sessions
Time Zone: Sydney, Melbourne (change)
Exhibition: Butterfly Elf, What's Your Favourite Nectar? - Professor James H. Yang In-Person
- From:
- 8:00am, Friday, August 8, 2025
- To:
- 5:00pm, Sunday, September 21, 2025
- Location:
- Penrith Campus, Penrith
- Audience:
- Undergraduate Students Western staff General Interest Academics & researchers
- Categories:
- Community Events
Exhibition: Anatomy Art Competition In-Person
- From:
- 9:00am, Wednesday, August 27, 2025
- To:
- 9:00pm, Sunday, October 5, 2025
- Location:
- Campbelltown Campus, Campbelltown
- Audience:
- Undergraduate Students Post-graduate students Western staff General Interest Academics & researchers New to WSU Future students
- Categories:
- Community Events First Nations Events Future Students Student Activities
Exhibition: Butterfly Elf, What's Your Favourite Nectar? - Professor James H. Yang In-Person
- From:
- 8:00am, Monday, September 22, 2025
- To:
- 5:00pm, Tuesday, September 30, 2025
- Location:
- Penrith Campus, Penrith
- Audience:
- Undergraduate Students Post-graduate students Western staff General Interest Academics & researchers Future students
- Categories:
- Community Events
Reducing Inequalities through Financial Literacy - Associate Professor Michelle Cull In-Person / Online
- Date:
- Wednesday, October 22, 2025
- Time:
- 1:00pm - 2:00pm
- Location:
- Parramatta City Campus, Parramatta City
- Audience:
- Undergraduate Students Post-graduate students General Interest Academics & researchers
- Categories:
- Community Events Thought Leadership Events
- Registration Type:
- In-Person Registration / Online Registration
- Register! - 205 seats left
A Storybook of Culling - Associate Professor David R. Cole In-Person / Online
- Date:
- Monday, November 10, 2025
- Time:
- 12:00pm - 1:00pm
- Location:
- Parramatta City Campus, Parramatta City
- Audience:
- Post-graduate students Western staff General Interest
- Categories:
- Thought Leadership Events
- Registration Type:
- In-Person Registration / Online Registration
- Register! - 129 seats left
Time Zone: Sydney, Melbourne (change)
Literacy for LANTITE Workshop: Strategies to Prepare In-Person
- Date:
- Tuesday, September 30, 2025
- Time:
- 12:00pm - 1:00pm
- Location:
- Bankstown City Campus, Bankstown
- Audience:
- Undergraduate Students Post-graduate students Western staff General Interest Academics & researchers New to WSU Future students
- Categories:
- Training Sessions
- Registration Type:
- In-Person Registration
- Register! - 40 seats left
