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!
This course includes identity content for Azure AD, enterprise application registration, conditional access, identity governance, and other identity tools
We tailor these programs to suit your needs. If you are an individual looking for basic to intermediate training in Microsoft Word, Excel or Outlook we can assist.
Take your Word skills to the next level with one of our short online instructor led classes delivered remotely or book a trainer to visit your site. Let’s face it, today many Word users already have the skills to create a basic document, but when it comes to troubleshooting formatting and workin...
Microsoft Word Is one of the most used programs for the creation of business documents. Everything from a simple form to a complex 100-page proposal can be made using Microsoft Word.
This introductory course will give you a thorough grounding in the essentials of spreadsheets using Microsoft Excel. You will create, navigate and edit spreadsheet data and learn how to format it in a number of ways. You'll also sort and filter lists of data, create charts, manage rows and columns
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 UAE, UK, USA, India and South Africa, 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.
© 2024 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