Google spreadsheets are now more strengthened with Pivot Tables. Pivot tables are dynamic tables which provides easy way to analyze spreadsheets without using any formula. Who regularly works with spreadsheets knows very well about Pivot Tables. But for new users i will explain with example. Let us assume Students information with Name, Class, Section, Maths Marks, Science Marks, Social Marks is maintained in the Spreadsheet. School Management wants to know the Maximum marks in Maths, Minimum marks in Science and Average Marks in Social in class wise and section wise. Normally with formulas, filters and subtotals it will take more time to do this. But using Pivot Tables it can be done easily.
Students data in Google Spreadsheet
