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.
DurationWe'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.
About 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.
Learning Outcomes
‘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
Intersect is an important part of Australia’s research infrastructure. We provide robust, innovative and collaborative technology to support world-class research at member and customer universities and other organisations.
We help researchers be more effective by providing them with highly advanced and specialised IT services and solutions.
In The Beginning
25 June 2008, Sydney Australia: A proposal for an “Institute for Trans-disciplinary eResearch Services & Technology” was approved by the DVCsR of the University of Sydney, Macquarie University, the University of NSW, Southern Cross University and the CEO of the Securities Industry Research Centre of Asia-Pacific (SIRCA).
A Board of Directors was appointed with Professor Mark Wainwright as Chair, Paul Martin as Secretary and Dr Michael Briers as interim CEO, and founding directors were John Shipp, John Masters, James Dalziel.
Intersect was incorporated as a not-for-profit company limited-by-guarantee, governed by a Constitution that grants NSW research institutions eligibility as members.
The Department of State and Regional Development (DSRD) approved a Science Leveraging Fund grant, which provided funding to Intersect over three years. Dr. Ian Gibson was appointed CEO and the initial goal of establishing a worldwide viable Intersect by mid-2008 was achieved.
Careers At Intersect
Intersect offers challenging work on a diverse range of projects that support leading edge research across disciplines. We are big on collaboration – sharing ideas and expertise and following the Agile Software Development methodology.
We provide a supportive environment in which you can learn and develop new skills. We work hard, but we also like to have fun!
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the USA, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan