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.
Enjoy!
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!
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.
View the Outlines for our Excel Courses:
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.