Description

Working with a large list of data in Excel? To see the wood for the trees, pivot tables (PivotTables) give you a clear overview of all your collected data. You'll learn how many items meet a certain condition. You'll also learn how to analyse using different parameters such as language, region, or any other column in your table. In short, optimise the analysis of your data thanks to the huge benefits of Excel PivotTables.

Objectives

After this online training "Excel: Mastering PivotTables":

• You'll lay the right foundation for building PivotTables

• You'll know the power of PivotTables

Target audience

Employees who regularly work with data lists in Excel and want to analyse their data.

Prerequisites

Participants have taken the Excel course 'lists and tables' or have equivalent knowledge.

Contents

The power of PivotTables

• Using Recommended PivotTables

• The different parts of a pivot table: filter fields, row fields, column fields and values

• Layout and structure of a pivot table: style, calculation layout, report layout (compact, outline, tabular)

• Subtotals: activating, removing, activating for specific fields only

• Displaying calculations differently: % of grand total, % of row total, etc.

• Grouping data: text, dates, numbers

• What is the PivotCache?

• Filtering PivotTables with slicers (standard slicers and timeline slicers)

• Intro to Power Pivot: Creating a PivotTable based on multiple tables