Pivot tables enable effective and powerful data analysis. Pivot tables allow you to summarize, calculate, move or filter data without having to change the actual data in your Excel spreadsheet. Excel's pivot table report is unique in its function. There is no comparable tool that analyzes data sets so easily and flexibly.
This field is so exciting that we are dedicating two Special Topics to it. Be our guest today when we show you what a pivot table is and how to create and operate pivot tables. In our next Special we will familiarize you in more detail with the functions of pivot analysis.
To acces the videos for this Special Topic you must have subscribed to Excel !
Excel 2016
What are Pivot Tables:
In this video you will learn about the use of Pivot Tables and Pivot Charts. Additionally we will show you possible fields of application.
(4 Min.)
Data Sources PivotTables:
This video will show you the various data sources which can be used for PivotTable analysis. You will learn about the advantages, disadvantages and the neccessary conditions.
(4 Min.)
Creating PivotTables:
In this video you will learn how to create PivotTables and how to define criteria and evaluation fields. Additionally, we will show you how to set functions such as number and sum needed for the calculation.
(8 Min.)
Excel 2013
What are Pivot Tables:
In this video you will learn about the use of Pivot Tables and Pivot Charts. Additionally we will show you possible fields of application.
(4 Min.)
Data Sources PivotTables:
This video will show you the various data sources which can be used for PivotTable analysis. You will learn about the advantages, disadvantages and the neccessary conditions.
(4 Min.)
Creating PivotTables:
In this video you will learn how to create PivotTables and how to define criteria and evaluation fields. Additionally, we will show you how to set functions such as number and sum needed for the calculation.
(8 Min.)
Excel 2010
What are Pivot Tables:
In this video you will learn about the use of Pivot Tables and Pivot Charts. Additionally we will show you possible fields of application.
(4 Min.)
Data Sources PivotTables:
This video will show you the various data sources which can be used for PivotTable analysis. You will learn about the advantages, disadvantages and the neccessary conditions.
(4 Min.)
Creating PivotTables:
In this video you will learn how to create PivotTables and how to define criteria and evaluation fields. Additionally, we will show you how to set functions such as number and sum needed for the calculation.
(8 Min.)
Excel 2007
Data Sources PivotTables:
This video will show you the various data sources which can be used for PivotTable analysis. You will learn about the advantages, disadvantages and the neccessary conditions.
(4 Min.)
Creating PivotTables:
In this video you will learn how to create PivotTables and how to define criteria and evaluation fields. Additionally, we will show you how to set functions such as number and sum needed for the calculation.
(8 Min.)