{"text_format":"3","workbook":"xlsx","n_sheets":26,"sheets":["Mulai","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","Pelajari selengkapnya"],"not_rendered":{"images":24,"defined_names":5,"pivot_tables":19},"read":"whole","date_system":"1900"}

{"sheet":"Mulai","index":0,"n_rows":5,"n_cols":1,"rows_kept":5}
["Selamat Datang\nInstruksi untuk pembaca layar: Mengoptimalkan PivotTable. PivotTable sederhana memang memberikan ringkasan data yang menyeluruh, tetapi terkadang Anda membutuhkan sesuatu yang lebih mendetail. Saat inilah kita perlu menambahkan lebih banyak bidang kolom dan baris. \nInstruksi akan menunjukkan sel mana yang harus dinavigasikan untuk menggunakan suatu fitur, atau pembacaan lebih lanjut.\nUntuk memulai, tekan CTRL+PAGE DOWN."]
["Mengoptimalkan PivotTable"]
["PivotTable sederhana memang memberikan ringkasan data yang menyeluruh,\ntetapi terkadang Anda membutuhkan sesuatu yang lebih mendetail.\nSaat inilah kita perlu menambahkan lebih banyak bidang kolom dan baris."]
["PERLU DIKETAHUI\nSudahkah Anda mengikuti tutorial pertama? Jika belum, buka File > Baru dan temukan Membuat PivotTable pertama Anda."]
["Kembali ke atas dengan menekan CTRL+HOME. Untuk memulai tur, tekan CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":16,"n_cols":9,"rows_kept":16}
["Dalam tutorial pertama, kami telah memperkenalkan konsep PivotTable kepada Anda. Kami juga menjelaskan bagaimana bidang baris dapat digunakan sebagai kondisi yang memisahkan bidang nilai.   "]
["Sel H10 hingga I14 berisi PivotTable yang merangkum data dalam sel B8 hingga E16. PivotTable ini memiliki dua kolom: Pembeli dan Jumlah dari Jumlah. Kolom Pembeli berisi nilai Ayah, Ibu, Kelly, dan Total Keseluruhan; Kolom Jumlah dari Jumlah berisi nilai Rp220, Rp270 Rp810, dan Rp1.300 Kolom Pembeli terdiri dari bidang Baris, dan kolom Jumlah dari Jumlah terdiri dari bidang Nilai."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[]
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
["Contoh ini memperlihatkan bagaimana bidang baris...","2017-01-01","Ayah","Hadiah",{"v":95,"d":"Rp95"}]
["...memisahkan bidang nilai.","2017-01-15","Ibu","Makanan",{"v":325,"d":"Rp325"},null,null,"Pembeli","Jumlah dari Jumlah"]
[null,"2017-01-17","Ibu","Tiket",{"v":250,"d":"Rp250"},null,null,"Ayah",{"v":220,"d":"Rp220"}]
[null,"2017-01-21","Ayah","Makanan",{"v":125,"d":"Rp125"},null,null,"Kelly",{"v":270,"d":"Rp270"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"},null,null,"Ibu",{"v":810,"d":"Rp810"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"},null,null,"Grand Total",{"v":1300,"d":"Rp1,300"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-02-25","Kelly","Olahraga",{"v":125,"d":"Rp125"}]

{"sheet":"2","index":2,"n_rows":108,"n_cols":7,"rows_kept":108}
["Namun, pada kali pertama melihat PivotTable, Anda mungkin membutuhkan jawaban lain dari tabel tersebut."]
["Pada kali pertama melihat PivotTable, Anda mungkin bertanya-tanya,  \"Kapan pembelian ini dilakukan?\", \"Untuk apa saja setiap orang mengeluarkan uang?\", \"Apa yang dibeli Ibu yang harganya sangat mahal?\"."]
["Dalam contoh ini, sel F11 hingga G15 memperlihatkan dua kolom PivotTable yang sama seperti sebelumnya. Kolom Pembeli adalah bidang Baris, dan berisi nilai Ayah, Ibu, Kelly, dan Total Keseluruhan; Kolom Jumlah dari Jumlah adalah bidang Nilai, dan berisi nilai Rp220, Rp270, Rp810, dan Rp1.300. "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Pembeli","Jumlah dari Jumlah"]
[{"$nulls":5},"Ayah",{"v":220,"d":"Rp220"}]
[{"$nulls":5},"Kelly",{"v":270,"d":"Rp270"}]
[{"$nulls":5},"Ibu",{"v":810,"d":"Rp810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"Rp1,300"}]
{"$rows_empty":84}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-01","Ayah","Hadiah",{"v":95,"d":"Rp95"}]
[null,"2017-01-15","Ibu","Makanan",{"v":325,"d":"Rp325"}]
[null,"2017-01-17","Ibu","Tiket",{"v":250,"d":"Rp250"}]
[null,"2017-01-21","Ayah","Makanan",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-02-25","Kelly","Olahraga",{"v":125,"d":"Rp125"}]

{"sheet":"3","index":3,"n_rows":108,"n_cols":7,"rows_kept":108}
["Semua ini adalah pertanyaan yang bagus, tetapi saat ini, mari fokus pada satu pertanyaan saja."]
["Untuk apa saja setiap orang mengeluarkan uang?"]
["Untuk rujukan, sel F11 hingga G15 memperlihatkan dua kolom PivotTable yang sama seperti sebelumnya. Kolom Pembeli adalah bidang Baris, dan berisi nilai Ayah, Ibu, Kelly, dan Total Keseluruhan; Kolom Jumlah dari Jumlah adalah bidang Nilai, dan berisi nilai Rp220, Rp270, Rp810, dan Rp1.300. "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Pembeli","Jumlah dari Jumlah"]
[{"$nulls":5},"Ayah",{"v":220,"d":"Rp220"}]
[{"$nulls":5},"Kelly",{"v":270,"d":"Rp270"}]
[{"$nulls":5},"Ibu",{"v":810,"d":"Rp810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"Rp1,300"}]
{"$rows_empty":84}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-01","Ayah","Hadiah",{"v":95,"d":"Rp95"}]
[null,"2017-01-15","Ibu","Makanan",{"v":325,"d":"Rp325"}]
[null,"2017-01-17","Ibu","Tiket",{"v":250,"d":"Rp250"}]
[null,"2017-01-21","Ayah","Makanan",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-02-25","Kelly","Olahraga",{"v":125,"d":"Rp125"}]

{"sheet":"4","index":4,"n_rows":108,"n_cols":9,"rows_kept":108}
["Pertanyaan yang terakhir ditanyakan adalah \"Untuk apa saja setiap orang mengeluarkan uang?\""]
["Kami menjawab pertanyaan tersebut dengan menambahkan bidang kolom untuk Tipe. Sekarang, PivotTable memiliki lima kolom baru tentang tipe pembelian yang dibuat oleh setiap orang. "]
["PivotTable baru kita sekarang terdiri dari sel C10 hingga I15, dengan kolom untuk Pembeli, Makanan, Musik, Olahraga, Tiket, Hadiah, dan Total Keseluruhan. Pembeli danTotal Keseluruhan sama seperti sebelumnya, dan kolom detail baru berada di antaranya."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,null,"Jumlah dari Jumlah","Tipe"]
[null,null,"Pembeli","Makanan","Musik","Olahraga","Tiket","Hadiah","Grand Total"]
[null,null,"Ayah",{"v":125,"d":"Rp125"},{"$nulls":3},{"v":95,"d":"Rp95"},{"v":220,"d":"Rp220"}]
[null,null,"Kelly",null,{"v":20,"d":"Rp20"},{"v":125,"d":"Rp125"},{"v":125,"d":"Rp125"},null,{"v":270,"d":"Rp270"}]
[null,null,"Ibu",{"v":560,"d":"Rp560"},null,null,{"v":250,"d":"Rp250"},null,{"v":810,"d":"Rp810"}]
[null,null,"Grand Total",{"v":685,"d":"Rp685"},{"v":20,"d":"Rp20"},{"v":125,"d":"Rp125"},{"v":375,"d":"Rp375"},{"v":95,"d":"Rp95"},{"v":1300,"d":"Rp1,300"}]
{"$rows_empty":84}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-01","Ayah","Hadiah",{"v":95,"d":"Rp95"}]
[null,"2017-01-15","Ibu","Makanan",{"v":325,"d":"Rp325"}]
[null,"2017-01-17","Ibu","Tiket",{"v":250,"d":"Rp250"}]
[null,"2017-01-21","Ayah","Makanan",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-02-25","Kelly","Olahraga",{"v":125,"d":"Rp125"}]

{"sheet":"5","index":5,"n_rows":108,"n_cols":9,"rows_kept":108}
["Jika PivotTable sulit dipahami, coba hal berikut: Baca dari kiri, lalu dari atas, dan kemudian ke bawah. Dalam contoh di bawah ini, Ayah ada di sel C12, Makanan sejumlah Rp125 ada di sel D12, Hadiah sebesar Rp94 di sel E12, dan Total Keseluruhan sebesar Rp220 di sel I12. Baris 13 dan 14 memperlihatkan detail untuk Kelly dan Ibu, dan baris 15 memperlihatkan Total Keseluruhan."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
{"$rows_empty":7}
[null,null,"Jumlah dari Jumlah","Tipe"]
[null,null,"Pembeli","Makanan","Hadiah","Musik","Olahraga","Tiket","Grand Total"]
[null,null,"Ayah",{"v":125,"d":"Rp125"},{"v":95,"d":"Rp95"},{"$nulls":3},{"v":220,"d":"Rp220"}]
[null,null,"Kelly",null,null,{"v":20,"d":"Rp20"},{"v":125,"d":"Rp125"},{"v":125,"d":"Rp125"},{"v":270,"d":"Rp270"}]
[null,null,"Ibu",{"v":560,"d":"Rp560"},{"$nulls":3},{"v":250,"d":"Rp250"},{"v":810,"d":"Rp810"}]
[null,null,"Grand Total",{"v":685,"d":"Rp685"},{"v":95,"d":"Rp95"},{"v":20,"d":"Rp20"},{"v":125,"d":"Rp125"},{"v":375,"d":"Rp375"},{"v":1300,"d":"Rp1,300"}]
{"$rows_empty":84}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-01","Ayah","Hadiah",{"v":95,"d":"Rp95"}]
[null,"2017-01-15","Ibu","Makanan",{"v":325,"d":"Rp325"}]
[null,"2017-01-17","Ibu","Tiket",{"v":250,"d":"Rp250"}]
[null,"2017-01-21","Ayah","Makanan",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-02-25","Kelly","Olahraga",{"v":125,"d":"Rp125"}]

{"sheet":"6","index":6,"n_rows":3,"n_cols":1,"rows_kept":3}
["Jangan lakukan sekarang, dalam beberapa langkah, Anda akan bekerja dengan PivotTable. Hal pertama yang perlu Anda lakukan adalah membuat detail dalam bidang Kolom. Lakukan dengan menempatkan bidang Tipe di area bidang Kolom."]
["Gambar Daftar Bidang PivotTable memperlihatkan kursor panah menyeret bidang Tipe ke area Kolom."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]

{"sheet":"7","index":7,"n_rows":108,"n_cols":8,"rows_kept":108}
["1. Area PivotTable untuk contoh ini berada di sel B13 hingga C17. Navigasikan ke salah satu sel tersebut."]
["2. Tekan ALT+JL, V untuk meluncurkan Daftar Bidang PivotTable. Secara default, fokus terletak dalam kotak teks Cari: Pengeditan \"Cari\""]
["3. Tekan tombol panah untuk memilih bidang Tipe. Setelah dipilih, tekan SPACEBAR untuk menambahkan bidang Tipe ke area Baris. "]
["4. Tekan Tab untuk memilih bidang Tipe. Tekan Enter, lalu tekan tombol panah untuk memilih Pindahkan ke Label Kolom, lalu tekan Enter untuk menambahkan bidang Tipe ke area Kolom. Tekan ALT+JL+V untuk keluar dari panel Bidang PivotTable."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Pembeli\",$H$17=810),\"Kerja bagus! Anda sudah menempatkan\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Pembeli\",$H$17=810),\"bidang kolom pertama. Klik\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Pembeli\",$H$17=810),\"Berikutnya untuk melanjutkan...\",\" \")","v":" "}]
[]
[null,"Pembeli","Jumlah dari Jumlah"]
[null,"Ayah",{"v":220,"d":"Rp220"}]
[null,"Kelly",{"v":270,"d":"Rp270"}]
[null,"Ibu",{"v":810,"d":"Rp810"}]
[null,"Total Keseluruhan",{"v":1300,"d":"Rp1,300"}]
{"$rows_empty":82}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-01","Ayah","Hadiah",{"v":95,"d":"Rp95"}]
[null,"2017-01-15","Ibu","Makanan",{"v":325,"d":"Rp325"}]
[null,"2017-01-17","Ibu","Tiket",{"v":250,"d":"Rp250"}]
[null,"2017-01-21","Ayah","Makanan",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-02-25","Kelly","Olahraga",{"v":125,"d":"Rp125"}]

{"sheet":"8","index":8,"n_rows":108,"n_cols":9,"rows_kept":108}
["Mari tinjau PivotTable yang baru saja dibuat, tetapi kali ini kami telah menambahkan beberapa warna khusus untuk membedakan bidang baris, kolom, dan nilai."]
["Bidang baris dimulai dari sel C10 hingga C13, dan diberi warna kuning."]
["Bidang kolom dimulai dari sel D9 hingga H10, dan diberi warna oranye."]
["Bidang nilai dimulai dari sel D11 hingga H13, dan diberi warna biru."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[null,null,"Jumlah dari Jumlah","Tipe"]
[null,null,"Pembeli","Makanan","Hadiah","Musik","Olahraga","Tiket","Grand Total"]
[null,null,"Ayah",{"v":125,"d":"Rp125"},{"v":95,"d":"Rp95"},{"$nulls":3},{"v":220,"d":"Rp220"}]
[null,null,"Kelly",null,null,{"v":20,"d":"Rp20"},{"v":125,"d":"Rp125"},{"v":125,"d":"Rp125"},{"v":270,"d":"Rp270"}]
[null,null,"Ibu",{"v":560,"d":"Rp560"},{"$nulls":3},{"v":250,"d":"Rp250"},{"v":810,"d":"Rp810"}]
[null,null,"Grand Total",{"v":685,"d":"Rp685"},{"v":95,"d":"Rp95"},{"v":20,"d":"Rp20"},{"v":125,"d":"Rp125"},{"v":375,"d":"Rp375"},{"v":1300,"d":"Rp1,300"}]
{"$rows_empty":85}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-01","Ayah","Hadiah",{"v":95,"d":"Rp95"}]
[null,"2017-01-15","Ibu","Makanan",{"v":325,"d":"Rp325"}]
[null,"2017-01-17","Ibu","Tiket",{"v":250,"d":"Rp250"}]
[null,"2017-01-21","Ayah","Makanan",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-02-25","Kelly","Olahraga",{"v":125,"d":"Rp125"}]

{"sheet":"9","index":9,"n_rows":3,"n_cols":1,"rows_kept":3}
["Berikut cara lain untuk mengingatnya: Bidang baris ada di bagian kiri, dan bidang kolom di bagian atas. Masing-masing menyediakan kondisi ke bidang nilai yang kemudian menjumlahkannya."]
["Gambar konseptual memperlihatkan area persegi 4 bagian dengan bidang Baris berwarna kuning di kiri bawah, bidang Kolom berwarna oranye di kanan atas, dan bidang Nilai berwarna biru di kanan bawah."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]

{"sheet":"10","index":10,"n_rows":3,"n_cols":1,"rows_kept":3}
["Anggaplah demikian saat menggunakan daftar bidang. Bidang baris ada di bagian kiri, dan bidang kolom di bagian atas. Masing-masing menyediakan kondisi ke bidang nilai yang kemudian menjumlahkannya."]
["Gambar konseptual memperlihatkan Daftar Bidang PivotTable yang ditampilkan dengan bidang Baris berwarna kuning di kiri bawah, bidang Kolom berwarna oranye di kanan atas, dan bidang Nilai berwarna biru di kanan bawah."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]

{"sheet":"11","index":11,"n_rows":121,"n_cols":24,"rows_kept":121}
["Satu hal yang perlu diperhatikan: Jika bidang kolom menambahkan banyak kolom, PivotTable akan menjadi sangat lebar. "]
["Dalam contoh ini, rentang PivotTable sekarang dimulai dari sel C10 hingga X15 karena bidang kolom menambahkan 20 kolom baru. Jumlah yang cukup banyak! Orang-orang mungkin akan terlalu banyak menggulir... "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,null,"Jumlah dari Jumlah","Tipe"]
[null,null,"Pembeli","Asuransi kendaraan","Asuransi kesehatan","Asuransi rumah","Bahan bakar","Buku","Elektronik","Iuran klub","Les musik","Listrik","Makan di Luar","Makanan","Medis","Musik","Olahraga","Pajak","Pakaian","Parkir","Perawatan Gigi","Tiket","Tiket pesawat","Grand Total"]
[null,null,"Ayah",{"$nulls":13},{"v":1000,"d":"Rp1,000"},{"v":500,"d":"Rp500"},{"$nulls":4},{"v":500,"d":"Rp500"},{"v":2000,"d":"Rp2,000"}]
[null,null,"Ibu",{"v":74,"d":"Rp74"},{"v":70,"d":"Rp70"},{"v":235,"d":"Rp235"},{"v":74,"d":"Rp74"},null,null,{"v":125,"d":"Rp125"},null,{"v":70,"d":"Rp70"},null,{"v":470,"d":"Rp470"},{"v":74,"d":"Rp74"},{"$nulls":5},{"v":235,"d":"Rp235"},null,null,{"v":1427,"d":"Rp1,427"}]
[null,null,"Kelly",{"$nulls":4},{"v":250,"d":"Rp250"},{"v":125,"d":"Rp125"},null,{"v":250,"d":"Rp250"},null,{"v":20,"d":"Rp20"},null,null,{"v":20,"d":"Rp20"},null,null,{"v":125,"d":"Rp125"},{"v":20,"d":"Rp20"},null,{"v":125,"d":"Rp125"},null,{"v":935,"d":"Rp935"}]
[null,null,"Grand Total",{"v":74,"d":"Rp74"},{"v":70,"d":"Rp70"},{"v":235,"d":"Rp235"},{"v":74,"d":"Rp74"},{"v":250,"d":"Rp250"},{"v":125,"d":"Rp125"},{"v":125,"d":"Rp125"},{"v":250,"d":"Rp250"},{"v":70,"d":"Rp70"},{"v":20,"d":"Rp20"},{"v":470,"d":"Rp470"},{"v":74,"d":"Rp74"},{"v":20,"d":"Rp20"},{"v":1000,"d":"Rp1,000"},{"v":500,"d":"Rp500"},{"v":125,"d":"Rp125"},{"v":20,"d":"Rp20"},{"v":235,"d":"Rp235"},{"v":125,"d":"Rp125"},{"v":500,"d":"Rp500"},{"v":4362,"d":"Rp4,362"}]
{"$rows_empty":84}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-17","Ayah","Olahraga",{"v":1000,"d":"Rp1,000"}]
[null,"2017-01-17","Ayah","Tiket pesawat",{"v":500,"d":"Rp500"}]
[null,"2017-01-17","Ayah","Pajak",{"v":500,"d":"Rp500"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Buku",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Makan di Luar",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Pakaian",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Les musik",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Parkir",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Elektronik",{"v":125,"d":"Rp125"}]
[null,"2017-01-01","Ibu","Bahan bakar",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-21","Ibu","Iuran klub",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Medis",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Listrik",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Perawatan Gigi",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Asuransi rumah",{"v":235,"d":"Rp235"}]

{"sheet":"12","index":12,"n_rows":119,"n_cols":5,"rows_kept":119}
["Terdapat alternatif untuk membuat PivotTable yang sangat lebar: Anda dapat menggunakan bidang baris kedua sebagai gantinya. Bidang baris kedua akan muncul dengan inden di bawah bidang baris pertama."]
["Dalam contoh ini, terdapat PivotTable dari sel D8 hingga E32. PivotTable tersebut menampilkan Ayah, Kelly, dan Ibu sebagai bidang baris pertama di kolom D. Tipe pengeluaran ada di bawahnya sebagai bidang baris kedua dengan item seperti Olahraga, Tiket Pesawat, Makan di Luar, dll."]
["PERLU DIKETAHUI\nBidang baris kedua membuat PivotTable dengan orientasi vertikal, bukan horizontal. Beberapa orang merasa PivotTable vertikal lebih mudah dibaca karena tidak terlalu memerlukan pengguliran dari sisi ke sisi."]
["EXCEL BERKATA\nTerkadang, orang menyebut bidang baris kedua sebagai \"bidang baris sekunder.\""]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[{"$nulls":3},"Row Labels","Jumlah dari Jumlah"]
[{"$nulls":3},"Ayah",{"v":2000,"d":"Rp2,000"}]
[{"$nulls":3},"Olahraga",{"v":1000,"d":"Rp1,000"}]
[{"$nulls":3},"Pajak",{"v":500,"d":"Rp500"}]
[{"$nulls":3},"Tiket pesawat",{"v":500,"d":"Rp500"}]
[{"$nulls":3},"Kelly",{"v":935,"d":"Rp935"}]
[{"$nulls":3},"Buku",{"v":250,"d":"Rp250"}]
[{"$nulls":3},"Elektronik",{"v":125,"d":"Rp125"}]
[{"$nulls":3},"Les musik",{"v":250,"d":"Rp250"}]
[{"$nulls":3},"Makan di Luar",{"v":20,"d":"Rp20"}]
[{"$nulls":3},"Musik",{"v":20,"d":"Rp20"}]
[{"$nulls":3},"Pakaian",{"v":125,"d":"Rp125"}]
[{"$nulls":3},"Parkir",{"v":20,"d":"Rp20"}]
[{"$nulls":3},"Tiket",{"v":125,"d":"Rp125"}]
[{"$nulls":3},"Ibu",{"v":1427,"d":"Rp1,427"}]
[{"$nulls":3},"Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[{"$nulls":3},"Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[{"$nulls":3},"Asuransi rumah",{"v":235,"d":"Rp235"}]
[{"$nulls":3},"Bahan bakar",{"v":74,"d":"Rp74"}]
[{"$nulls":3},"Iuran klub",{"v":125,"d":"Rp125"}]
[{"$nulls":3},"Listrik",{"v":70,"d":"Rp70"}]
[{"$nulls":3},"Makanan",{"v":470,"d":"Rp470"}]
[{"$nulls":3},"Medis",{"v":74,"d":"Rp74"}]
[{"$nulls":3},"Perawatan Gigi",{"v":235,"d":"Rp235"}]
[{"$nulls":3},"Grand Total",{"v":4362,"d":"Rp4,362"}]
{"$rows_empty":65}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-17","Ayah","Olahraga",{"v":1000,"d":"Rp1,000"}]
[null,"2017-01-17","Ayah","Tiket pesawat",{"v":500,"d":"Rp500"}]
[null,"2017-01-17","Ayah","Pajak",{"v":500,"d":"Rp500"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Buku",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Makan di Luar",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Pakaian",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Les musik",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Parkir",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Elektronik",{"v":125,"d":"Rp125"}]
[null,"2017-01-01","Ibu","Bahan bakar",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-21","Ibu","Iuran klub",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Medis",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Listrik",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Perawatan Gigi",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Asuransi rumah",{"v":235,"d":"Rp235"}]

{"sheet":"13","index":13,"n_rows":3,"n_cols":1,"rows_kept":3}
["Pada lembar berikutnya, Anda akan menambahkan bidang baris kedua. Lakukan dengan meletakkan bidang Tipe ke bawah bidang Pembeli di bidang Baris."]
["Gambar Daftar Bidang PivotTable memperlihatkan kursor panah menyeret bidang Tipe ke area Baris."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]

{"sheet":"14","index":14,"n_rows":122,"n_cols":9,"rows_kept":122}
["1. Area PivotTable untuk contoh ini berada di sel B13 hingga C17. Navigasikan ke salah satu sel tersebut. "]
["2. Tekan ALT+JL, V untuk meluncurkan Daftar Bidang PivotTable. Secara default, Fokus akan terletak pada kotak teks Cari: Pengeditan \"Ketikkan kata yang akan dicari\". Jangan ketik apa pun, tetapi tekan tab satu kali. CATATAN: jika Daftar Bidang tidak muncul, tekan ALT+JL, V lagi."]
["3. Tekan tombol panah untuk berpindah ke bidang Tipe. Tekan SPACEBAR untuk menambahkan bidang Tipe ke area Baris. "]
["4. Tekan ESC untuk keluar dari panel Bidang PivotTable. "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP.",{"$nulls":7},{"$f":"IF(AND($B$15=\"Olahraga\",$C$36=235),\"Bagus sekali! Anda sudah\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Olahraga\",$C$36=235),\"menambahkan bidang baris\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Olahraga\",$C$36=235),\"kedua ke PivotTable. Gulir \",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Olahraga\",$C$36=235),\"ke bawah dan klik Berikutnya...\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"Row Labels","Jumlah dari Jumlah"]
[null,"Ayah",{"v":2000,"d":"Rp2,000"}]
[null,"Kelly",{"v":935,"d":"Rp935"}]
[null,"Ibu",{"v":1427,"d":"Rp1,427"}]
[null,"Grand Total",{"v":4362,"d":"Rp4,362"}]
{"$rows_empty":83}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-17","Ayah","Olahraga",{"v":1000,"d":"Rp1,000"}]
[null,"2017-01-17","Ayah","Tiket pesawat",{"v":500,"d":"Rp500"}]
[null,"2017-01-17","Ayah","Pajak",{"v":500,"d":"Rp500"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Buku",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Makan di Luar",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Pakaian",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Les musik",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Parkir",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Elektronik",{"v":125,"d":"Rp125"}]
[null,"2017-01-01","Ibu","Bahan bakar",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-21","Ibu","Iuran klub",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Medis",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Listrik",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Perawatan Gigi",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Asuransi rumah",{"v":235,"d":"Rp235"}]

{"sheet":"15","index":15,"n_rows":121,"n_cols":7,"rows_kept":121}
["Jika perlu menyederhanakan PivotTable, Anda dapat menciutkan data untuk bidang baris kedua \"ke atas\" agar terlihat lebih rapi. "]
["PivotTable untuk contoh ini ada di sel F7 hingga G31. Pilih sel F8 untuk memilih bidang baris pertama untuk Ayah. Berikutnya, tekan Alt+JL > X untuk memperluas bidang kedua, atau P untuk menciutkannya."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"Kelly\",$G$9=935),\"Bagus!\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","Jumlah dari Jumlah"]
[{"$nulls":5},"Ayah",{"v":2000,"d":"Rp2,000"}]
[{"$nulls":5},"Olahraga",{"v":1000,"d":"Rp1,000"}]
[{"$nulls":5},"Pajak",{"v":500,"d":"Rp500"}]
[{"$nulls":5},"Tiket pesawat",{"v":500,"d":"Rp500"}]
[{"$nulls":5},"Kelly",{"v":935,"d":"Rp935"}]
[{"$nulls":5},"Buku",{"v":250,"d":"Rp250"}]
[{"$nulls":5},"Elektronik",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Les musik",{"v":250,"d":"Rp250"}]
[{"$nulls":5},"Makan di Luar",{"v":20,"d":"Rp20"}]
[{"$nulls":5},"Musik",{"v":20,"d":"Rp20"}]
[{"$nulls":5},"Pakaian",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Parkir",{"v":20,"d":"Rp20"}]
[{"$nulls":5},"Tiket",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Ibu",{"v":1427,"d":"Rp1,427"}]
[{"$nulls":5},"Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[{"$nulls":5},"Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[{"$nulls":5},"Asuransi rumah",{"v":235,"d":"Rp235"}]
[{"$nulls":5},"Bahan bakar",{"v":74,"d":"Rp74"}]
[{"$nulls":5},"Iuran klub",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Listrik",{"v":70,"d":"Rp70"}]
[{"$nulls":5},"Makanan",{"v":470,"d":"Rp470"}]
[{"$nulls":5},"Medis",{"v":74,"d":"Rp74"}]
[{"$nulls":5},"Perawatan Gigi",{"v":235,"d":"Rp235"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"Rp4,362"}]
{"$rows_empty":68}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-17","Ayah","Olahraga",{"v":1000,"d":"Rp1,000"}]
[null,"2017-01-17","Ayah","Tiket pesawat",{"v":500,"d":"Rp500"}]
[null,"2017-01-17","Ayah","Pajak",{"v":500,"d":"Rp500"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Buku",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Makan di Luar",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Pakaian",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Les musik",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Parkir",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Elektronik",{"v":125,"d":"Rp125"}]
[null,"2017-01-01","Ibu","Bahan bakar",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-21","Ibu","Iuran klub",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Medis",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Listrik",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Perawatan Gigi",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Asuransi rumah",{"v":235,"d":"Rp235"}]

{"sheet":"16","index":16,"n_rows":121,"n_cols":7,"rows_kept":121}
["Anda juga dapat menciutkan atau memperluas seluruh bidang baris kedua untuk lebih menyederhanakan PivotTable."]
["Inilah Kuncinya"]
["Pilih rentang data PivotTable dari sel F7 hingga G31, lalu tekan ALT+JL > P untuk menciutkan seluruh grup. Sebaliknya, ALT+JL > X akan memperluas seluruh grup."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"Kelly\",$G$9=935),\"Benar sekali!\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","Jumlah dari Jumlah"]
[{"$nulls":5},"Ayah",{"v":2000,"d":"Rp2,000"}]
[{"$nulls":5},"Olahraga",{"v":1000,"d":"Rp1,000"}]
[{"$nulls":5},"Pajak",{"v":500,"d":"Rp500"}]
[{"$nulls":5},"Tiket pesawat",{"v":500,"d":"Rp500"}]
[{"$nulls":5},"Kelly",{"v":935,"d":"Rp935"}]
[{"$nulls":5},"Buku",{"v":250,"d":"Rp250"}]
[{"$nulls":5},"Elektronik",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Les musik",{"v":250,"d":"Rp250"}]
[{"$nulls":5},"Makan di Luar",{"v":20,"d":"Rp20"}]
[{"$nulls":5},"Musik",{"v":20,"d":"Rp20"}]
[{"$nulls":5},"Pakaian",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Parkir",{"v":20,"d":"Rp20"}]
[{"$nulls":5},"Tiket",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Ibu",{"v":1427,"d":"Rp1,427"}]
[{"$nulls":5},"Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[{"$nulls":5},"Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[{"$nulls":5},"Asuransi rumah",{"v":235,"d":"Rp235"}]
[{"$nulls":5},"Bahan bakar",{"v":74,"d":"Rp74"}]
[{"$nulls":5},"Iuran klub",{"v":125,"d":"Rp125"}]
[{"$nulls":5},"Listrik",{"v":70,"d":"Rp70"}]
[{"$nulls":5},"Makanan",{"v":470,"d":"Rp470"}]
[{"$nulls":5},"Medis",{"v":74,"d":"Rp74"}]
[{"$nulls":5},"Perawatan Gigi",{"v":235,"d":"Rp235"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"Rp4,362"}]
{"$rows_empty":68}
[null,"Tanggal","Pembeli","Tipe","Jumlah"]
[null,"2017-01-17","Ayah","Olahraga",{"v":1000,"d":"Rp1,000"}]
[null,"2017-01-17","Ayah","Tiket pesawat",{"v":500,"d":"Rp500"}]
[null,"2017-01-17","Ayah","Pajak",{"v":500,"d":"Rp500"}]
[null,"2017-02-20","Kelly","Musik",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Tiket",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Buku",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Makan di Luar",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Pakaian",{"v":125,"d":"Rp125"}]
[null,"2017-01-21","Kelly","Les musik",{"v":250,"d":"Rp250"}]
[null,"2017-02-20","Kelly","Parkir",{"v":20,"d":"Rp20"}]
[null,"2017-02-25","Kelly","Elektronik",{"v":125,"d":"Rp125"}]
[null,"2017-01-01","Ibu","Bahan bakar",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-21","Ibu","Iuran klub",{"v":125,"d":"Rp125"}]
[null,"2017-02-02","Ibu","Makanan",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Medis",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Listrik",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Perawatan Gigi",{"v":235,"d":"Rp235"}]
[null,"2017-01-01","Ibu","Asuransi kendaraan",{"v":74,"d":"Rp74"}]
[null,"2017-01-15","Ibu","Asuransi kesehatan",{"v":70,"d":"Rp70"}]
[null,"2017-02-02","Ibu","Asuransi rumah",{"v":235,"d":"Rp235"}]

{"sheet":"17","index":17,"n_rows":107,"n_cols":13,"rows_kept":107}
["Anda juga dapat menggunakan lebih dari satu bidang kolom. Bidang tersebut juga dapat diciutkan atau diperluas."]
["PivotTable untuk contoh ini ada dari sel B13 hingga M19. Dalam hal ini, terdapat kategori Tipe di bagian Kolom, yang menyertakan item untuk Makanan dan Utilitas."]
["COBA INI\nPilih Makanan di sel C14 dan tekan ALT+JL > P untuk menciutkan seluruh bidang. ALT+JL > X akan memperluasnya."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
{"$rows_empty":7}
[null,null,{"$f":"IF(AND($C$16=398,$D$15=\"Jan\"),\"Kerja bagus!\",\" \")","v":" "}]
[null,"Jumlah dari Jumlah","Column Labels"]
[null,null,"Makanan",{"$nulls":3},"Makanan Total","Utilitas",{"$nulls":3},"Utilitas Total","Grand Total"]
[null,"Row Labels","Jan","Feb","Mar","Apr",null,"Jan","Feb","Mar","Apr"]
[null,"Kelly",{"v":74,"d":"Rp74"},{"v":74,"d":"Rp74"},{"v":125,"d":"Rp125"},{"v":125,"d":"Rp125"},{"v":398,"d":"Rp398"},{"$nulls":5},{"v":398,"d":"Rp398"}]
[null,"Ayah",{"v":235,"d":"Rp235"},{"v":235,"d":"Rp235"},{"v":235,"d":"Rp235"},{"v":74,"d":"Rp74"},{"v":779,"d":"Rp779"},{"$nulls":5},{"v":779,"d":"Rp779"}]
[null,"Ibu",{"$nulls":5},{"v":1000,"d":"Rp1,000"},{"v":1000,"d":"Rp1,000"},{"v":20,"d":"Rp20"},{"v":70,"d":"Rp70"},{"v":2090,"d":"Rp2,090"},{"v":2090,"d":"Rp2,090"}]
[null,"Grand Total",{"v":309,"d":"Rp309"},{"v":309,"d":"Rp309"},{"v":360,"d":"Rp360"},{"v":199,"d":"Rp199"},{"v":1177,"d":"Rp1,177"},{"v":1000,"d":"Rp1,000"},{"v":1000,"d":"Rp1,000"},{"v":20,"d":"Rp20"},{"v":70,"d":"Rp70"},{"v":2090,"d":"Rp2,090"},{"v":3267,"d":"Rp3,267"}]
{"$rows_empty":75}
[null,"Bulan","Pembeli","Tipe","Jumlah"]
[null,"Jan","Kelly","Makanan",{"v":74,"d":"Rp74"}]
[null,"Jan","Ayah","Makanan",{"v":235,"d":"Rp235"}]
[null,"Jan","Ibu","Utilitas",{"v":1000,"d":"Rp1,000"}]
[null,"Feb","Kelly","Makanan",{"v":74,"d":"Rp74"}]
[null,"Feb","Ayah","Makanan",{"v":235,"d":"Rp235"}]
[null,"Feb","Ibu","Utilitas",{"v":1000,"d":"Rp1,000"}]
[null,"Mar","Kelly","Makanan",{"v":125,"d":"Rp125"}]
[null,"Mar","Ayah","Makanan",{"v":235,"d":"Rp235"}]
[null,"Mar","Ibu","Utilitas",{"v":20,"d":"Rp20"}]
[null,"Apr","Kelly","Makanan",{"v":125,"d":"Rp125"}]
[null,"Apr","Ayah","Makanan",{"v":74,"d":"Rp74"}]
[null,"Apr","Ibu","Utilitas",{"v":70,"d":"Rp70"}]

{"sheet":"18","index":18,"n_rows":146,"n_cols":5,"rows_kept":146}
["Yang perlu diingat: Jika memerlukan detail selengkapnya, silakan tambahkan lebih banyak bidang baris atau bidang kolom. Terdapat tiga bidang baris dalam contoh ini."]
["Rentang PivotTable untuk contoh ini dimulai dari sel D8 hingga E29, dan memiliki bidang untuk Musim, Pembeli, dan Tipe di kolom D, dengan Jumlah dari Jumlah di kolom E."]
["TIPS AHLI\nAnda memang dapat menambahkan banyak bidang, tetapi bukan berarti hal tersebut perlu dilakukan. Dalam contoh ini, tabel berfungsi dengan baik, tetapi terlalu banyak bidang dengan semua indentasinya terkadang dapat membuat PivotTable terlalu rumit untuk dipahami orang lain. "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[{"$nulls":3},"Row Labels","Jumlah dari Jumlah"]
[{"$nulls":3},"Musim gugur",{"v":5425,"d":"Rp5,425"}]
[{"$nulls":3},"Ibu",{"v":5425,"d":"Rp5,425"}]
[{"$nulls":3},"Asuransi",{"v":1272,"d":"Rp1,272"}]
[{"$nulls":3},"Sewa",{"v":3220,"d":"Rp3,220"}]
[{"$nulls":3},"Utilitas",{"v":933,"d":"Rp933"}]
[{"$nulls":3},"Musim semi",{"v":4760,"d":"Rp4,760"}]
[{"$nulls":3},"Ayah",{"v":4760,"d":"Rp4,760"}]
[{"$nulls":3},"Asuransi",{"v":1040,"d":"Rp1,040"}]
[{"$nulls":3},"Sewa",{"v":2400,"d":"Rp2,400"}]
[{"$nulls":3},"Utilitas",{"v":1320,"d":"Rp1,320"}]
[{"$nulls":3},"Musim panas",{"v":3473,"d":"Rp3,473"}]
[{"$nulls":3},"Ibu",{"v":3473,"d":"Rp3,473"}]
[{"$nulls":3},"Asuransi",{"v":1080,"d":"Rp1,080"}]
[{"$nulls":3},"Sewa",{"v":1260,"d":"Rp1,260"}]
[{"$nulls":3},"Utilitas",{"v":1133,"d":"Rp1,133"}]
[{"$nulls":3},"Musim dingin",{"v":4100,"d":"Rp4,100"}]
[{"$nulls":3},"Ayah",{"v":4100,"d":"Rp4,100"}]
[{"$nulls":3},"Asuransi",{"v":1030,"d":"Rp1,030"}]
[{"$nulls":3},"Sewa",{"v":1420,"d":"Rp1,420"}]
[{"$nulls":3},"Utilitas",{"v":1650,"d":"Rp1,650"}]
[{"$nulls":3},"Grand Total",{"v":17758,"d":"Rp17,758"}]
{"$rows_empty":68}
[null,"Pembeli","Musim","Tipe","Jumlah"]
[null,"Ayah","Musim dingin","Asuransi",{"v":300,"d":"Rp300"}]
[null,"Ayah","Musim dingin","Sewa",{"v":200,"d":"Rp200"}]
[null,"Ayah","Musim dingin","Utilitas",{"v":400,"d":"Rp400"}]
[null,"Ayah","Musim dingin","Asuransi",{"v":300,"d":"Rp300"}]
[null,"Ayah","Musim dingin","Sewa",{"v":800,"d":"Rp800"}]
[null,"Ayah","Musim dingin","Utilitas",{"v":400,"d":"Rp400"}]
[null,"Ayah","Musim dingin","Asuransi",{"v":200,"d":"Rp200"}]
[null,"Ayah","Musim dingin","Sewa",{"v":300,"d":"Rp300"}]
[null,"Ayah","Musim dingin","Utilitas",{"v":450,"d":"Rp450"}]
[null,"Ayah","Musim dingin","Asuransi",{"v":230,"d":"Rp230"}]
[null,"Ayah","Musim dingin","Sewa",{"v":120,"d":"Rp120"}]
[null,"Ayah","Musim dingin","Utilitas",{"v":400,"d":"Rp400"}]
[null,"Ayah","Musim semi","Asuransi",{"v":210,"d":"Rp210"}]
[null,"Ayah","Musim semi","Sewa",{"v":300,"d":"Rp300"}]
[null,"Ayah","Musim semi","Utilitas",{"v":400,"d":"Rp400"}]
[null,"Ayah","Musim semi","Asuransi",{"v":230,"d":"Rp230"}]
[null,"Ayah","Musim semi","Sewa",{"v":900,"d":"Rp900"}]
[null,"Ayah","Musim semi","Utilitas",{"v":300,"d":"Rp300"}]
[null,"Ayah","Musim semi","Asuransi",{"v":200,"d":"Rp200"}]
[null,"Ayah","Musim semi","Sewa",{"v":1000,"d":"Rp1,000"}]
[null,"Ayah","Musim semi","Utilitas",{"v":220,"d":"Rp220"}]
[null,"Ayah","Musim semi","Asuransi",{"v":400,"d":"Rp400"}]
[null,"Ayah","Musim semi","Sewa",{"v":200,"d":"Rp200"}]
[null,"Ayah","Musim semi","Utilitas",{"v":400,"d":"Rp400"}]
[null,"Ibu","Musim panas","Asuransi",{"v":100,"d":"Rp100"}]
[null,"Ibu","Musim panas","Sewa",{"v":30,"d":"Rp30"}]
[null,"Ibu","Musim panas","Utilitas",{"v":123,"d":"Rp123"}]
[null,"Ibu","Musim panas","Asuransi",{"v":300,"d":"Rp300"}]
[null,"Ibu","Musim panas","Sewa",{"v":350,"d":"Rp350"}]
[null,"Ibu","Musim panas","Utilitas",{"v":230,"d":"Rp230"}]
[null,"Ibu","Musim panas","Asuransi",{"v":120,"d":"Rp120"}]
[null,"Ibu","Musim panas","Sewa",{"v":640,"d":"Rp640"}]
[null,"Ibu","Musim panas","Utilitas",{"v":530,"d":"Rp530"}]
[null,"Ibu","Musim panas","Asuransi",{"v":560,"d":"Rp560"}]
[null,"Ibu","Musim panas","Sewa",{"v":240,"d":"Rp240"}]
[null,"Ibu","Musim panas","Utilitas",{"v":250,"d":"Rp250"}]
[null,"Ibu","Musim gugur","Asuransi",{"v":62,"d":"Rp62"}]
[null,"Ibu","Musim gugur","Sewa",{"v":600,"d":"Rp600"}]
[null,"Ibu","Musim gugur","Utilitas",{"v":340,"d":"Rp340"}]
[null,"Ibu","Musim gugur","Asuransi",{"v":205,"d":"Rp205"}]
[null,"Ibu","Musim gugur","Sewa",{"v":500,"d":"Rp500"}]
[null,"Ibu","Musim gugur","Utilitas",{"v":403,"d":"Rp403"}]
[null,"Ibu","Musim gugur","Asuransi",{"v":503,"d":"Rp503"}]
[null,"Ibu","Musim gugur","Sewa",{"v":2000,"d":"Rp2,000"}]
[null,"Ibu","Musim gugur","Utilitas",{"v":140,"d":"Rp140"}]
[null,"Ibu","Musim gugur","Asuransi",{"v":502,"d":"Rp502"}]
[null,"Ibu","Musim gugur","Sewa",{"v":120,"d":"Rp120"}]
[null,"Ibu","Musim gugur","Utilitas",{"v":50,"d":"Rp50"}]

{"sheet":"19","index":19,"n_rows":55,"n_cols":5,"rows_kept":55}
["Siap untuk latihan lainnya? Sempatkan untuk meninjau data di bawah ini, dalam sel B7 hingga E55. Ketika sudah siap, masuk ke lembar berikutnya dan Anda akan berlatih tentang hal yang sudah dipelajari sejauh ini. "]
["Tidak perlu meninjau semua baris data. Cukup tinjau nama bidang di baris 7. Anda akan bekerja dengan konten ini di lembar berikutnya. "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[]
[null,"Musim","Perwakilan penjualan","Produk","Unit terjual"]
[null,"Musim dingin","Jeni","Jeruk",300]
[null,"Musim dingin","Galih","Jeruk Limau Gedang",200]
[null,"Musim dingin","Deni","Apel",400]
[null,"Musim dingin","Jeni","Pisang",300]
[null,"Musim dingin","Galih","Jeruk",800]
[null,"Musim dingin","Deni","Jeruk Limau Gedang",400]
[null,"Musim dingin","Jeni","Apel",200]
[null,"Musim dingin","Galih","Pisang",300]
[null,"Musim dingin","Deni","Jeruk",450]
[null,"Musim dingin","Jeni","Jeruk Limau Gedang",230]
[null,"Musim dingin","Galih","Apel",120]
[null,"Musim dingin","Deni","Pisang",400]
[null,"Musim semi","Jeni","Buah Bit",210]
[null,"Musim semi","Galih","Kentang",300]
[null,"Musim semi","Deni","Selada",400]
[null,"Musim semi","Jeni","Lobak",230]
[null,"Musim semi","Galih","Buah Bit",900]
[null,"Musim semi","Deni","Kentang",300]
[null,"Musim semi","Jeni","Selada",200]
[null,"Musim semi","Galih","Lobak",{"v":1000,"d":"1,000"}]
[null,"Musim semi","Deni","Buah Bit",220]
[null,"Musim semi","Jeni","Kentang",400]
[null,"Musim semi","Galih","Selada",200]
[null,"Musim semi","Deni","Lobak",400]
[null,"Musim panas","Jeni","Blueberry",100]
[null,"Musim panas","Galih","Stroberi",30]
[null,"Musim panas","Deni","Anggur",123]
[null,"Musim panas","Jeni","Labu",300]
[null,"Musim panas","Galih","Blueberry",350]
[null,"Musim panas","Deni","Stroberi",230]
[null,"Musim panas","Jeni","Anggur",120]
[null,"Musim panas","Galih","Labu",640]
[null,"Musim panas","Deni","Blueberry",530]
[null,"Musim panas","Jeni","Stroberi",560]
[null,"Musim panas","Galih","Anggur",240]
[null,"Musim panas","Deni","Labu",250]
[null,"Musim gugur","Jeni","Labu Kuning",62]
[null,"Musim gugur","Galih","Zukini",600]
[null,"Musim gugur","Deni","Apel",340]
[null,"Musim gugur","Jeni","Jeruk",205]
[null,"Musim gugur","Galih","Labu Kuning",500]
[null,"Musim gugur","Deni","Zukini",403]
[null,"Musim gugur","Jeni","Apel",503]
[null,"Musim gugur","Galih","Jeruk",{"v":2000,"d":"2,000"}]
[null,"Musim gugur","Deni","Labu Kuning",140]
[null,"Musim gugur","Jeni","Zukini",502]
[null,"Musim gugur","Galih","Apel",120]
[null,"Musim gugur","Deni","Jeruk",50]

{"sheet":"20","index":20,"n_rows":17,"n_cols":9,"rows_kept":17}
["1. Area PivotTable untuk contoh ini berada di sel B12 hingga C17. Navigasikan ke salah satu sel tersebut. \n\n"]
["2. Tekan ALT+JL, V untuk meluncurkan Daftar Bidang PivotTable. Secara default, Fokus akan terletak pada kotak teks Cari: Cari \"Ketikkan kata yang akan dicari\". Jangan ketik apa pun, tetapi tekan tab satu kali. CATATAN: jika Daftar Bidang tidak muncul, tekan ALT+JL, V lagi."]
["3. Tekan tombol panah untuk berpindah ke bidang Perwakilan Penjualan. Tekan SPACEBAR untuk menambahkan bidang Perwakilan Penjualan ke area Baris. Jika ingin menampilkan detail Perwakilan Penjualan di area Kolom, gunakan tombol Tab untuk berpindah ke bidang Perwakilan Penjualan di bagian Baris, lalu tekan SPACEBAR, dan pilih \"Pindahkan ke Label Kolom\". Tekan ESC untuk keluar dari panel Bidang PivotTable. "]
["4. Tentukan siapa yang menjual item terbanyak di musim gugur, lalu buat pilihan dalam sel I8. "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[{"$nulls":8},"Pilih satu:"]
[]
[{"$nulls":8},{"$f":"IF($I$8=\"Galih\",\"Anda benar!\",IF($I$8=\"Deni\",\"Coba lagi...\",IF($I$8=\"Jeni\",\"Kurang tepat...\",IF($I$8=\" \",\" \",\" \"))))","v":" "}]
[]
[]
[null,"Row Labels","Jumlah dari Unit terjual"]
[null,"Musim gugur",{"v":5425,"d":"5,425"}]
[null,"Musim semi",{"v":4760,"d":"4,760"}]
[null,"Musim panas",{"v":3473,"d":"3,473"}]
[null,"Musim dingin",{"v":4100,"d":"4,100"}]
[null,"Grand Total",{"v":17758,"d":"17,758"}]

{"sheet":"21","index":21,"n_rows":14,"n_cols":10,"rows_kept":14}
["1. Klik sel B13 untuk mengaktifkan PivotTable bernama \"Jumlah dari Unit terjual\".\n\n"]
["2. Tekan ALT+JL, V untuk meluncurkan Daftar Bidang PivotTable. Secara default, Fokus akan terletak pada kotak teks Cari: Cari \"Ketikkan kata yang akan dicari\". Jangan ketik apa pun, tetapi tekan tab satu kali. CATATAN: jika Daftar Bidang tidak muncul, tekan ALT+JL, V lagi."]
["3. Gunakan tombol panah dan SPACEBAR untuk memperluas contoh menjadi PivotTable vertikal berisi musim di sebelah kiri, dan perwakilan penjualan yang diindentasi di bawah musim. Tekan tombol ESC untuk keluar dari panel Bidang PivotTable. "]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Musim dingin\",$C$17=1030),\"Kerja bagus! Anda sudah menempatkan\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Musim dingin\",$C$17=1030),\"bidang baris sekunder. Sekarang\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Musim dingin\",$C$17=1030),\"gulir ke bawah dan klik Berikutnya.\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,"Jumlah dari Unit terjual"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"22","index":22,"n_rows":14,"n_cols":10,"rows_kept":14}
["1. Klik sel B13 untuk mengaktifkan PivotTable bernama \"Jumlah dari Unit terjual\"."]
["2. Tekan ALT+JL, V untuk meluncurkan Daftar Bidang PivotTable. Secara default, Fokus akan terletak pada kotak teks Cari: Cari \"Ketikkan kata yang akan dicari\". Jangan ketik apa pun, tetapi tekan tab satu kali. CATATAN: jika Daftar Bidang tidak muncul, tekan ALT+JL, V lagi."]
["3. Gunakan tombol panah dan SPACEBAR untuk mengubah contoh sehingga menampilkan setiap produk dalam barisnya sendiri, dan setiap musim dalam kolomnya sendiri."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP.",{"$nulls":8},{"$f":"IF(AND($B$15=\"Anggur\",$G$28=1505),\"Kerja bagus! Anda sudah\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Anggur\",$G$28=1505),\"menempatkan bidang baris\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Anggur\",$G$28=1505),\"di sebelah kiri, dan bidang\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Anggur\",$G$28=1505),\"kolom dengan empat kolom baru.\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Anggur\",$G$28=1505),\"Gulir ke bawah dan klik Berikutnya.\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"Jumlah dari Unit terjual"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"23","index":23,"n_rows":16,"n_cols":18,"rows_kept":16}
["1. Klik sel B13 untuk mengaktifkan PivotTable bernama \"Jumlah dari Unit terjual\".\n\n"]
["2. Tekan ALT+JL, V untuk meluncurkan Daftar Bidang PivotTable. Secara default, Fokus akan terletak pada kotak teks Cari: Cari \"Ketikkan kata yang akan dicari\". Jangan ketik apa pun, tetapi tekan tab satu kali. CATATAN: jika Daftar Bidang tidak muncul, tekan ALT+JL, V lagi."]
["3. Gunakan tombol Tab, panah, dan SPACEBAR untuk mengubah contoh sehingga memperlihatkan Perwakilan Penjualan di sebelah kiri dengan Musim yang diindentasi di bawahnya."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Deni\",$C$14=5036),\"Kerja bagus! Sekarang data\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Deni\",$C$14=5036),\"menjadi lebih mudah dibaca.\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Deni\",$C$14=5036),\"Gulir ke bawah dan klik Berikutnya.\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,null,"Column Labels"]
[null,null,"Deni",{"$nulls":3},"Deni Total","Galih",{"$nulls":3},"Galih Total","Jeni",{"$nulls":3},"Jeni Total","Grand Total"]
[null,null,"Musim gugur","Musim semi","Musim panas","Musim dingin",null,"Musim gugur","Musim semi","Musim panas","Musim dingin",null,"Musim gugur","Musim semi","Musim panas","Musim dingin"]
[null,"Jumlah dari Unit terjual",933,{"v":1320,"d":"1,320"},{"v":1133,"d":"1,133"},{"v":1650,"d":"1,650"},{"v":5036,"d":"5,036"},{"v":3220,"d":"3,220"},{"v":2400,"d":"2,400"},{"v":1260,"d":"1,260"},{"v":1420,"d":"1,420"},{"v":8300,"d":"8,300"},{"v":1272,"d":"1,272"},{"v":1040,"d":"1,040"},{"v":1080,"d":"1,080"},{"v":1030,"d":"1,030"},{"v":4422,"d":"4,422"},{"v":17758,"d":"17,758"}]

{"sheet":"24","index":24,"n_rows":14,"n_cols":9,"rows_kept":14}
["1. Klik sel B13 untuk mengaktifkan PivotTable bernama \"Jumlah dari Unit terjual\"."]
["2. Tekan ALT+JL, V untuk meluncurkan Daftar Bidang PivotTable. Secara default, Fokus akan terletak pada kotak teks Cari: Cari \"Ketikkan kata yang akan dicari\". Jangan ketik apa pun, tetapi tekan tab satu kali. CATATAN: jika Daftar Bidang tidak muncul, tekan ALT+JL, V lagi."]
["3. Gunakan tombol Tab, panah, dan SPACEBAR untuk mengubah contoh sehingga setiap Perwakilan Penjualan memiliki bidang kolomnya sendiri dengan Musim di sebelah kiri, dan Produk yang diindentasi di bawahnya."]
["4. Pilih sel I9 dan pilih berapa banyak jeruk bali yang dijual Deni di musim dingin."]
["Untuk melanjutkan tutorial, tekan CTRL+PAGE DOWN. Untuk kembali ke lembar sebelumnya, tekan CTRL+PAGE UP."]
[]
[]
[{"$nulls":8},"Pilih satu:"]
[]
[{"$nulls":8},{"$f":"IF($I$9=400,\"Anda benar!\",IF($I$9=530,\"Coba lagi...\",IF($I$9=123,\"Kurang tepat...\",\" \")))","v":" "}]
[]
[]
[null,"Jumlah dari Unit terjual"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"Pelajari selengkapnya","index":25,"n_rows":8,"n_cols":1,"rows_kept":8}
["Kerja bagus. PivotTable bagus, bukan?"]
["Namun, Anda harus terus belajar karena masih banyak yang perlu dijelajahi!"]
["Info Pivot lainnya\nBaca artikel ini untuk mencari tahu apa lagi yang dapat Anda lakukan dengan PivotTable."]
["Tentang refresh\nBaca artikel penting berikut ini tentang cara merefresh PivotTable. "]
["Komunitas\nBergabunglah dengan penggemar Excel lainnya. Mereka dapat membantu, dan Anda dapat membantu mereka."]
[]
[]
[" "]