Scribd
Upload
103 views7 pages

Pivot Table

1. The document explains the steps to create a pivot table in Excel, which allows static data to be organized dynamically. 2. The main steps are to prepare the source data, insert a pivot table by selecting the data range, and use the four main pivot table menus - filter, row, column, and value - to analyze the data. 3. An example shows sales data that can be analyzed in a pivot table by salesperson, month, and revenue amount.

Uploaded by

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

Pivot Table

1. The document explains the steps to create a pivot table in Excel, which allows static data to be organized dynamically. 2. The main steps are to prepare the source data, insert a pivot table by selecting the data range, and use the four main pivot table menus - filter, row, column, and value - to analyze the data. 3. An example shows sales data that can be analyzed in a pivot table by salesperson, month, and revenue amount.

Uploaded by

Susilo Ragil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

PIVOT BOLA BASKET PIVOT TABLE EXCEL

Pivot table digunakan untuk mengolah


PIVOT : POROS data statis menjadi data yang bersifat
dinamis dan interaktif.

Apa Yang Di-PIVOT ? | 4 Menu Utama Pivot Table

4 Filter -> Opsi filter baik untuk row ataupun colu

2
Column 1 Column 2
Row 1 Value Value
Row 2 Value Value
Row 3 Value Value
Row 4 Value Value
Row 5 Value Value
1
3

Tahapan Utama Membuat Pivot Table


1. Siapkan data
2. Ubah data menjadi Tabel Dinamis (Rekomendasi)
3. Klik salah satu sel dalam tabel kemudian pilih menu INSERT dan PIVOTTABLE
4. Pilih table atau range yang akan diolah dan tentukan lokasi pivot table
5. Mulai berkreasi dengan 4 menu utama pivot table
6. Membuat pivot lebih cantik dan dinamis dengan tambahan grafik, slicer dan timeline
uk mengolah
yang bersifat
aktif.

ter baik untuk row ataupun column

Column 3 Column 4 Column 5


Value Value Value
Value Value Value
Value Value Value
Value Value Value
Value Value Value
n PIVOTTABLE

fik, slicer dan timeline


1. Tabel Dinamis 8. Design - Subtotal, Grand Total & Blank Rows
2. Insert Pivot Table (source data & location) 9. Double Values
3. Field, Field List & 4 menu utama Pivot Table 10. Show Values As
4. Delete field dari Pivot Table 11. Sort Values
5. Format number 12. Detail Values
6. Design - Customize color 13. Insert data tambahan dan refresh Pivot Table
7. Design - Report layout Pivot Table 14. Delete Pivot Table

BULAN SALESMAN REVENUE


January Agung 530,000
January Hamzah 472,000
January Agung 147,500
January Agung 319,500
January Agung 205,000
January Binsar 472,000
January Hamzah 147,500
January Agung 256,000
January Hamzah 920,000
January Binsar 640,000
February Agung 153,000
February Agung 375,000
February Hamzah 308,000
February Binsar 956,000
February Binsar 472,000
February Binsar 640,000
February Binsar 413,000
February Agung 170,000
February Hamzah 102,000
February Agung 170,000
otal & Blank Rows

n refresh Pivot Table


BULAN SALESMAN REVENUE
March Hamzah 130,000
March Agung 360,000
March Agung 400,000
March Hamzah 1,000,000
March Binsar 600,000
March Binsar 650,000
March Binsar 200,000
March Agung 720,000
March Hamzah 300,000
March Agung 378,000

You might also like