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
Excel for Researchers at WSU Online Online
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.
Enquires: Dr Jeff Wang
Register: www.eventbrite.com.au/e/excel-for-researchers-at-wsu-online-registration-1334879734219
- From:
- 9:30am, Thursday, May 29, 2025
- To:
- 12:45pm, Friday, May 30, 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-1334879734219
- Audience:
- Academics & researchers Western staff
- Categories:
- Training Sessions
Time Zone: Sydney, Melbourne (change)
Exhibition: Artworks from Dr Shannon Foster
Exhibition at Campbelltown Campus Library
Did you know there are exhibition spaces at Penrith and Campbelltown Campus libraries? Western Sydney University students and staff are invited to showcase...
More
- From:
- 8:00am, Tuesday, April 1, 2025
- To:
- 9:00pm, Thursday, May 15, 2025
- Location:
- Campbelltown
- Audience:
- Undergraduate Students Post-graduate students Western staff General Interest Academics & researchers New to WSU Future students
- Categories:
- Community Events
Exhibition: Spirit & Sound In-Person
This exhibition highlights Associate Professor Bruce Crossman’s works, Heaven to Earth Border House Project, and Gyeonggye: Border as well as performances of his works by friends and collaborators....
More
- From:
- 8:00am, Friday, April 25, 2025
- To:
- 5:00pm, Saturday, May 10, 2025
- Location:
- Penrith Campus, Penrith
- Audience:
- Undergraduate Students Post-graduate students Western staff General Interest Academics & researchers
- Categories:
- Community Events
Understanding Diabetes and Pasifika Community Research - Professor Freya MacMillan and Afioga Salā Ronda Thompson In-Person / Online
Australia has a significant number of immigrants from the Pacific Islands. According to the 2016 census, 75,755 people are of Samoan heritage and more than 40% of them live in New South Wales. Samoans...
More
- Date:
- Tuesday, May 6, 2025
- Time:
- 1:00pm - 2:00pm
- Location:
- Campbelltown Campus, Campbelltown
- Audience:
- Post-graduate students Western staff General Interest Academics & researchers
- Categories:
- Thought Leadership Events
- Registration Type:
- In-Person Registration / Online Registration
- Register! - 92 seats left
Insult to Injury: Gendered, Racial and Epistemic Violence Against Migrant Women of Colour - Dr Selda Dagistanli In-Person / Online
Dr Selda Dagistanli researches "cultures of abuse" and the racialisation of gendered violence, multicultural politics, racism, cultural diversity and the law through a critical analysis of legal and...
More
- Date:
- Thursday, May 29, 2025
- Time:
- 12:00pm - 1:00pm
- Location:
- Parramatta City Campus, Parramatta City
- Audience:
- Post-graduate students Western staff General Interest Academics & researchers
- Categories:
- Community Events Thought Leadership Events
- Registration Type:
- In-Person Registration / Online Registration
- Register! - 232 seats left
Mapping the Landscape of Optometric Education in Sub-Saharan Africa Online
Optometry is a vital healthcare profession dedicated to the care of people’s eyes and vision. Optometrists serve as the primary eye care providers — they assess visual function, manage refractive and...
More
- Date:
- Wednesday, June 18, 2025
- Time:
- 4:30pm - 6:00pm
- Audience:
- Undergraduate Students Post-graduate students Western staff General Interest Academics & researchers New to WSU Future students
- Categories:
- Thought Leadership Events
- Registration Type:
- Online Registration
- Register! - 199 seats left
Time Zone: Sydney, Melbourne (change)
Literature review language basics In-Person
Workshop location: BK-1.1.31
Want to master the art of writing a literature review?
This workshop, "Literature Review Basics," will introduce you to the fundamental purpose and structure of a...
More
- Date:
- Friday, May 16, 2025
- Time:
- 11:30am - 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!
How to write a report at uni In-Person
Workshop location BK-1.1.31
Struggling to keep up with your academic reading?
Join us for "Academic Reading: Making the Most of Your Time and Resources," where you'll learn effective techniques to...
More
- Date:
- Friday, May 16, 2025
- Time:
- 2:00pm - 3:30pm
- 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! - 36 seats left
How to write well at uni: common grammar errors In-Person
Do you struggle with common grammar errors that undermine your academic writing?
Join us for "How to Write Well at Uni: Common Grammar Errors," where you'll refresh your understanding of frequent...
More
- Date:
- Thursday, July 10, 2025
- Time:
- 10:00am - 11:30am
- 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! - 25 seats left
How to write well at uni: sentence structure In-Person / Online
Are you looking to improve your sentence structure for clearer academic writing?
Join us for "How to Write Well at Uni: Sentence Structure," where you'll refresh your knowledge of grammar and learn...
More
- Date:
- Thursday, July 10, 2025
- Time:
- 11:30am - 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 / Online Registration
- Register! - 83 seats left
Think! Question! Evaluate! Generate new ideas In-Person
Are you ready to sharpen your critical thinking skills and learn how to evaluate ideas?
Join us for "Think! Question! Evaluate! Generate new ideas," where you'll learn essential techniques to enhance...
More
- Date:
- Tuesday, July 22, 2025
- Time:
- 5:00pm - 6:30pm
- 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! - 39 seats left