Excel for Researchers - Expression of Interest - Thu 16 & Fri 17 Jul 2020
** In accordance with La Trobe University's COVID-19 response, this training will be delivered online via Zoom. **


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.

Please note that places are limited.

EoI applications close on Thu Jul 09 2020 and applicants will be notified by Thu Jul 09 2020 whether their application has been successful.

You'll learn how to:

- Find, import and ‘clean up’ messy research data
- Organise, format and name your data in Excel
- Analyse your data (answer research questions)
- Interpret your data (filtering, conditional formatting)
- Perform calculations on your data (max, min, average)
- Extract significant findings from your data (pivot tables)
- Manipulate your data (data conversion, dates and times)
- Create graphs and charts to visualise your data

The detailed course outline can be found at https://goo.gl/TA6k3L


Day 1: Thursday, 16th of July
1:30pm – 4:30pm

Day 2: Friday, 17th of July
9:30am – 12:30pm


All researchers and research students.

This is one of the workshops offered through the Digital Research training program which aims to develop researchers’ digital literacy skills. Further support and resources can be found on the Digital Research website (https://goo.gl/4TGHjF).
Please enter your full name. *
Please enter your contact email address. *
Please choose your college *
What is your Department/School? *
Choose the category that best describes your career stage *
Choose the FoR code for your research area *
How did you hear about this course (tick all that apply)?
How much do you expect this workshop would help in your research (scale 1-10)? *
Please provide a paragraph explaining why this workshop is relevant to your work *
Never submit passwords through Google Forms.
This form was created inside of Intersect Australia Limited. Report Abuse