Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Playing with Pivot Tables
Chapter 9
Playing with Pivot Tables
In This Chapter
Understanding what makes a pivot table tick
Creating a new pivot table with the Quick Analysis tool and Recommended PivotTables
command
Manually creating a new pivot table
Formatting your new pivot table
Sorting and filtering the pivot table data
Modifying the structure and layout of a pivot table
Creating a pivot chart
Pivot table is a name given to a special type of summary table that’s
unique to Microsoft Excel. Pivot tables are great for summarizing
particular values in a data list or database because they do their magic without
making you create formulas to perform the calculations. They also enable
you to quickly and easily examine and analyze relationships inherent in their
data sources; data lists you maintain in Excel, or external database tables you
import into Excel from standalone database applications such as Microsoft
Office Access, or from a data feed such as Windows Azure Marketplace (as
discussed in Chapter 11).
Pivot tables also let you play around with the arrangement of the
summarized data — even after you generate the table. This capability of changing
the arrangement of the summarized data on the fly simply by rotating row
and column headings gives the pivot table its name. And, if you’re the type
who relates better to data represented in pictorial form, Excel enables you to
summarize your data list graphically as a pivot chart using any of the many,
many chart types now supported by the program.
Search JabSto ::




Custom Search