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
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