The University of Waikato - Te Whare Wānanga o Waikato
Student Learning
Waikato Home Waikato Home > Student Life > Student Learning  > Help with technology
Staff + Student Login

Student Learning: Technology

Spreadsheets 8 - Excel

Here is a video by Jon Flynn from Youtube.

Video source: Microsoft Excel pivot table tutorial for beginners - Excel 2003, 2007, 2010

This video includes:
  1. Various functionalities of the pivot tool
  1. Sort and sum
  2. Organise data
  3. Create 'summary' data of your spreadsheet
  1. Where to find and select the pivot table from the ribbon
  2. Ways of organising data
  1. Row labels
  2. Values (your numbers)
  3. Report filters
  4. Column labels