Getting Started with Excel

We rarely receive the research data in an appropriate form. Often data is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors.

This webinar targets beginners and presents a quick demonstration of using the most widespread data wrangling tool, Microsoft Excel, to sort, filter, copy, protect, transform, aggregate, summarise, and visualise research data.

You'll learn:

  • Introduction to Microsoft Excel user interface
  • Interpret data using sorting, filtering, and conditional formatting
  • Summarise data using functions
  • Analyse data using pivot tables
  • Manipulate and visualise data
  • Handy tips to speed up your work

Prerequisites:

The webinar has no prerequisites.

For more information, please click here.

Licence: All Rights Reserved

Contact: training@intersect.org.au

Keywords: Data Analysis, Excel


Additional information

Status: Active

Getting Started with Excel https://dresa.org.au/materials/getting-started-with-excel We rarely receive the research data in an appropriate form. Often data is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors. This webinar targets beginners and presents a quick demonstration of using the most widespread data wrangling tool, Microsoft Excel, to sort, filter, copy, protect, transform, aggregate, summarise, and visualise research data. #### You'll learn: - Introduction to Microsoft Excel user interface - Interpret data using sorting, filtering, and conditional formatting - Summarise data using functions - Analyse data using pivot tables - Manipulate and visualise data - Handy tips to speed up your work #### Prerequisites: The webinar has no prerequisites. **For more information, please click [here](https://intersect.org.au/training/course/excel001).** training@intersect.org.au Data Analysis, Excel