Excel 2016: Pivot Tables 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 2016.
Syllabus
Introduction
- Welcome
- Using the exercise files
- Introducing PivotTables
- Formatting data for use in a PivotTable
- Creating a PivotTable
- Creating a recommended PivotTable
- Pivoting a PivotTable
- Configuring a PivotTable
- Connecting to an external data source
- Consolidating data from multiple sources
- Managing PivotTables
- Managing subtotals and grand totals
- Changing the data field summary operation
- Summarizing more than one data field
- Creating a calculated field
- Using PivotTable data in a formula
- Drilling down to the underlying data
- Sorting PivotTable data
- Creating a custom sort order
- Filtering a PivotTable field by selection
- Filtering a PivotTable by rule
- Filtering a PivotTable using a search filter
- Filtering a PivotTable using slicers
- Formatting slicers
- Filtering with report filter fields
- Clearing and reapplying PivotTable filters
- Applying a PivotTable style
- Creating a PivotTable style
- Changing the PivotTable layout
- Changing the data field number format
- Highlighting cells by applying a rule
- Highlighting the top or bottom values in a PivotTable
- Formatting cells using data bars
- Formatting cells using color scales
- Formatting cells using icon sets
- Editing a conditional formatting rule
- Controlling how multiple rules are applied
- Deleting a conditional formatting rule
- Creating a PivotChart
- Pivoting a PivotChart
- Filtering a PivotChart
- Formatting a PivotChart
- Changing a PivotChart's layout
- Changing a PivotChart's chart type
- Adding a trendline to a PivotChart
- Printing a PivotTable
- Setting PivotTable print options
- Printing each item on its own page
- Printing a PivotChart
- Recording and reviewing an Excel macro
- Running an Excel macro
- Creating a simple PivotTable presentation kit
- Working with PivotTables using keyboard shortcuts
- Creating relationships between tables
- Creating a PivotTable using the data model
- Editing table relationships
- Next steps
Taught by
Curt Frye
Related Courses
Introduction to Geographic Information SystemsIndian Institute of Technology Roorkee via Swayam Healthcare Data Models
University of California, Davis via Coursera GIS Data Acquisition and Map Design
University of Toronto via Coursera Geographic Information System
Indian Institute of Technology, Kharagpur via Swayam Data Engineering with AWS
Udacity