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
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent