Search our courses

Preparing Your Data Ready for Pivot Tables

• Best Practise
• Data Range Vs Table

Creating Pivot Tables

• Pivot Table 1 – Standard Pivot
• Pivot Table 2 – Formatting a Pivot Table
• Pivot Table 3 – Summary Pivot
• Pivot Table 4 – Show Values As

Grouping Excel Pivot Table Data

• Pivot Table 5 – Group by Numbers
• Pivot Table 6 – Group by Dates
• Pivot Table 7 – Group by Text


• How to add slicer for Pivot tables in Excel
• Changing the appearance of the slicer
• Adding a timeline slicer (Excel 2013 Onwards)

Pivot Charts

• What is a Pivot Chart
• Create a Pivot Chart
• Using Slicers with Charts
• How to drill down into your data via a Pivot Chart (Excel 2016 only)


• Creating a simply non VBA dashboard
• Adding slicers and charts
• Linking slicers to multiple charts

Tips and Tricks to Improve the Appearance of your Pivot Table

• Handling how empty cells are displayed
• Stop Auto-Width of columns when you refresh the data
• How to auto refresh your Pivot Table
• Create a Pipeline Pivot Table
• How to Handle error messages in your Pivot Table

Top 10

• Using Pivot Table Top 10 Filters

Report Filter to Worksheets

• Create Multiple Pivot Table Reports with Show Report Filter Pages

GetPivotData Function

• Use the Excel GETPIVOTDATA function to query a pivot table. Retrieve data from a pivot table in a formula.

Calculated Fields

• Create calculated fields, using formulas that work with the sum of other pivot fields.

Calculated Items

• Learn the difference between Excel pivot table calculated fields and calculated items. When and how to use them, examples and warnings.