Grouping by Dates in Pivot Tables Excel 2010/2007

How to summarise data in Pivot Tables using Dates. Very useful if you need to summarize point of sale data, maintenance or expense records by month, week or fortnight (14 days)

Technique shown will work in Excel 2007 and Excel 2010. Actual grouping technique works in Excel 2003.

This movie requires Flash Player 10. It has been recorded in 1024 x 576 (16:9). If it is slow to load or too wide for your screen it can also be viewed at youtube . 

This movie may be too wide for this WordPress theme, I am experimenting with sizing – your feedback appreciated.

Please send me suggestions for topics to cover.

Intro music purchased  from