Mastering Excel Pivot Tables
Enhance your data analysis skills and harness the potential of Excel pivot tables to measure business performance.
| Length | 4 weeks |
|---|---|
| Effort | 1 hour per week |
| Start date | Start studying as soon as you enrol |
| Level | Introductory |
| Fees | $195 Learn more |
About the course
-
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 ÐÓ°ÉÖ±²¥ 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.
What you’ll 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.
Is this course for me?
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.
Fees and enrolment
| For individuals | For teams |
|---|---|
|
The enrolment fee for the Mastering Excel Pivot Tables course is: $195 AUD Please contact us if you would like to pay via invoice. If you are a staff member or alumni of the ÐÓ°ÉÖ±²¥ of Adelaide, please reach out to discuss potential discounts and payment options. |
If you are interested in enrolling four or more team members in this course, contact us to discuss pricing. Pricing on request. |