EXCEL101: Excel For Researchers

Authors: Dr Jeff (Xingyong) Wang, Dr Jianzhou Zhao
Course Duration: Full Day

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.

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 (SORTINGFILTERINGCONDITIONAL FORMATTING)
  • Perform calculations on your data using functions (MAXMINAVERAGE)
  • Extract significant findings from your data (PIVOT TABLEVLOOKUP)
  • 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

The course has no prerequisites.

Licence

Copyright © 2021 Intersect Australia Ltd. All rights reserved.

Introductory Slides

Get Started

For enquiries, please contact us at enquiries@intersect.org.au or visit help.intersect.org.au

Get Started