Your basket is empty

background section

Excel - module 6 : Pivot tables - basic

Microsoft Excel offers an incredibly varied number of functions and features that range from basic to highly specialized. Our different courses are aimed at helping you discover each of its secrets. Learn how to use Excel PivotTables, an incredibly powerful tool for analyzing data and reporting, to summarize, sort, group, reorganize and process your data.

  • Training type


  • Duration of training

    0.5 day

  • Available languages
  • Training code


What do you learn?

  • You create pivot tables using whichever method is most suitable for your data and how you want to show it;
  • You add fields, columns or rows to your pivot tables with just a few clicks;
  • You change the style, format or layout of your pivot table to make sure your data stands out for maximum effect.

You can find the general page with all 14 modules here.

Target group

You want to improve your knowledge or ability in Excel.

Required prior knowledge

Depending on the module.

Overview of the programme

  • Introduction to pivot tables and Excel PivotTablesTM;
  • The model;
  • Hiding rows or columns;
  • A report filter;
  • What to do if the data in the list changes;
  • Excel PivotTablesTM formatting;
  • Changing the layout of Excel PivotTablesTM;
  • Grouping data;
  • Adding fields to a source table;
  • Adding or deleting a (second) sequence of values;
  • Showing values;
  • Filtering;
  • Sorting;
  • Showing details;
  • Pivot charts and Excel PivotChartsTM;
  • Exercises.