A pivot table is an interactive data-mining tool that can be used to extract information from the raw data that is being examined.Īll areas of business (accounting, marketing, finance, management) use pivot tables as part of their data analyses. You can even display pivot table data as a percentage of the grand total for the data being examined. A pivot table can summarize data into categories using functions such as SUM, MAX, MIN, AVERAGE, COUNT, as well as other Excel functions. Furthermore, this data can be “pivoted,” or rearranged, so that the same data can be examined from a different angle or dimension. Through the creation of an Excel pivot table, you can quickly summarize lists of data by category in a tabular format. This makes it difficult to get a clear picture of the story that can be told by examining the data. However, the numerous rows and columns of data can be overwhelming. In a business setting, Excel spreadsheets typically contain an extensive amount of detailed data. The “Pivot Table Toolkit” was published in 2009 by the Information Systems section of the American Accounting Association in the Compendium of Classroom Cases and Tools for AIS Applications, volume 4. Tutorial: Conducting Data Analysis Using a Pivot TableĪn earlier version of this tutorial, authored by Brian Kovar, is part of a larger body of work titled “The Pivot Table
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |