Realdolmen Education

Details

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

Duration

0.2 day(s)

Prerequisites

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.

Description

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

Contents

  • 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