So this is the final installment in the series of pivot tables. You can check out parts onetwothree, fourfive ,six and seven here.

A new feature of Excel 2010 is the Slicer – which looks rather like a grater but which allows you to easily “slice and dice” your data.

So here’s how it’s done..



And as always here is the file for you to practise on.