Here is a video by Joh Flynn from Youtube.
Note: Video length: 6m:54s.
This video includes:
- Various functionalities of the pivot tool
- sort and sum
- organise data
- Create 'summary' data of your spreadsheet
- Where to find and select the pivot table from the ribbon
- Ways of organising data
- row labels
- values (your numbers)
- report filters
- column labels
Video source: Microsoft Excel pivot table tutorial for beginners - Excel 2003, 2007, 2010