This free course is being offered by UNSW for researchers and research students, and will provide tips in utilising Microsoft Excel more efficiently when working with your research data.
In this course you will 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 course will be delivered by Intersect and held in Wallace Wurth Computer Lab G16-G17 (map ref C27).
Click here for further information and to register.
Additional courses: are being offered by UNSW throughout the year and course overviews are available on the eResearch Training Resources website.
UNSW researchers are also permitted to attend Intersect-run courses at any of the Intersect member institutions or alternatively if you would like to run a dedicated course offered by Intersect for your team please contact: DVR Infrastructure at firstname.lastname@example.org.
Event open only to UNSW Staff & Students