Using pivot tables to analyse data

I know I'm late to the party as far as pivot tables are concerned but I've been meaning to blog about this for a while (and now I'm back on a blogging role). We started using TARGETconnect back in September (as far as our students are concerned it's called MyCareers) after integrating it with our student record system over the summer. We're very pleased with what it does on the whole the reporting is limited; until we discovered pivot tables that is. For a few days I faffed around with COUNTIF functions and then realised that this is what pivot tables are made for. So after having a 10 minute tutorial with Laura - Matt, Gareth, Andy and I are massive pivot table fans! Here's a quick Screenr.