Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel for Mac 2011: Pivot Tables in Depth


Introduction
Welcome
What you should know before watching this course
Using the exercise files

1. Creating and Pivoting PivotTables
Introducing PivotTables
Formatting data for use in a PivotTable
Creating a PivotTable
Pivoting a PivotTable
Configuring a PivotTable
Creating a PivotTable from a text file
Refreshing PivotTable data connections
Managing PivotTables

2. Summarizing PivotTable Data
Managing subtotals and grand totals
Changing the data field summary operation
Summarizing more than one data field
Creating a calculated field
Grouping PivotTable fields
Drilling down to the underlying data

3. Sorting and Filtering PivotTable Data
Sorting PivotTable data
Filtering a PivotTable field by selection
Filtering a PivotTable by rule
Filtering a PivotTable using a search filter
Filtering a PivotTable using report filter fields
Clearing and reapplying PivotTable filters

4. Formatting PivotTables
Applying a PivotTable style
Creating a PivotTable style
Changing the PivotTable layout
Changing the data field number format

5. Printing PivotTables
Printing a PivotTable
Printing headers at the top of each printed page
Printing a PivotTable as a PDF

Conclusion
Next steps