Excel PivotTables – 33 Videos

The PivotTable Challenge – 2 hours to become a PivotTable Guru!
33 videos – all you need to know about PivotTables!

Buy a Subscription to this Course

Course Content

Expand All | Collapse All

Lessons Status

1

Lesson 1 - Create & Work with a Basic PivotTable

• Excel 2016 – 3.1.1 – View and Setup Data
• Excel 2016 - 3.1.2 - Create a Basic PivotTable
• Excel 2016 - 3.1.3 - Add Currency Style to Pivot Data
• Excel 2016 - 3.1.4 - Group a PivotTable by Date
• Excel 2016 - 3.1.5 - Filter and Ungroup Pivot Data
• Excel 2016 - 3.1.6 - Drill into Pivot Data
• Excel 2016 - 3.1.7 - Drilldown Into Pages
• Excel 2016 - 3.1.8 - Create a PivotChart
• Excel 2016 - 3.1.9 - Insert and Use Slicers
• Excel 2016 - 3.1.10 - Refresh the Data
• Excel 2016 - 3.1.11 - Set a PivotTable to Open on Refresh

2

Lesson 2 - Customise PivotTables

• Excel 2016 - 3.2.1 - How to Display Blank Cells
• Excel 2016 - 3.2.2 - How to Rename Field Headings
• Excel 2016 - 3.2.3 - Change the Pivot Layout
• Excel 2016 - 3.2.4 - Apply Pivot Styles

3

Lesson 3 - Sorting & Filtering in a PivotTable

• Excel 2016 - 3.3.1 - Basic Sorting
• Excel 2016 - 3.3.2 - Create a Manual Sort
• Excel 2016 - 3.3.3 - Custom List Sort
• Excel 2016 - 3.3.4 - Filter by Date
• Excel 2016 - 3.3.5 - Show Top 5 Locations
• Excel 2016 - 3.3.6 - Using Slicers with Multiple Pivots

4

Lesson 4 - Grouping in a PivotTable

• Excel 2016 - 3.4.1 - Group by Numbers
• Excel 2016 - 3.4.2 - Group Dates by Week
• Excel 2016 - 3.4.3 - Group Text Fields

5

Lesson 5 - Calculating in a PivotTable

• Excel 2016 - 3.5.1 - Using Average and Count
• Excel 2016 - 3.5.2 - Using % Difference From
• Excel 2016 - 3.5.3 - Using % of Grand Total
• Excel 2016 - 3.5.4 - Using Rank
• Excel 2016 - 3.5.5 - Using % Of
• Excel 2016 - 3.5.6 - Using % of Row Total
• Excel 2016 - 3.5.7 - Using Calculated Field
• Excel 2016 - 3.5.8 - Using Calculated Item
• Excel 2016 - 3.5.9 - Pivot Sorting Issue