Excel for Researchers at UC Online

Intersect is a pivotal part of Australian research landscapeWe provide robust, innovative services and collaborative technology to support world-class research at our member organisations and in the wider research communityIntersect delivers data storage, compute and analysis platforms, custom engineering, expert consulting and training programs to thousands of researchers every yearIntersect works closely with the ARDC (Australian Research Data Commons) built from ANDS, Nectar, and RDSIntersect is a member of the Software Carpentry Foundation, the NCI (National Computational Infrastructure) and the AAF (Australian Access Federation)

Intersect Australia

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.

<h3>Important:</h3><p>This course takes place over 2 days. The dates and times are as follows:</p><ul><li>Day 1: Tuesday, February 14 from 1:30 PM to 4:30 PM AEDT</li><li>Day 2: Wednesday, February 15 from 1:30 PM to 4:30 PM AEDT</li></ul><p></p><p>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.</p><p>While aimed at novice Excel users, most attendees will walk away with new tricks to work more efficiently with their research data.</p><p></p><h3>You'll learn:</h3><ul><li>‘Clean up’ messy research data</li><li>Organise, format and name your data</li><li>Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING)</li><li>Perform calculations on your data using functions (MAX, MIN, AVERAGE)</li><li>Extract significant findings from your data (PIVOT TABLE, VLOOKUP)</li><li>Manipulate your data (convert data format, work with DATES and TIMES)</li><li>Create graphs and charts to visualise your data (CHARTS)</li><li>Handy tips to speed up your work</li></ul><p></p><p></p><h3>Prerequisites:</h3><p>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.</p><p></p><p></p>

Excel for Researchers at UC Online

More events from Intersect Australia

Follow organisers to get events picked for you

Excel for Researchers at UC Online

More events from Intersect Australia

Follow organisers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.