Pivot Tables
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Preparing Your Data for Pivot Tables
Preparing Your Data for Pivot Tables
You need to arrange your data in a certain format before creating a PivotTable. Learn how to do so in this lesson
Build Your First Pivot Table
Build Your First Pivot Table
Our first Pivot Table will compare the performance of our salespeople by state and provide some insights into how the business is run.
Formatting Pivot Tables
Formatting Pivot Tables
Pivot Table data initially appears without any formatting. Banded rows, comma separators and other techniques can be used to make your data much more readable.
Changing Pivot Table Output Values
Changing Pivot Table Output Values
The default SUM output format can be changed to many different alternatives in a Pivot Table. Learn how to apply these alternatives in this lesson
Grouping Date Columns
Grouping Date Columns
Date columns can be difficult to deal with in a PivotTable unless you know how to use Excel's Group function to format them.
Updating Pivot Tables with New Data
Updating Pivot Tables with New Data
Adding columns and rows to PivotTables is made easier by using Tables but still requires some changes to your PivotTable settings, notably in the Group settings.
Pivot Table Subtotals
Pivot Table Subtotals
Subtotals are created when you have more than one row or column label. Learn how to create and format them correctly in this lesson
Sorting Pivot Table Data
Sorting Pivot Table Data
Pivot Tables come with lots of sorting options for both columns and rows. Learn how to access these options in this short lesson
Apply Filters to Pivot Tables
Apply Filters to Pivot Tables
Simple filters can be applied to Pivot Tables by manual selection, creating rules and using the search bar. This lesson covers all 3 methods.
Pivot Table Slicers
Pivot Table Slicers
Slicers are new to Excel 2010 and allow you to perform much better manual selection filters than before
Build Charts from a Pivot Table
Build Charts from a Pivot Table
Charts can be extracted directly from a Pivot Table, but a better option is to create Pivot Chart directly from the dataset.
Pivot Table Data in Formulas
Pivot Table Data in Formulas
You might be tempted to insert Pivot Table data into formulas but be careful, this action is has many pitfalls to be wary of.
