Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.Įxpanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you. Querying large amounts of data in many user-friendly ways. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. About PivotTablesĪ PivotTable is an interactive way to quickly summarize large amounts of data. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same. Note: The screen shots in this article were taken in Excel 2016.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |