Analysing Data with Pivot Tables

Target Audience

Pivot tables offer a powerful way to quickly arrange large amounts of data to facilitate reporting. The selection of desired fields and ability to quickly alter the perspective of the table means that pivot tables provide a powerful analytical function. Staff who receive large outputs of data from the University of Adelaide information systems, or people who have collected significant data for research purposes and need to provide data summaries, will find these skills useful.

Overview

This course will covers the creation of a pivot table from a simple flat file, as well as the subsequent manipulation and refreshing of the table. Formatting the table, grouping and totalling will also be covered.

Prerequisite and Co-requisite Courses

Staff should be familiar with the basic use of Excel. Completion of Introduction to Excel or equivalent experience is essential. We strongly recommend that you attend Data Management with Excel or have the equivalent skills and knowledge before attending Analysing Data with Pivot Tables.

Course Duration

3 hours.

Competencies

At the completion of the course, attendees will be able to:

1. Create a pivot table.
2. Rearrange a pivot table, including the row, column and page axes.
3. Display totals.
4. Refresh a pivot table.
5. Create a pivot chart.
6. Use ad hoc groups.
7. Drill to underlying data.

For further details about courses go to the schedule of courses at the ITS training site.