Advance Excel Training institute in Delhi

 

PivotTables

             Defined The foundation of what is a PivotTable report is explained as follows:

 As long as you can connect to the data, whether it be locally in the same workbook or remotely in other locations, you can built PivotTable reports that rearrange the raw data and change it into meaningful information

              A pivot table is an interactive way to quickly summarize large amounts of data; to analyze               
            numerical data in detail and to answer unanticipated questions. They are especially designed for:

     • Querying large amounts of data in many user-friendly ways

     • Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and             creating custom calculations and formulas 

     • Expanding and collapsing levels of data to focus your results, and drilling down to details from the             summary data. 

     • Moving rows to columns or columns to rows (or “pivoting”0 to see different summaries of the source         data. 

     •  Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of              data to enable you to focus on the information that you want