Skip Main Navigation
Page Content

Save This Event

Event Saved

Excel Fu for Researchers (Melbourne Campus)

Digital Research Team

Monday, 12 December 2016 from 9:30 AM to 4:30 PM (AEDT)

Excel Fu for Researchers (Melbourne Campus)

Registration Information

Type Remaining End Quantity
General 21 Registrations 01/12/2016 Free  

Share Excel Fu for Researchers (Melbourne Campus)

Event Details




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. 



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.


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.


All researchers and research students

Have questions about Excel Fu for Researchers (Melbourne Campus)? Contact Digital Research Team

Save This Event

Event Saved

When & Where

HS3 401 Computer Lab (Map Ref: E6)
La Trobe University


Monday, 12 December 2016 from 9:30 AM to 4:30 PM (AEDT)

  Add to my calendar


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
  Contact the Organiser
Excel Fu for Researchers (Melbourne Campus)
Class Other

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.