{"id":1696,"date":"2023-07-25T08:37:16","date_gmt":"2023-07-25T08:37:16","guid":{"rendered":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/"},"modified":"2023-07-25T08:37:16","modified_gmt":"2023-07-25T08:37:16","slug":"memformat-tabel-pivot-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/","title":{"rendered":"Format pivottable di google spreadsheet (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tabel pivot menyediakan cara sederhana untuk meringkas nilai kumpulan data.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16726 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format9-1.png\" alt=\"\" width=\"578\" height=\"141\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah dalam membuat dan memformat tabel pivot untuk kumpulan data mentah di Google Spreadsheet.<\/span><\/p>\n<h3> <strong>Langkah 1: Masukkan datanya<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan beberapa data penjualan untuk bisnis imajiner:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16715 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format1.png\" alt=\"\" width=\"529\" height=\"492\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong>Langkah 2: Buat PivotTable<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot semua data. Di pita atas, klik <strong>Data<\/strong> , lalu <strong>PivotTable<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16716 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format2.png\" alt=\"\" width=\"550\" height=\"506\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pilih untuk memasukkan tabel pivot di lembar baru atau yang sudah ada, lalu klik <strong>Buat<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16717 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format3.png\" alt=\"\" width=\"360\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di editor tabel pivot yang muncul di sebelah kanan, tambahkan Product ke <strong>Rows<\/strong> , Region ke <strong>Columns<\/strong> , dan Sales ke <strong>Values<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16718 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format4.png\" alt=\"\" width=\"301\" height=\"595\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot kami sekarang akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16719 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format5.png\" alt=\"\" width=\"523\" height=\"220\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong>Langkah 3: Pilih tema khusus<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Format<\/strong> di sepanjang pita atas dan klik <strong>Tema<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16720\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format6.png\" alt=\"Cara memformat tabel pivot di Google Sheets\" width=\"422\" height=\"330\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul di sebelah kanan, klik tema tabel pivot pilihan Anda. Atau Anda dapat mengklik <strong>Sesuaikan<\/strong> untuk memilih warna tema Anda sendiri.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan memilih tema <strong>Simple Light<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16721 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format7.png\" alt=\"\" width=\"253\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong>Langkah 4: Tambahkan Perbatasan dan Pusatkan Teks<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menyorot semua data dan menambahkan batas di sekeliling setiap sel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16722 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format8.png\" alt=\"\" width=\"578\" height=\"283\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kami akan memusatkan nilai data di tabel pivot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16726 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format9-1.png\" alt=\"\" width=\"578\" height=\"141\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot kini diformat agar terlihat rapi dan bersih.<\/span><\/p>\n<hr>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan tutorial Google Sheets lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tabel pivot menyediakan cara sederhana untuk meringkas nilai kumpulan data. Tutorial ini memberikan contoh langkah demi langkah dalam membuat dan memformat tabel pivot untuk kumpulan data mentah di Google Spreadsheet. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan beberapa data penjualan untuk bisnis imajiner: Langkah 2: Buat PivotTable Selanjutnya, sorot semua data. Di pita [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Format PivotTable di Google Spreadsheet (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memformat tabel pivot di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Format PivotTable di Google Spreadsheet (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memformat tabel pivot di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T08:37:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format9-1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/\",\"name\":\"Format PivotTable di Google Spreadsheet (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T08:37:16+00:00\",\"dateModified\":\"2023-07-25T08:37:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memformat tabel pivot di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Format pivottable di google spreadsheet (langkah demi langkah)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Format PivotTable di Google Spreadsheet (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara memformat tabel pivot di Google Sheets, dengan contoh langkah demi langkah.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Format PivotTable di Google Spreadsheet (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara memformat tabel pivot di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-25T08:37:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format9-1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/","url":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/","name":"Format PivotTable di Google Spreadsheet (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T08:37:16+00:00","dateModified":"2023-07-25T08:37:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memformat tabel pivot di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/memformat-tabel-pivot-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Format pivottable di google spreadsheet (langkah demi langkah)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1696"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=1696"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1696\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}