Excel PivotTables – 33 Videos
The PivotTable Challenge – 2 hours to become a PivotTable Guru!
33 videos – all you need to know about PivotTables!
Course Content
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
- 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
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
- 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