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://intersect.org.au/training/course/excel001
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