{"id":2767,"date":"2023-07-20T19:19:03","date_gmt":"2023-07-20T19:19:03","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/"},"modified":"2023-07-20T19:19:03","modified_gmt":"2023-07-20T19:19:03","slug":"kelompok-tabel-pivot-excel-berdasarkan-rentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/","title":{"rendered":"Excel: cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara mengelompokkan nilai dalam tabel pivot di Excel berdasarkan rentang.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan data berikut pada 15 toko berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24297 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp1.jpg\" alt=\"\" width=\"384\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat PivotTable<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat PivotTable dari data ini, klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>PivotTable<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24299 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp0.jpg\" alt=\"\" width=\"521\" height=\"112\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, pilih <strong>A1:C16<\/strong> sebagai rentang dan pilih untuk menempatkan tabel pivot di sel <strong>E1<\/strong> lembar kerja yang ada:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24298 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp2.jpg\" alt=\"\" width=\"591\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , <strong>panel Bidang PivotTable<\/strong> baru akan muncul di sisi kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seret <strong>kotaknya.<\/strong> bidang <strong>Kaki<\/strong> di area <strong>Baris<\/strong> dan seret bidang <strong>Penjualan<\/strong> ke area <strong>Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24300 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp3.jpg\" alt=\"\" width=\"362\" height=\"575\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot secara otomatis akan diisi dengan nilai-nilai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24301 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp4.jpg\" alt=\"\" width=\"370\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Kelompokkan Nilai PivotTable berdasarkan Rentang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mengelompokkan nilai luas persegi berdasarkan rentang, klik kanan nilai apa pun di kolom pertama tabel pivot, lalu klik <strong>Kelompokkan<\/strong> di menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24302 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp5.jpg\" alt=\"\" width=\"379\" height=\"505\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Di jendela <strong>Pengelompokan<\/strong> yang muncul, pilih untuk mengelompokkan nilai yang dimulai dari <strong>100<\/strong> dan berakhir pada <strong>250<\/strong> kali <strong>25<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24303 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp6.jpg\" alt=\"\" width=\"502\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , nilai luas persegi di tabel pivot akan secara otomatis dikelompokkan dari 100 hingga 250, dalam rentang panjang 25:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24304\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp7.jpg\" alt=\"PivotTable Grup Excel berdasarkan Rentang\" width=\"546\" height=\"430\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan nilai tabel pivot:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah penjualan toko dengan luas antara 100 dan 124 adalah <strong>51<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah penjualan toko dengan luas antara 125 dan 149 adalah <strong>82<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah penjualan toko dengan luas antara 150 dan 174 adalah <strong>108<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, kami mengelompokkan nilai menggunakan rentang 25, namun silakan gunakan rentang apa pun yang Anda inginkan berdasarkan data Anda.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/membuat-tabel-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara membuat tabel di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Tabel Kontingensi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-bulan-dan-tahun\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan berdasarkan bulan dan tahun dalam tabel pivot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut ini memperlihatkan cara mengelompokkan nilai dalam tabel pivot di Excel berdasarkan rentang. Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan data berikut pada 15 toko berbeda: Langkah 2: Buat PivotTable Untuk membuat PivotTable dari data ini, klik tab Sisipkan di sepanjang pita atas, lalu klik ikon PivotTable : Di [&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>Excel: Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan nilai tabel pivot di Excel berdasarkan range, beserta contoh lengkapnya.\" \/>\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\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan nilai tabel pivot di Excel berdasarkan range, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T19:19:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp1.jpg\" \/>\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\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/\",\"name\":\"Excel: Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T19:19:03+00:00\",\"dateModified\":\"2023-07-20T19:19:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan nilai tabel pivot di Excel berdasarkan range, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang\"}]},{\"@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":"Excel: Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang - Statorial","description":"Tutorial ini menjelaskan cara mengelompokkan nilai tabel pivot di Excel berdasarkan range, beserta contoh lengkapnya.","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\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang - Statorial","og_description":"Tutorial ini menjelaskan cara mengelompokkan nilai tabel pivot di Excel berdasarkan range, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/","og_site_name":"Statorials","article_published_time":"2023-07-20T19:19:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp1.jpg"}],"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\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/","url":"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/","name":"Excel: Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T19:19:03+00:00","dateModified":"2023-07-20T19:19:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan nilai tabel pivot di Excel berdasarkan range, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang"}]},{"@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\/2767"}],"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=2767"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2767\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}