Scribd Logo
Upload

Welcome to Scribd!

  • 52 views

    Pivot Table

    Uploaded by

    Susilo Ragil
    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.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Pivot Table

    Uploaded by

    Susilo Ragil
    52 views7 pages
    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.

    Original Description:

    CARA BELAJAR PIVOT TABLE MULAI DARI DASAR

    Original Title

    PIVOT TABLE

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    52 views7 pages

    Pivot Table

    Uploaded by

    Susilo Ragil
    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.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 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