I've come across the concept of Pivot Tables, but don't really understand them. Can anyone enlighten me?

My mum (and dad) have recently started using a PC (they are in their sixties) and I was trying to explain MS Office to them. They didn't get it. I was wondering which app do you …