• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 18. Working with Pivot Tables > What Is a Pivot Table?

What Is a Pivot Table?

A pivot table lets you analyze, summarize, and manipulate data in large lists, databases, worksheets, workbooks, tables, or other collections of data. Pivot tables offer flexible and intuitive analysis of data. It's called a pivot table because you can move fields with the mouse to provide different types of summary lists; that is, the table can change, or “pivot.”

Although the data that appears in pivot tables looks like any other worksheet data, you cannot directly enter or change the data in the data area of a pivot table. The pivot table is linked to the source data, and what you see in the cells of the table are read-only amounts. However, you can change the formatting (Number, Alignment, Font, Border, Patterns) and choose from a variety of computation options such as SUM, AVERAGE, MIN, and MAX.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint