Introduction
Work in depth with PivotTables
(00:28)
What you should know
(00:45)
1. Creating and Pivoting PivotTables
Introducing PivotTables
(03:43)
Format data for use in a PivotTable
(04:25)
Create a PivotTable
(03:46)
Pivot a PivotTable
(03:44)
Configure a PivotTable
(05:09)
Connect to an external data source
(02:28)
Consolidate data from multiple sources
(04:57)
Manage PivotTables
(05:48)
Define a default PivotTable layout
(04:54)
2. Summarizing PivotTable Data
Manage subtotals and grand totals
(03:35)
Change the data field summary operation
(04:32)
Summarize more than one data field
(03:44)
Manage dates in a PivotTable
(02:49)
Create a calculated field
(04:33)
Use PivotTable data in a formula
(03:34)
Drill down to the underlying data
(02:26)
3. Sorting and Filtering PivotTable Data
Sort PivotTable data
(02:21)
Create a custom sort order
(05:36)
Filter a PivotTable field by selection
(04:02)
Filter a PivotTable by rule
(04:37)
Filter a PivotTable using a search filter
(03:17)
Filter a PivotTable using slicers
(04:52)
Format slicers
(04:48)
Filter with report filter fields
(04:12)
Clear and reapply PivotTable filters
(02:16)
Filter a PivotTable using a timeline
(04:52)
4. Formatting PivotTables
Apply a PivotTable style
(03:28)
Create a PivotTable style
(04:02)
Change the PivotTable layout
(03:29)
Change the data field number format
(02:53)
5. Applying Conditional Formats to PivotTables
Highlight cells by applying a rule
(04:51)
Highlight the top or bottom values in a PivotTable
(04:49)
Format cells using data bars
(05:11)
Format cells using color scales
(04:58)
Format cells using icon sets
(05:54)
Edit a conditional formatting rule
(02:53)
Control how multiple rules are applied
(04:25)
Delete a conditional formatting rule
(02:45)
6. Creating and Formatting PivotCharts
Create a PivotChart
(02:26)
Pivot a PivotChart
(02:14)
Filter a PivotChart
(02:16)
Format a PivotChart
(03:38)
Change the layout of a PivotChart
(03:24)
Change the chart type of a PivotChart
(02:36)
Add a trendline to a PivotChart
(03:45)
7. Printing PivotTables
Print a PivotTable
(01:57)
Set PivotTable print options
(04:46)
Print each item on its own page
(02:13)
Print a PivotChart
(02:09)
8. Manipulating PivotTables
Record and review an Excel macro
(04:18)
Run an Excel macro
(06:23)
Create a simple PivotTable presentation kit
(03:51)
Change PivotTables using keyboard shortcuts
(02:18)
9. Enabling and Adding Tables to the Data Model
Create relationships between tables
(05:00)
Create a PivotTable using the data model
(03:04)
Edit table relationships
(02:25)
Deactivate and delete table relationships
(02:32)
Conclusion
Further information
(01:06)
Ex_Files_Excel_Pivot_Tables_Depth.zip
(2.5 MB)
Glossary_Excel_PivotTablesinDepth.zip
(100 KB)