Scribd
Upload
2 views7 pages

Excel PivotTables for Data Analysis

Uploaded by

gamalgemi1234p
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
2 views7 pages

Excel PivotTables for Data Analysis

Uploaded by

gamalgemi1234p
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 data analysis

sec2
Sec content:

1) Excel pivotTables
2) Excel case : ex
1)PivotTables:

• PivotTable def: is a functionality in Excel which helps you organize and


analyze data.

• useful to understand large data sets.

• P.T contain 4 components:


1) Columns
2) Rows
3) Filters
4) Values
How to convert data to P.T:
• First our data must be in the table format (rows and columns),
& with the Header Row

• Then we select our data & convert to P.T:


How a PivotTable works:

• P.T is displayed how by your settings.


• The settings can be separated in
two: Fields and Layout.

How it works:
• Drag and drop fields to the boxes in the
layout to display data in the table.
2)Excel case: ex

• In this case :
we help the Poke Mart merchant to create a shop cart overview with prices, discount
and total price.

• Prices for items: multiply [*]


• Total price: the SUM function [sum()] ,or add [+]
• Add discount: division [/]
• Price after discount: subtract [-]

• And styling the table


•Thank you all .

You might also like