Group a PivotTable by Date

The dates in the Date column span 2 years. This is the correct way to input dates in your dataset, if you want to create a PivotTable. However, to display the information by Year , you need to know how to Group those dates.  I’ll take it a step further and Group by Quarter, within Year.


From me to you – Special Offer Price – €9.99

Normal Price – €15.00

To show my appreciation for having signed up

The PivotTable Challenge – 2 hours!

All you need to know – to become a PivotTable Guru!

Now you have the basics of PivotTables, it’s time to take on the challenge – to become a PivotTable Guru!

The 4 videos that you have seen are actually part of a series of 33 videos and you now have the opportunity to access all 33 videos and the supporting files that go with them.

  • 33 videos = a total of 2 hours of video
  • Access when you want to, day or night
  • Download the supporting files
  • Work alongside the videos
  • Work at your own pace


The 2 Hour PivotTable Challenge!

Click here for – 33 videos – All you need to know about PivotTables
Normally €15.00 – now for the Special Offer Price of – €9.99

Hi, I'm Kelly!

Picture of Kelly


33 Videos on PivotTables!

Now you have the basics of PivotTables, become a PivotTable Guru!
Normal Price: €15.00 – Special Offer:  €9.99
Yes! €9.99 for 1 years access to 33 videos on PivotTables PLUS the supporting files!
Excel Course – Previously, if I couldn’t gat my formula to work, I abandoned it and resorted back to more manual ways of doing my calculations.  Not any more!  I actually understand how they work now!  This means reduced workload and increased productivity.  Happy me and very happy boss!
Jennifer F.
Excel Course – I gained the necessary training to use Excel confidently in my everyday role.  This will help in performing tasks at speed.  I really enjoyed the training, thanks.
Nigel H.