Excel: PivotTables in Depth
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.
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
Related Courses
Introduction to DatabasesMeta via Coursera Analyzing Big Data with SQL
Cloudera via Coursera Managing Google Workspace 日本語版
Google Cloud via Coursera Creating Advanced Reports with SAS Visual Analytics
SAS via Coursera Query Client Data with LibreOffice Base
Coursera Project Network via Coursera