What is the software pivot

A Pivot Table is a Menu choice in Microsoft Excel for summarizing, grouping and aggregating a table of date. You may have the absence records for 50 employees in London, New York, Tokyo and Hong Kong in three grades Manager, Accounts and Admin. Some are full time and some are part time. A Pivot table will answer the question of whether average absence is high or lower in each region and further allow to check if an employees grade or job status affects their reliability. For full manual on using Excel as a database tool try http://www.mousetraining.co.uk/training-manuals