Realdolmen Education


Excel Pivot Tables (VILT - Virtual Instructor Led Training)

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course


0.2 day(s)


A good knowledge of the basics of Excel is required (file management, edit data, structure of a sheet, formatting). Mastering dynamic tables is a plus as we won’t be able to go into detail during this short session.


This session will teach you how to create, manage and use pivot tablet o extract and analyze data in an Excel list of table.


  • Create a pivot table
  • Sorting a pivot table
  • Using filter, slicers and timelines in pivot tables
  • Refresh the data in the database
  • Group elements
  • Formatting a pivot table
  • Apply conditional formatting on a pivot table
  • Create pivot charts
  • Options for a pivot table