Intersect Online Training: Excel for Researchers

Event Name
Intersect Online Training: Excel for Researchers
4 November 2021
09:30 am - 12:30 pm

Address (Room): Zoom


This course runs over two days. You must attend both days to complete the course. Zoom link will be sent to you closer to the training day.

Part 1: Thursday, 4 November 2021, 9:30 AM – 12:30 PM

Part 2: Friday, 5 November 2021, 9:30 AM – 12:30 PM

In order to participate in this course, you must have Excel installed on your computer. For Western Sydney University researchers, you can contact Jeff Wang ( for help on installing Excel.

Why do this course?

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.

You’ll learn to:

- ‘Clean up’ messy research data

- Organise, format and name your data


- 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

Speakers: Intersect Trainers

Web page:

Name: Jeff Wang

Phone: 0456 269 623

School / Department: Research Services