Description
You are working with a large list of data in Excel? If you cannot see the forest for the trees, PivotTables will provide you with a clear overview of all the data collected. After this part two, you will know at a glance how many items meet a specific condition. You will also learn how to carry out analyses using the different parameters such as language, region, or any other column in your table. In short, how to optimise the analyses of your data by using the many advantages Excel PivotTables offers.
Objectives
After this remote Excel training on PivotTables:
- you will know how to create the correct foundation for PivotTables
- you will be aware of the power of PivotTables
Target Group
Employees who regularly work with data lists in Excel and want to analyse their data with PivotTables.
Prerequisites
Participants have completed the remote Excel course ‘lists and tables’ or have the equivalent knowledge.
Content
Working with PivotTables
- Using recommended PivotTables
- The different parts of a PivotTable: filter fields, row fields, column fields and values
- Layout and structure of a PivotTable: PivotTable style, calculation layout, report layout (compact, outline, tabular)
- Subtotals (activating, deleting, activating only for certain fields…)
- Viewing calculations differently: % of grand total, % of row total, …
- Grouping data: text, dates, numbers
- What is the PivotCache?
- Filtering PivotTables using Slicers (general slicers and timeline slicers)
- Intro to Power Pivot: Creating a PivotTable based on multiple tables
