Upcoming events

Monday, 20th August 2018

Time: 11:00AM - 12:30PM
Location: Rm 104, Social Sciences North Building (Computer Training Suite)

Tuesday, 9th October 2018

Time: 11:00AM - 12:30PM
Location: Rm 104, Social Sciences North Building (Computer Training Suite)

Please remember if you can't attend a course anymore please unenrol yourself or move to the waiting list so others can attend.

Waiting list

To be notified of upcoming events, you can add your name to the waiting list.

Excel - Pivot Tables

Course description

This module introduces one way in which Excel can extract summary information by using the existing structure of a data table.

Type of course

Hands-on computer course

Presenters

Peter Franz
Flinders University

Who should attend

For anyone needing to summarise data in lists or tables by cross matching categories.

What you will learn

  • Arranging Your Data List
  • Creating a Pivot Table to Summarise Data
  • Editing Pivot Tables
  • The pivot table toolbar
  • Controls grouping and ungrouping data
  • Formatting the table
  • Charting a Pivot Table
  • Creating graphs from the data

Prerequisites / assumed knowledge

Basic understanding of Excel.