“With a pivot table, you can take 65,000 rows (it is a lot more than that now!) of transactional data and transform it into a summary report in seconds. In addition to quickly summarising and calculating data, pivot tables allow you to change your analysis on the fly by simply dragging fields from one area [...]