Excel for Researchers at UNSW Kensington

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

<P><SPAN>Please note that the venue is not fitted with Desktop PCs. Please </SPAN><STRONG>bring your own laptop</STRONG><SPAN> to this training course.</SPAN></P>
<H2><BR></H2>
<H2>Why do this course?</H2>
<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>
<H2>Who should take this course?</H2>
<P>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.</P>
<H2>You'll learn how to:</H2>
<UL>
<LI>
<P>Find, import and ‘clean up’ messy research data</P>
</LI>
<LI>
<P>Organise, format and name your data in Excel</P>
</LI>
<LI>
<P>Analyse your data (answer research questions)</P>
</LI>
<LI>
<P>Interpret your data (filtering, conditional formatting)</P>
</LI>
<LI>
<P>Perform calculations on your data (max, min, average)</P>
</LI>
<LI>
<P>Extract significant findings from your data (pivot tables)</P>
</LI>
<LI>
<P>Manipulate your data (data conversion, dates and times)</P>
</LI>
<LI>Create graphs and charts to visualise your data</LI>
</UL>
<H2>The Intersect approach to training</H2>
<P>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. </P>
<P><SPAN>For more information about </SPAN><A HREF="https://inter.fyi/course/excel101" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">this course</A><SPAN> and others, see our </SPAN><A HREF="https://intersect.org.au/training/courses" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">course catalogue</A><SPAN>, or visit </SPAN><STRONG><A HREF="http://learn.intersect.org.au" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Learn.intersect.org.au</A></STRONG></P>

UNSW Kensington

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Excel for Researchers at UNSW Kensington

More events from Intersect Australia

Follow organisers to get events picked for you

Excel for Researchers at UNSW Kensington

More events from Intersect Australia

Follow organisers to get events picked for you

You might also like...

Sign in for personalised recommendations