Skip Main Navigation
Page Content

Save This Event

Event Saved

Excel Fu for Researchers (Mildura Campus)

Digital Research Team

Thursday, 17 August 2017 from 9:30 am to 4:30 pm (AEST)

 Excel Fu for Researchers (Mildura Campus)

Registration Information

Type Remaining End Quantity
General 13 Registrations 16/08/2017 Free  

Share Excel Fu for Researchers (Mildura 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. 

 

ABOUT THIS SESSION:

Do you have large amounts of data that is messy, incomplete and contains errors?

During this workshop you will learn how to use 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

PLEASE NOTE:
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


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

Save This Event

Event Saved

When & Where


TBC
La Trobe University
Mildura
Australia

Thursday, 17 August 2017 from 9:30 am to 4:30 pm (AEST)


  Add to my calendar

Organiser

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 (Mildura Campus)
Things to do in Mildura 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.