Cara Memasukkan Data ke Tabel Pivot

Unduh PDF
Disusun bersama Staf wikiHow
Unduh PDF

Artikel ini akan memandu Anda untuk memasukkan data ke tabel pivot di Microsoft Excel. Panduan ini dapat diikuti di Microsoft Excel versi Windows dan Mac.

Langkah

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5c\/Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5c\/Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Dokumen tersebut akan terbuka.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a0\/Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a0\/Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Misalnya, jika Anda sudah memiliki data di sel A1 hngga E10, Anda dapat memasukkan data di kolom F atau di baris ke-11.
    • Jika Anda hanya ingin mengubah data yang tampil di tabel pivot, ubah data tersebut di kertas kerja aktif.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9d\/Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2a\/Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2a\/Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/98\/Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/98\/Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Anda akan melihat bilah alat baru di bawah pita tersebut.
    • Jika Anda menggunakan Mac, klik tab PivotTable Analyze .
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9e\/Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9e\/Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Anda akan melihat menu drop-down .
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d1\/Add-Data-to-a-Pivot-Table-Step-8.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Add-Data-to-a-Pivot-Table-Step-8.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jendela baru akan terbuka.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c4\/Add-Data-to-a-Pivot-Table-Step-9.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Add-Data-to-a-Pivot-Table-Step-9.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik dan tarik kursor dari sel kiri atas hingga kiri bawah. Sel berisi data yang telah Anda masukkan akan ikut terpilih.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Add-Data-to-a-Pivot-Table-Step-10.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Add-Data-to-a-Pivot-Table-Step-10.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d3\/Add-Data-to-a-Pivot-Table-Step-11.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Add-Data-to-a-Pivot-Table-Step-11.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Jika Anda menambahkan kolom baru pada tabel pivot, centang kotak cek di sebelah kanan jendela Excel untuk menampilkannya.
    Iklan

Tips

  • Simpanlah tabel pivot sebelum melakukan perubahan agar Anda dapat memulihkan tabel jika terjadi kesalahan.
Iklan

wikiHow Terkait

Cara Setting Equalizer Terbaik untuk Bass
Cara
Membaca Multimeter
Cara
Mencari Foto Seseorang
Cara
Memperbaiki Print Spooler
Cara
Membuat Berkas Zip
Cara
Melakukan Reset pada PS3
Cara
Membuat sebuah Pembangkit Listrik Sederhana
Cara
Menggunakan Equalizer Grafis
Cara
Mengukur Televisi
Cara
Berpura pura Meretas
Cara
Mengukur Laptop
Cara
Memeriksa Riwayat Penelusuran Web Menggunakan Router WiFi
Cara
Mengurutkan Data secara Alfabetis di Google Docs
Cara
Mengalihkan Panggilan Telepon
Iklan

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 8.471 kali.

Apakah artikel ini membantu Anda?

Iklan