- This event has passed.
Excel for Researchers
November 30, 2021 @ 9:30 am - 4:30 pm AEDT
About this event
Promo codes
To celebrate the launch of this new service, for a limited time Intersect is offering discounts to all registrants! Choose the applicable code from below to receive up to save up to 50% off the regular price of $640!
- Use code EARLYINTRO-HDR and pay only $320
- Use code EARLYINTRO and pay only $420
- Use code INTRO-HDR and pay only $480
All prices listed are excluding GST.
Need to pay by invoice? You can now generate your own invoice directly in Eventbrite – just select “Pay by Invoice” during checkout.
Discount codes (except INTRO-HDR) are available for registrations completed 2 weeks prior to the scheduled course date. To be eligible for HDR discounts, you must register using your institution issued student email address.
Information 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.
You’ll learn to:
- ‘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
The Intersect approach to training
At Intersect, we deliver hands-on courses that targets the day-to-day software and technology problems that researchers face.
For more information about this course and others, see our course catalogue, or visit Learn.intersect.org.au
For more information about how we allocate tickers and address no-shows, see our training policy.