Tutorial Membuat Pivot Table di Microsoft Excel 2013
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX4Fvg7FASf_8fKuFlswLQoZHoVEGIkaVC_UQH3NpV1Ax2iLH8kBYyiCXmIorcIomgj7UAbfYalPUAuKQg3gplluH_2hCB5FZguHfKcqLkDt_6le2FWnRbxJ9HPsT56ao29sglwvkqxNY/s320/How-To-Add-Attach-or-Insert-A-File-in-Microsoft-Office-Excel-2013-in-3-Easy-Steps.jpg)
IRFANDROOT - Halo semua , berjumpa lagi dgn saya admin yg mengelola blog sederhana ini hehe . Beberapa kedepan saya akan menghadirkan tentang Tutorial tutorial di Ms Excel . Ok langsung saja , berikut langkah - langkah nya :
1. Buka MS Excel 2013 / bebas mau versi berapa
2. Siapkan Data table yang akan dibuat PIVOT TABLE
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidqtF5HY4gQHF8PVUwwql3XMWRQ_ZdoD8gRxUMZacCjbrUlpRIwqPsu42kagGirMLrzluLKJwGFZEGOjj6D6WartEnh8PPimvVWwub3cF_d7t-3fx34KAt4vMPWoBfaHZ1g81dCfXuLoQ/s320/pt.png)
3. Block semua Table nya
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIlLj0nYVvpiMX4W_qQQnNCj_2P9pW0tIe_gWBY1EW2iwbbFX4tUZhyphenhyphenZsh80BilRQNcsHbMRCRTSBAbwApWniukd2ZpKECW2tXoZ_kYVoo38woDIiaMU2TmyEOa7sZwisK2C8jiR6rvAE/s320/pt.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4pLXfFrg5oRfS08eaHo-LvEdFKnuVUyFJTE2_YcunHYSBZG2k74dw0jolK6wZVlFlXkmdcrKvOXt-LFOiCig765Fe0H2taF6QLQMJsGpwNytPpN4Kq2dH_HWG4UXcPkaa7U8vTLlcEXU/s320/pt.png)
5. Centang Existing Worksheet
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAzSin3g3A6XG05CKFPzDY1mOSDrcW0q_8RCwFM211ekKqpHNVd0g3oJmBN_GTFqQEFvmIjcZI_0vvOWGuB_91U2pgxFemzJbOQfDuw7sEOiuzfLp-eqyJMPvp_HEgcHwyDAVegTN1EaM/s320/pt.png)
6. Pada locations , pilih lokasi penempatan pivot table
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgirhrIVGiz1lv_gtrzhtOM7QwF0vf9f9MgYZKcccXISCtTRZ8OTcZBMGOfhJ5NvVStDk4SgEopChveRprWRS5RyLeuFj2sDd5S7nwivz4S9qfQyCL9_zg-WWHerkell0vckJwpepsvI6Y/s320/pt.png)
7. Centang Region , book categories , Qty , Ammount
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUzM83I-t_cTi5gjuZs_07fsz-JzDNb1ZPXY3az73yvP5TBkRsUBYhtVVCwc-znUfjJGWvCphF_VFqT-LtsgETjBHC5py3XH7ogz8o825KZPAq_g5RC-gVVNfSk3H5ND-CE-sP7dpbuRo/s1600/pt.png)
8. Pada Row table , pilih 1 kota saja (Disini saya memilih Kota Bogor)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtwQ5qQsmbK_RT1AWKFDhEHsDmGxxNjz47wRtafcurY5ek0Wt_6CPFIJojyzaC93KRpXMNn0FkDJsYAPxwHgCtR5rj1D4Dsu08hU92Iv5gCbZmIJJIXeQBxoMLrZwiz7gSQWFZ0HgPNCs/s320/pt.png)
9. Finish
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKIf_I2CkziI04jn4Ks8uuJvLpftLUQ3GiOZ4tpqTX8h6YiDFvD2PF301zyoVvST0mS-ejaf2gmu6v6bjjSxOHlQNA_WbGJSl3wrmNDgNmVyMlK2oCwgjHFrAKXGNGfJu1bfE0k0d1qIk/s320/pt.png)
jika anda tidak / belum mengerti secara detail . silahkan tonton video di bawah ini , semoga membantu anda untuk memahami secara detail
Sekian dan Terima Kasih
download now
Tutorial Membuat Pivot Table di Microsoft Excel 2013
Reviewed by hunti
on
6:30 AM
Rating:
![Tutorial Membuat Pivot Table di Microsoft Excel 2013](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX4Fvg7FASf_8fKuFlswLQoZHoVEGIkaVC_UQH3NpV1Ax2iLH8kBYyiCXmIorcIomgj7UAbfYalPUAuKQg3gplluH_2hCB5FZguHfKcqLkDt_6le2FWnRbxJ9HPsT56ao29sglwvkqxNY/s72-c/How-To-Add-Attach-or-Insert-A-File-in-Microsoft-Office-Excel-2013-in-3-Easy-Steps.jpg)