In our last Special Topic we introduced you to the advantages of pivot tables. Today we'll get down to the nitty-gritty! Familiarize yourself with the functions of the pivot table and deepen your knowledge. Learn about pivot table format options, how to customize error output, or retrieve detailed information. Once you've worked your way through our two Specials, you'll be a master of data analysis!
To acces the videos for this Special Topic you must have subscribed to Excel !
Excel 2016
Formatting Options PivotTables:
This video explains how to use the formatting options to display your PivotTables with a pleasant design. We will give an introduction to the style templates available for PivotTables and show you how to format numbers.
(3 Min.)
Mod Val Error PivotTables:
In this video you will learn how to customize and hide the display of value error messages in Pivot Tables.
(2 Min.)
Using Calculated Fields in PivotTables:
In this video you will learn how to use and create calculated fields in Pivot Tables and what you have to keep in mind.
(10 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.)
Accessing PivotTable Details:
In this video you will learn how to display the detailed information behind your calculations in a Pivot Table.
(2 Min.)
Excel 2013
Formatting Options PivotTables:
This video explains how to use the formatting options to display your PivotTables with a pleasant design. We will give an introduction to the style templates available for PivotTables and show you how to format numbers.
(3 Min.)
Mod Val Error PivotTables:
In this video you will learn how to customize and hide the display of value error messages in Pivot Tables.
(2 Min.)
Using Calculated Fields in PivotTables:
In this video you will learn how to use and create calculated fields in Pivot Tables and what you have to keep in mind.
(10 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.)
Accessing PivotTable Details:
In this video you will learn how to display the detailed information behind your calculations in a Pivot Table.
(2 Min.)
Excel 2010
Formatting Options PivotTables:
This video explains how to use the formatting options to display your PivotTables with a pleasant design. We will give an introduction to the style templates available for PivotTables and show you how to format numbers.
(3 Min.)
Mod Val Error PivotTables:
In this video you will learn how to customize and hide the display of value error messages in Pivot Tables.
(2 Min.)
Using Calculated Fields in PivotTables:
In this video you will learn how to use and create calculated fields in Pivot Tables and what you have to keep in mind.
(10 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.)
Accessing PivotTable Details:
In this video you will learn how to display the detailed information behind your calculations in a Pivot Table.
(2 Min.)
Excel 2007
Formatting Options PivotTables:
This video explains how to use the formatting options to display your PivotTables with a pleasant design. We will give an introduction to the style templates available for PivotTables and show you how to format numbers.
(3 Min.)
Mod Val Error PivotTables:
In this video you will learn how to customize and hide the display of value error messages in Pivot Tables.
(2 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.)
Accessing PivotTable Details:
In this video you will learn how to display the detailed information behind your calculations in a Pivot Table.
(2 Min.)
Home
Special Topics
