0 ratings0% found this document useful (0 votes) 10 views4 pagesHow To Make Pivot Table
طريقة عمل الجداول المحورية
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here.
Available Formats
Download as PDF or read online on Scribd
Step 1. Enter your data into
a range of rows and
columns.
Every pivot table in Excel starts with a basic
Excel table, where all your data is housed. To
create this table, I first simply enter the values
into a set of rows and columns, like the
example below.
A 5
1 First Name Last Name
2 William Evans
3 Adelaide Campbell
4 Stuart smith
5 Liliana Ross
6 Violet Hawkins
7 Alissa Morris
8 Paul Parker
9 Elise Myers
10 Stuart ‘Thompson
11 Daniel Brooks
c
‘Education
Master
Upper secondary
Master
Upper secondary
Upper secondary
Doctoral
Primary
Lower secondary
Doctoral
Master
D
Marital Status
Married
Single
Married
Single
Single
Single
Married
Married
Single
Single Step 2. Insert your pivot
table.
Inserting your pivot table is actually the
easiest part. You’ll want to:
¢ Highlight your data.
¢ Go to Insert in the top menu.
Click Pivot table.
@ Oe Autosave OD A Bor
Home Insert Draw PageLayout Formulas Data
fT ee ad S!
ol? Hey las) © ;
Recommended Table From _—Pictures. Shapes. Icons
PivotTables Picture t
AL : fe First Name
A 8 c D
Note: If you're using an earlier version of
Excel, “PivotTables” may be under Tables or
Data along the top navigation, rather than
“Insert.”
A dialog box will come up, confirming the Tt will also ask you where you want to place
your pivot table. I recommend using a new
worksheet.
Create PivotTable
Choose the data that you want to analyze.
O Select a table or range
‘Table/Range: ['Random generator'!SA$1:SDS11
Use an external data source
No data fields have been retrieved.
Choose where to place the PivotTable.
© New worksheet
Existing worksheet
‘Table/Range: oe
Cancel
You typically won’t have to edit the options
unless you want to change your selected table
and change the location of your pivot table.
Once you’ve double-checked everything, click
OK. You will then get an empty result like this:
PivotTablet
To build a report, choosefields from the
PivotTable Field List
eevonsunn|
O80
This is where it gets a little confusing and
where I used to stop as a beginner because I
was so thrown off. We'll be editing the pivot
