Scribd
Upload
63 views12 pages

Pivot Tables for Business Students

Pivot tables allow users to analyze and summarize large amounts of data in Microsoft Excel. Pivot tables extract data from a spreadsheet and reorganize it to highlight relationships and identify trends. Users can create pivot tables by selecting cells of data and configuring rows, columns, and values. Pivot tables automatically update as the underlying data changes, making them useful for exploring and reporting on dynamic data sets.

Uploaded by

Eric M Andes
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
63 views12 pages

Pivot Tables for Business Students

Pivot tables allow users to analyze and summarize large amounts of data in Microsoft Excel. Pivot tables extract data from a spreadsheet and reorganize it to highlight relationships and identify trends. Users can create pivot tables by selecting cells of data and configuring rows, columns, and values. Pivot tables automatically update as the underlying data changes, making them useful for exploring and reporting on dynamic data sets.

Uploaded by

Eric M Andes
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
You are on page 1/ 12

Advance Computer

in Business Application

Pivot Table

Ericka C. Precones
Subject Instructor
What is PIVOT TABLE?
PIVOT TABLE

Pivot tables are among the most useful and powerful


features in Excel.

Pivot Table is a statistics tool that summarizes and


reorganizes selected columns and rows of data in a
spreadsheet or database table to obtain a desired
report.
PIVOT TABLE

Pivot tables are especially useful with large amounts


of data that would be time-consuming to calculate
by hand.

A few data processing functions to pivot table can


perform include identifying sums, averages, ranges
or outliers.
How to create PIVOT TABLE?
Creating a Pivot table

1. Select any cells you want to create a Pivot Table from.

2. Select Insert > PivotTable.


Creating a Pivot table

3. This will create a PivotTable based on an existing table or


range.
Creating a Pivot table
4. Choose where you want the PivotTable report to be placed.
Select New Worksheet to place the PivotTable in a new worksheet
or Existing Worksheet and select where you want the new PivotTable to
appear.

5. Click OK.
How PIVOT TABLE works?
Columns - When a field is chosen for
the column area, only the unique
values of the field are listed at the
top.

Rows - When a field is chosen for the


column area, only the unique values
of the field are listed at the top.
Values- Each value is kept in a pivot
table cell and displays the summarized
information. The most common values
are sum, average min, max, count, and
product.

Filters- Filters apply a calculation or


restriction to the entire table.
Advantages of using Pivot Table

There is no need to use formulas in order to perform


calculations.

We can perform complex calculations in a quick and


simple way.

The summarized data is dynamic and can easily be


applied to different sets of data

You might also like