Conducting Data Analysis Using a Pivot Table in pdf

In a business setting, Excel spreadsheets typically contain an extensive amount of detailed data. However, the numerous rows and columns of data can be overwhelming. This makes it difficult to get a clear picture of the story that can be told by examining the data.

Through the creation of an Excel pivot table, you can quickly summarize lists of data by category in a tabular format. Furthermore, this data can be “pivoted,” or rearranged, so that the same data can be examined from a different angle or dimension. A pivot table can summarize data into categories using functions such as SUM, MAX, MIN, AVERAGE, COUNT, as well as other Excel functions. You can even display pivot table data as a percentage of the grand total for the data being examined. A pivot table is an interactive data-mining tool that can be used to extract information from the raw data that is being examined.