In part one of this series, I looked at list preparation and in part two, I suggested that you convert your list to a table to make it much easier to manage adding in new data. In part 3, we looked at how to construct your first pivot table. In part four  I showed you how to quickly convert your numbers to percentages.

In this one I am going to show you some ways to group your dates and also to group your numbers.




As always your comments are welcome – and here is the file for you to practise on. 05-pivot_table_grouping