Excel Fu for Researchers (Melbourne Campus)
Monday, 12 December 2016 from 9:30 am to 4:30 pm (AEDT)
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:
Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. 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. This workshop is presented by our partners, Intersect Australia Limited.
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
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
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