A pivot table is a feature of MS Excel which organises and summarises large amounts of data. Students are introduced to this concept through a series of 15 tasks, allowing them to practise each step in the process. A further set of 6 exercises give students the opportunity to consolidate the skills learned throughout the pack. Suggested solutions are provided to all tasks and exercises. NOTE: This pack is a re-write of Pack 01/10 to reflect the significant differences between Office 2007 and previous versions.