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.

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.

Whilst the online version of Excel provides basic functionality, some advanced pivot table features are only available to users in the Excel desktop application.

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.

• 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.