Excel for Researchers Online
This course takes place over 2 days. The dates and times are as follows:
Day 1: Thursday, June 27 from 9:30 AM to 12:30 PM AEST
Day 2: Friday, June 28 from 9:30 AM to 12:30 PM AEST
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.
What's covered:
- ‘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.
Enquiries: Jeff Wang
- Date:
- Thursday, June 27, 2024
- Time:
- 9:30am - 12:30pm
- Time Zone:
- Sydney, Melbourne (change)
- Online:
- This is an online event.
- Event URL:
- https://www.eventbrite.com.au/e/excel-for-researchers-at-western-sydney-online-registration-900777649197
- Audience:
- Academics & researchers Post-graduate students Western staff
- Categories:
- Training Sessions
Time Zone: Sydney, Melbourne (change)
Brain Breaks activities @ the Library In-Person
- Date:
- Tuesday, May 21, 2024
- Time:
- 9:30am - 5:00pm
- Location:
- WSU
- Audience:
- Undergraduate Students Post-graduate students General Interest New to WSU
- Categories:
- Community Events Student Activities
Brain Breaks activities @ the Library In-Person
- Date:
- Wednesday, May 22, 2024
- Time:
- 9:30am - 5:00pm
- Location:
- WSU
- Audience:
- Undergraduate Students Post-graduate students General Interest New to WSU
- Categories:
- Community Events Student Activities
Brain Breaks activities @ the Library In-Person
- Date:
- Thursday, May 23, 2024
- Time:
- 9:30am - 5:00pm
- Location:
- WSU
- Audience:
- Undergraduate Students Post-graduate students General Interest New to WSU
- Categories:
- Community Events Student Activities
Brain Breaks activities @ the Library In-Person
- Date:
- Friday, May 24, 2024
- Time:
- 9:30am - 5:00pm
- Location:
- WSU
- Audience:
- Undergraduate Students Post-graduate students General Interest New to WSU
- Categories:
- Community Events Student Activities
Time Zone: Sydney, Melbourne (change)
Fact or Fiction? Developing Critical Thinking Skills In-Person
- Date:
- Wednesday, June 5, 2024
- Time:
- 10:00am - 11:30am
- Location:
- Bankstown City Campus, Bankstown
- Audience:
- Undergraduate Students Post-graduate students New to WSU
- Categories:
- Reading & Writing Training Sessions
- Registration Type:
- In-Person Registration
- Register! - 27 seats left
How to Write Well at Uni: Punctuation In-Person
- Date:
- Wednesday, June 5, 2024
- Time:
- 11:30am - 1:00pm
- Location:
- Bankstown City Campus, Bankstown
- Audience:
- Undergraduate Students Post-graduate students New to WSU
- Categories:
- Reading & Writing Training Sessions
- Registration Type:
- In-Person Registration
- Register! - 23 seats left
How to Write an Essay at Uni In-Person
- Date:
- Wednesday, June 5, 2024
- Time:
- 3:30pm - 5:00pm
- Location:
- Bankstown City Campus, Bankstown
- Audience:
- Undergraduate Students Post-graduate students New to WSU
- Categories:
- Reading & Writing Training Sessions
- Registration Type:
- In-Person Registration
- Register! - 29 seats left