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. **
ABOUT THE SESSION:
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
Day 1: Thursday, 16th of July
1:30pm – 4:30pm
Day 2: Friday, 17th of July
9:30am – 12:30pm
WHO SHOULD ATTEND?
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 (
Please enter your full name.
Please enter your contact email address.
Please choose your college
ASSC Arts, Social Sciences and Commerce
Central / Other
SHE Science, Health and Engineering
Unknown College / Dept
What is your Department/School?
La Trobe Business School
La Trobe Law School
School of Education
School of Humanities and Social Sciences
La Trobe Rural Health School
School of Allied Health
School of Applied Systems Biology
School of Cancer Medicine
School of Engineering and Mathematical Sciences
School of Life Sciences
School of Molecular Sciences
School of Nursing and Midwifery
School of Psychology and Public Health
Internal - Non-school
Choose the category that best describes your career stage
Early Career Researcher
Graduate Researcher Student
Late Career Researcher
Masters by coursework student
Masters by research student
Choose the FoR code for your research area
01 Mathematical Sciences
02 Physical Sciences
03 Chemical Sciences
04 Earth Sciences
05 Environmental Sciences
06 Biological Sciences
07 Agricultural and Veterinary Sciences
08 Information and Computing Sciences
11 Medical and Health Sciences
12 Built Environment and Design
15 Commerce, Management, Tourism and Services
16 Studies in Human Society
17 Psychology and Cognitive Sciences
18 Law and Legal Studies
19 Studies in Creative Arts and Writing
20 Language, Communication and Culture
21 History and Archaeology
22 Philosophy and Religious Studies
How did you hear about this course (tick all that apply)?
Research office/division (website/email)
Intersect training mailing list
Word of mouth
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.