Excel PivotTables – 33 Videos

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

Subscribe 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