Description:

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.

You'll learn:

  • 'Clean up’ messy research data
  • Organise, format and name your data
  • Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING)
  • Perform calculations on your data using functions (MAX, MIN, AVERAGE)
  • Extract significant findings from your data (PIVOT TABLE, VLOOKUP)
  • Manipulate your data (convert data format, work with DATES and TIMES)
  • Create graphs and charts to visualise your data (CHARTS)
  • Handy tips to speed up your work

Prerequisites:

In order to participate, attendees must have a licensed copy of Microsoft Excel installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software.

For more information, please click here.

Start: Wednesday, 12 October 2022 @ 09:30

End: Wednesday, 12 October 2022 @ 12:30

Timezone: Sydney

 Country: Australia

Eligibility:
  • Host institutions

Organiser: Intersect Australia

Contact: training@intersect.org.au

Host institution: UNE

Excel for Researchers at UNE Online https://dresa.org.au/events/excel-for-researchers-at-une-online-c1d0c270-e1dd-4b1a-b283-8a4a1dadbfd0 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. #### You'll learn: - 'Clean up’ messy research data - Organise, format and name your data - Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING) - Perform calculations on your data using functions (MAX, MIN, AVERAGE) - Extract significant findings from your data (PIVOT TABLE, VLOOKUP) - Manipulate your data (convert data format, work with DATES and TIMES) - Create graphs and charts to visualise your data (CHARTS) - Handy tips to speed up your work #### Prerequisites: In order to participate, attendees must have a licensed copy of Microsoft Excel installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software. **For more information, please click [here](https://intersect.org.au/training/course/excel101).** 2022-10-12 09:30:00 UTC 2022-10-12 12:30:00 UTC Intersect Australia Australia Australia UNE training@intersect.org.au [] [] [] host_institution []