Your basket is empty

background section

Excel : pivot tables

There’s a reason why Excel is the most widely used spreadsheet in the world: it’s designed to help you work more quickly, efficiently and effectively. Of course, to truly tap into the awesome power of Excel, you  need to know more than the basics. With this course on PivotTables, you add one of the most impressive and useful functions to your toolbox.

  • Training type


  • Duration of training

    1 day

  • Available languages
  • Training code


What do you learn?

  • You create and modify PivotTables without a second thought;
  • You know how to apply or change settings to make your PivotTables analyse and report the data you need to see;
  • You feel comfortable and confident creating and using PivotTables.

Target group

You regularly work with PivotTables.

Required prior knowledge

You have a relatively strong basic knowledge of Excel.

Overview of the programme

  • Creating a PivotTable;
  • PivotTable formatting;
  • Modifying and grouping data;
  • Adding a second sequence of values;
  • The ‘Show values as’ tool;
  • Filtering and sorting;
  • PivotCharts;
  • Custom formulas, calculated fields and items;
  • PivotTables based on multiple source tables;
  • PowerPivot;
  • Conditional formatting in a PivotTable;
  • PivotTable options;
  • Field settings.