Description
The PivotTable (PivotTable) is one of the most powerful and dynamic MS Excel tools. It enables the user to efficiently analyse figures in the blink of an eye.
This module shows how to create a pivot table based on data in MS Excel or external data sources. The new method for creating dynamic tables (tables) is also briefly explained.
We will discuss the various ways to adapt a pivot table to the user's needs: adding or removing, showing or hiding elements, changing the field properties.
We'll cover how to group data, and how to show and hide details. We'll learn how to calculate additional fields and items in a pivot table, and we'll discuss the options for sorting and filtering data.
The interaction between graphs and pivot tables is also covered, as well as that between pivot tables and conditional formatting. Finally, we'll explore some interesting options for setting up a pivot table.
Audience
This course is intended for people who already have a good knowledge of MS Excel and who want to delve into the use of pivot tables.
Methods
Classroom training with attention to individual guidance and the ability to ask questions. Using exercises, the student can immediately put the possibilities of the program into practice.
Contents
- Data source conditions
- Transform a list into a dynamic table (table)
- Building a Pivot Table
- Based on Excel data
- Based on external data
- Add and remove fields
- Change the properties of fields
- Sorting a pivot table
- Using filters, slicers, and timelines in pivot tables
- Refresh database data
- Show and hide elements
- Grouping elements
- Show and hide details
- Calculated fields
- Calculated items
- Create PivotCharts
- The layout of a pivot table
- Apply conditional formatting to pivot tables
- Pivot Table Options
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.