Download - Pertemuan 54 : Pivot Table
![Page 1: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/1.jpg)
IT Training Program 2016
![Page 2: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/2.jpg)
[ Excel ]
IT Training Program 2016
[basic pivot table]
MengolahData | TabelPivot
![Page 3: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/3.jpg)
IT Training Program 2016
https://goo.gl/fKyiD5
Ini jawaban yang benar dari Soal GITC 2016
Bandingkan dengan jawabanmu Dan akui berapa nilai sendiri
![Page 4: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/4.jpg)
IT Training Program 2016
Setelah belajar PIVOT TABLE Bandingkan kemudahannya
Mari kita bahas Pivot Tabel
![Page 5: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/5.jpg)
IT Training Program 2016
Berapa total penjualan dari gudang 4
?
![Page 6: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/6.jpg)
IT Training Program 2016
https://goo.gl/FHGVRV
Buatlah tabel hasil penjualan Sebagai berikut
![Page 7: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/7.jpg)
IT Training Program 2016
Ribbon : Insert > Pivot Table
![Page 8: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/8.jpg)
IT Training Program 2016
![Page 9: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/9.jpg)
IT Training Program 2016
Klik ini
![Page 10: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/10.jpg)
IT Training Program 2016
Blok range data dari A2 sampai F14
Klik ini
![Page 11: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/11.jpg)
IT Training Program 2016
Klik ini
![Page 12: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/12.jpg)
IT Training Program 2016
Field List
Drag Nama Customer Drop di Row Labels
Drag Jumlah Drop di Values
Drag Total Drop di Values
![Page 13: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/13.jpg)
IT Training Program 2016
![Page 14: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/14.jpg)
IT Training Program 2016
Field List
Drag Kode Barang Drop di Row Labels
Drag Jumlah Drop di Values
Drag Total Drop di Values
![Page 15: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/15.jpg)
IT Training Program 2016
![Page 16: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/16.jpg)
IT Training Program 2016
![Page 17: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/17.jpg)
IT Training Program 2016
Mari kita bermain data dengan
Pivot Tabel Ganti Field sesuai data yang diinginkan tampil
![Page 18: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/18.jpg)
IT Training Program 2016
Sekarang mari Latihan
Pivot Tabel
Dengan data mentah berikut
![Page 19: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/19.jpg)
IT Training Program 2016
![Page 20: Pertemuan 54 : Pivot Table](https://reader033.vdocuments.us/reader033/viewer/2022051101/58ef7d2c1a28abd6228b459f/html5/thumbnails/20.jpg)
IT Training Program 2016
https://goo.gl/5dwd7l
Ambil data mentah di sini
Lengkapi jumlah pembelian Buat Pivot Tabel dan Pivot Chart