Mastering Excel Pivot Tables
Master data processing using pivot tables
Processing a large data set can be daunting. With the help of Excel pivot tables, you can convert masses of complex data into digestible chunks of information presented in visually powerful ways.
On this four-week course from the University of Adelaide, you’ll gain the technical skills you need to use Excel pivot tables. From tidying data to creating visualisations and telling a story, you’ll expand your expertise in data analysis.
Practise interpreting and visualising data using Excel pivot tables
From Week 1 of the course, you’ll get stuck into practising with pivot tables.
You’ll start by learning how to create a neat, tidy, and visually appealing pivot table. This will help to enhance your data visualisation skills.
Develop your skills in data analytics for business
The focus of this course is on using data analytics to measure and drive business performance.
In the third week of the course, you’ll discover how pivot tables can be used to calculate key business metrics. You can use these metrics to boost your own organisation’s results.
Learn how to tell a compelling story using data
Once you know how to build and navigate a pivot table, you can begin learning how to interpret the results. The fourth and final week of the course will look at how data in a table can be used to tell a story.
By the end of course, you’ll be a confident user of Excel pivot tables and a storyteller able to harness data for your business.
Learning on this course
On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.
What will you achieve?
By the end of the course, you‘ll be able to...
- Demonstrate the creation and styling of a variety of pivot tables.
- Apply updates and filtering options to pivot tables.
- Calculate custom fields and apply pivot table connections.
- Discuss sophisticated and dynamic data visualisations from pivot tables.
Who is the course for?
This course is designed for anyone working in or aspiring to a role that requires them to present or analyse data on behalf of their organisation.
Learners are not expected to have used pivot tables previously, but they should have some experience of Excel.
Who developed the course?
World rankingTop 110Source: QS World University Rankings 2023
Do you know someone who'd love this course? Tell them about it...
Learners who joined this course have also enjoyed these courses.