Scribd
Upload
14 views10 pages

Exploring Data Using Pivot Table

The document explains the functionality of Pivot Tables in Excel, which help organize and analyze data through four main components: Row Labels, Column Labels, Filters, and Values. Row Labels group data vertically, Column Labels categorize data horizontally, Filters narrow down data based on specific criteria, and Values represent the numerical data for analysis. Together, these components enable users to effectively structure large data sets for better understanding and insights.

Uploaded by

Kyle Salavante Abong
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
14 views10 pages

Exploring Data Using Pivot Table

The document explains the functionality of Pivot Tables in Excel, which help organize and analyze data through four main components: Row Labels, Column Labels, Filters, and Values. Row Labels group data vertically, Column Labels categorize data horizontally, Filters narrow down data based on specific criteria, and Values represent the numerical data for analysis. Together, these components enable users to effectively structure large data sets for better understanding and insights.

Uploaded by

Kyle Salavante Abong
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

EXPLORING DATA USING PIVOT TABLE

Pivot Table
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.
What are the four 4 components of a Pivot Table?

1) Row Labels:
Row Labels are the categories or criteria by which you want to group
your data. They appear on the left side of the Pivot Table and organize
your data vertically. For example, if you’re analyzing sales data, you
might use Row Labels to group sales by product category or region.
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.
The type of stats is read in the
header in the columns.
2) Column Labels:
Column Labels allow you to categorize your data horizontally.
They provide additional layers of organization and enable you
to compare data across different categories. For instance, you
might use Column Labels to analyze sales data by month or
quarter.
COLUMNS

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.
3) Filters:
Filters allow you to narrow down your data based on
specific criteria. They enable you to focus on a subset of
your data that meets certain conditions, making it easier to
perform targeted analysis. For example, you could apply a
filter to analyze sales data for a particular region or time
period.
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 represent the numerical data you want to
analyze or summarize. They are typically placed in the
body of the Pivot Table and serve as the foundation for
your analysis. Common examples of values include total
sales revenue, average order value, or quantity sold.
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.

You might also like