Advanced Excel for Research Data (Aug 2026)

By the end of this workshop, participants will be able to effectively store and export data to and from Microsoft Excel, and be able to explore their data using its functions and capabilities. Participants will learn best practices in spreadsheeting for a research context, and learn important quality of life features in Excel. Participants will also learn how to use formulas to perform statistical analysis and will be familiar with advanced functions such as xlookup and concatenate. Participants will also learn how to use pivot tables and pivot charts to explore data patterns, and how to use advanced functions and addins such as Power Query and the Data Analysis Toolpak to perform more advanced analyses and functions.

FAQs

What should I bring into the event?

This is an online workshop, so you will need to provide your own computer and have access to a reliable internet connection sufficient for video conferencing. Microsoft Excel desktop application is preferred, though online app will work.

What prior experience do I need?

Basic experience with Microsoft Excel is recommended.

Who should attend?

This workshop is relevant for all researchers, HDR (Higher Degree by Research) students and research support staff.

How can I contact the organiser with any questions?

You can email training@qcif.edu.au

What's the cancellation policy?

Cancellations are accepted up to three working days before the start of the workshop. If you do not join on the day without having cancelled beforehand, you may be blocked from attending any future QCIF training workshops.