A DIGITAL RESEARCH INITIATIVE - A collaboration between the Office of the DVC(R), ICT and the Library, La Trobe’s Digital Research Strategy aims to provide a world-class digital research environment to enable and accelerate new research outcomes through the engagement of researchers with advanced and emerging information and computing technologies and appropriate support services.
ABOUT THIS SESSION:
This intensive workshop runs over one day and comprises a series of hands-on exercises modelled around a mock research project. This module is targeted at researchers who would like to take a deep dive into using Excel, either to apply it to their research or to add it to their arsenal of Digital Research skills. This workshop is presented by our partners, Intersect Australia Limited.
How to handle research data within Excel.
How to use advanced features of Excel to answer research questions pertaining to their data.
This workshop presumes a basic knowledge of Excel.
WHY SHOULD I ATTEND?
The potential uses for material covered in this course are:
Utilisation of data from other sources – More and more data is being made available by Government agencies for use by researchers. If you have a text file with semi-structured data, you can edit it by adding meaningful names and formatting to make the data appropriate for analysis.
Learn how to use Excel features to interrogate your data – min, max, average, vlookup, sorting, filtering, conditional formatting, pivot tables, data validation.
Learn how to answer your research questions using Excel functions on your existing research data.
Learn best practices on how to manipulate and transform your research data without destroying the original copy of your data.
WHO SHOULD ATTEND?
All researchers and research students
Save This Event
When & Where
Digital Research Team
La Trobe's Digital Research Strategy aims to:
- Enable researchers to actively engage with information and computing technologies
- Develop Digital Research expertise among researchers within the University
- Proactively enhance institutional research capabilities
- Maximise the use and enable proper management and curation of research data