Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.
Overview
Syllabus
Introduction
- Apply the power of Excel PivotTables
- What you should know before starting
- The changing Excel interface
- Introduction to PivotTables
- Format data for use in a PivotTable
- Create a PivotTable
- Pivot a PivotTable
- Configure a PivotTable
- Connect to an external data source
- Consolidate data from multiple sources
- Manage PivotTables
- Define a default PivotTable layout
- Manage subtotals and grand totals
- Change the data field summary operation
- Summarize more than one data field
- Manage dates in a PivotTable
- Create a calculated field
- Use PivotTable data in a formula
- Drill down to the underlying data
- Sort PivotTable data
- Create a custom sort order
- Filter a PivotTable field by selection
- Filter a PivotTable by rule
- Filter a PivotTable using a search filter
- Filter a PivotTable using slicers
- Format slicers
- Filter a PivotTable with report filter fields
- Clear and reapply PivotTable filters
- Filter a PivotTable using a Timeline
- Apply a PivotTable style
- Create a PivotTable style
- Change the PivotTable layout
- Change the data field number format
- Highlight cells by applying a rule
- Highlight the top or bottom values in a PivotTable
- Format cells using data bars
- Format cells using color scales
- Format cells using icon sets
- Edit a conditional formatting rule
- Control how multiple rules are applied
- Delete a conditional formatting rule
- Create a PivotChart
- Pivot a PivotChart
- Filter a PivotChart
- Format a PivotChart
- Change a PivotChart’s layout
- Change a PivotChart’s chart type
- Add a trendline to a PivotChart
- Print a PivotTable
- Set PivotTable print options
- Print each item on its own page
- Print a PivotChart
- Record and review an Excel macro
- Run an Excel macro
- Create a simple PivotTable presentation kit
- Change PivotTables using keyboard shortcuts
- Create relationships between tables
- Create a PivotTable using the data model
- Edit table relationships
- Deactivate and delete table relationships
- Define sets using the Data Model
- Additional resources
Taught by
Curt Frye