PivotTable is a very powerful tool, which can transform tons of data into user-friendly information for decision making - without using a single formula. Just drag and drop. You can export data to Excel or Google Docs from most software (SAP, NetSuite, ERPLY, XERO, MYOB, UBS etc) to analyse further using PivotTable.
I constantly remind and conduct training for my clients to harness the power of PivotTable. When I was lecturing Financial Modelling in Monash University (Malaysia) few years back, I demonstrated PivotTable, although officially it was not part of the syllabus. This is to prepare the students for the real world.
Learn it, you will be amazed. Here are 2 introductory videos (to learn more, view other videos):
Business, economy, education and current issues. Providing tips, tricks and tools in managing business.