Free

Excel Fu for Researchers (Albury Wodonga Campus)

Event Information

Share this event

Date and Time

Location

Location

AW-3A-3A4

La Trobe University

Albury Wodonga

Australia

View Map

Event description

Description

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


Share with friends

Date and Time

Location

AW-3A-3A4

La Trobe University

Albury Wodonga

Australia

View Map

Save This Event

Event Saved