How confident are you in using digital tools to manage your research data? Intersect Australia will present a series of 3-hour workshops in February and March to help you improve how you use Excel and Python to manage and visualise complex data.
Managing data with Excel and Python
Excel for researchers
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.
Using Microsoft Excel, you’ll learn how to import, sort, filter, copy, protect, transform, summarise, merge, and visualise research data.
Aimed at novice Excel users, participants will walk away with new tricks to work more efficiently with their research data.
Register to attend:
- Session 1: Thursday, February 20 from 09:30 AM to 12:30 PM AEDT
- Session 2: Friday, February 21 from 09:30 AM to 12:30 PM AEDT
Beyond Basics: Conditionals and Visualisation in Excel
After cleaning your dataset, you may need to apply some conditional analysis to glean greater insights from your data. You may also want to enhance your charts for inclusion into a manuscript, thesis or report by adding some statistical elements.
This course will cover conditional syntax, nested functions, statistical charting and outlier identification.
Armed with the tips and tricks from the introductory Excel for Researchers course, you’ll be able to tap into even more of Excel’s diverse functionality and apply it to your research project.
Register to attend:
- Fri, 28 Feb 2025 9:30 AM - 12:30 PM AEDT
Learn to Program with Python
Python is a popular language for scientific computing. It has all the friendly features and conveniences you’d expect of a modern programming language and a rich set of libraries for working with data.
In this course you will discover Jupyter notebooks that allow program code, results, visualisations and documentation to be blended seamlessly. Perfect for sharing insights with others while producing reproducible research.
Register to attend:
- Session 1: Thursday, March 06 from 09:30 AM to 12:30 PM AEDT
- Session 2: Friday, March 07 from 09:30 AM to 12:30 PM AEDT
Data Manipulation and Visualisation in Python
In this workshop, you will explore DataFrames in depth (using the pandas library), learn how to manipulate, explore and get insights from your data (Data Manipulation), as well as how to deal with missing values and how to combine multiple datasets.
You will also explore different types of graphs and learn how to customise them using two of the most popular plotting libraries in Python, matplotlib and seaborn (Data Visualisation) using Jupyter notebooks.
Register to attend:
- Session 1: Thursday, March 13 from 09:30 AM to 12:30 PM AEDT
- Session 2: Friday, March 14 from 09:30 AM to 12:30 PM AEDT