Free

Excel for Researchers at USYD Online

Event Information

Share this event

Date and Time

Location

Location

Online Event

Event description
Learn Excel to support research.

About this Event

This training program is supported by the Deputy Vice Chancellor (Research) of the University of Sydney. Placements will be prioritised for researchers and research students at the University of Sydney. Registrants who are not researchers or research students at the University of Sydney may be moved to the waitlist. Thank you for your understanding. Please keep an eye on the Intersect website for upcoming courses at your home institution.

This course has two sessions:

  • 9:30 am - 12:45 pm on 4 Nov
  • 9:30 am - 12:45 pm on 5 Nov

An optional technical support on setting up Excel will start at 9 am on 4 Nov.

Why do this course?

Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And 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.

Who should take this course?

This course is suitable for all researchers and research students from any discipline. The course will use a sample dataset from meteorology to demonstrate Excel's features and produce charts, but the techniques taught will be applicable to any field.

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

The Intersect approach to training

At Intersect, we work closely with our member universities to develop and deliver training that targets the day-to-day software and technology problems that researchers face. We deliver hands-on courses in a relaxed setting with knowledgeable, helpful trainers who are themselves researchers and who know how researchers work. 

For more information about this course and others, see our course catalogue, or visit Learn.intersect.org.au

Date and Time

Location

Online Event

Save This Event

Event Saved