Special Offer – Excel PivotTables!

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

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

Course Content

Expand All

Lesson 1 – Create & Work with a Basic PivotTable 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

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 Refresh on Open

Lesson 2 – Customise PivotTables 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

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

Lesson 3 – Sorting & Filtering in a PivotTable 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

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

Lesson 4 – Grouping in a PivotTable 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

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

Lesson 5 – Calculating in a PivotTable 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

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