If you asked ten regular Excel users what the most complicated part of Excel was, nine would probably say PivotTables! It was always a source of frustration that Microsoft hid this amazingly powerful tool behind user front-ends that were unintuitive to say the least. They made a straightforward tool appear complex when it really wasn’t. With the knowledge of how to use these tools properly comes greater data interrogation, better analysis, clearer data presentation and amazingly powerful statistical analysis. And the beauty of it is – it’s easy when you know how!