INTRODUCTION TO PIVOT TABLES | 08 – USING THE SLICER (EXCEL 2010 ONLY)

So this is the final installment in the series of pivot tables. You can check out parts one, two, three, four, five ,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..

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/08-pivot-slicer.m4v’]

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