Introduction
Welcome
()
Using the exercise files
()
1. Creating and Pivoting PivotTable Reports
Introducing PivotTable reports
()
Formatting data for use in a PivotTable report
()
Creating a PivotTable report
()
Pivoting a PivotTable report
()
Configuring a PivotTable report
()
Connecting to an external data source
()
Consolidating data from multiple sources
()
Updating and refreshing PivotTable data sources
()
Managing PivotTables
()
2. Summarizing PivotTable Data
Adding, removing, and positioning subtotals and grand totals
()
Changing the data field summary operation
()
Summarizing more than one data field
()
Creating a calculated field
()
Drilling down to the underlying data
()
Grouping fields
()
Using PivotTable data in a formula
()
3. Sorting and Filtering PivotTable Data
Sorting PivotTable data
()
Creating a custom sort order
()
Filtering by selection
()
Filtering by a rule
()
Filtering with report filter fields
()
Clearing and reapplying filters
()
4. Formatting PivotTable Reports
Applying a style
()
Creating and editing styles
()
Changing the layout
()
Changing the data field number format
()
5. Emphasizing Data Using Conditional Formatting
Highlighting cells by applying a rule
()
Highlighting the top or bottom value in a report
()
Formatting cells using data bars
()
Formatting cells using color scales
()
Formatting cells using icon sets
()
Editing conditional formatting rules
()
Controlling how Excel applies multiple conditional formatting rules
()
Deleting conditional formatting rules
()
6. Creating and Manipulating PivotChart Reports
Creating a PivotChart report
()
Pivoting a PivotChart report
()
Filtering a PivotChart report
()
Formatting a PivotChart report
()
Changing the layout
()
Changing the chart type
()
Adding a trendline
()
7. Printing PivotTable and PivotChart Reports
Printing a PivotTable report
()
Printing each item on its own page
()
Printing a PivotChart report
()
Ex_Files_Excel07_Pivot.zip
(635 KB)