Overview
-
Shows how to create PivotTable reports, an amazing tool for data analysis, using internal Excel data and outside data sources.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- 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
- 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
- Sorting PivotTable data
- Creating a custom sort order
- Filtering by selection
- Filtering by a rule
- Filtering with report filter fields
- Clearing and reapplying filters
- Applying a style
- Creating and editing styles
- Changing the layout
- Changing the data field number format
- 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
- 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
- Printing a PivotTable report
- Printing each item on its own page
- Printing a PivotChart report
- Goodbye
