Scribd
Upload
5 views13 pages

Excel PivotTable

PivotTables in Excel are tools for organizing and analyzing data in a tabular format, allowing users to add, remove, calculate, filter, and sort data. They consist of four main components: Columns, Rows, Filters, and Values, each serving a specific purpose in data presentation. The PivotTable Fields panel enables customization of the data layout and settings.

Uploaded by

koransan120
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views13 pages

Excel PivotTable

PivotTables in Excel are tools for organizing and analyzing data in a tabular format, allowing users to add, remove, calculate, filter, and sort data. They consist of four main components: Columns, Rows, Filters, and Values, each serving a specific purpose in data presentation. The PivotTable Fields panel enables customization of the data layout and settings.

Uploaded by

koransan120
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel PivotTable

PivotTable
• PivotTable is a functionality in Excel which helps you organize and
analyze data.
• It lets you add and remove values, perform calculations, and to filter
and sort data sets.
• PivotTable helps you structure and organize data to understand large
data sets.
• The data that you use needs to be in tabular format.
• The tabular form is data in a table format (rows and columns).
How a PivotTable Works
• PivotTables have four main components:
[Link]
• Columns are vertical tabular data.
• The column includes the unique header, which is on the top.
• The header defines which data you are seeing listed downwards.
• In this example, D5(Sum of Attack) is the header.
D6(110), D7(100), D8(50), D9(73), and so on are the data.
2-Rows
Rows are horizontal tabular data.
Data in the same row are related.
In this example, A8(Alakazam) is the Pokemon
name.
B8(500), C8(55), D8(50), E8(45) represents the pokemons stats.
3- Filters
Filters are used to select what data you see.
In this example, there are two filters enabled: Generation
and Type 1.
The filters are set to Generation (1) and Type (Psychic).
We will only see Generation 1 pokemon that is Type 1,
Psychic.
All pokemon in the table below the filter are of this generation
and type.
4- Values
Values define how you present the data.
You can define how you Summarize and Show values.
In this example, values are defined for the range B5:E5.
The range B5:E5 has all the same value setting: Sum
The Sum is summarized in the range B14:E14
• Values settings view:
• You can change the name and settings of the values.
Fields and layout
• The TablePivot is displayed how by your settings.
• The PivotTable Fields panel is used to change how you see the data.
• The settings can be separated in two: Fields and Layout.

You might also like