{"id":4693,"date":"2023-07-08T21:41:00","date_gmt":"2023-07-08T21:41:00","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/"},"modified":"2023-07-08T21:41:00","modified_gmt":"2023-07-08T21:41:00","slug":"kelompok-excel-per-kuartal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/","title":{"rendered":"Cara mengelompokkan data per kuartal di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengelompokkan data per kuartal di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fitur <strong>Grup<\/strong> PivotTable.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: mengelompokkan per kuartal di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan total penjualan yang dilakukan oleh suatu bisnis selama beberapa hari:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36649 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart1.png\" alt=\"\" width=\"483\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengelompokkan penjualan berdasarkan kuartal, Anda harus membuat tabel pivot terlebih dahulu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sorot sel dalam rentang <strong>A1:B12<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>PivotTable<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, kita akan memilih untuk menyisipkan tabel pivot di sel <strong>D1<\/strong> lembar kerja saat ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36650 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart2.png\" alt=\"\" width=\"622\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul di sisi kanan layar, seret <strong>Tanggal<\/strong> ke <strong>Baris<\/strong> dan <strong>Penjualan<\/strong> ke <strong>Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36651 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart3.png\" alt=\"\" width=\"421\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot berikut akan terisi secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36652 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart4.png\" alt=\"\" width=\"549\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengelompokkan data berdasarkan kuartal, klik kanan pada salah satu tanggal di tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik <strong>Grup<\/strong> dari menu tarik-turun.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36653 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart5.png\" alt=\"\" width=\"422\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <b>Quarter<\/b> and <strong>Year<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36654 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart6.png\" alt=\"\" width=\"301\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Penjualan di tabel pivot secara otomatis akan dikelompokkan berdasarkan kuartal dan tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36655\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart7.png\" alt=\"Kelompokkan Excel per kuartal\" width=\"575\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang kita dapat melihat jumlah penjualan, dikelompokkan berdasarkan kuartal dan tahun.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda ingin mengelompokkan hanya berdasarkan kuartal dan mengabaikan tahun, klik opsi <strong>Kuartal<\/strong> saja di jendela <strong>Pengelompokan<\/strong> .<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\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\/grup-excel-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan data berdasarkan bulan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan data berdasarkan minggu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-kuartal-tahun\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengkonversi tanggal ke kuartal dan tahun di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mengelompokkan data per kuartal di Excel. Untungnya, hal ini mudah dilakukan menggunakan fitur Grup PivotTable. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: mengelompokkan per kuartal di Excel Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan total penjualan yang dilakukan oleh suatu bisnis selama beberapa hari: Untuk [&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>Cara Mengelompokkan Data Berdasarkan Kuartal di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan data per kuartal di Excel, 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\/kelompok-excel-per-kuartal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengelompokkan Data Berdasarkan Kuartal di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan data per kuartal di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T21:41:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart1.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\/kelompok-excel-per-kuartal\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/\",\"name\":\"Cara Mengelompokkan Data Berdasarkan Kuartal di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T21:41:00+00:00\",\"dateModified\":\"2023-07-08T21:41:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan data per kuartal di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengelompokkan data per kuartal di excel (dengan contoh)\"}]},{\"@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":"Cara Mengelompokkan Data Berdasarkan Kuartal di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan data per kuartal di Excel, 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\/kelompok-excel-per-kuartal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengelompokkan Data Berdasarkan Kuartal di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan data per kuartal di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/","og_site_name":"Statorials","article_published_time":"2023-07-08T21:41:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quart1.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\/kelompok-excel-per-kuartal\/","url":"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/","name":"Cara Mengelompokkan Data Berdasarkan Kuartal di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T21:41:00+00:00","dateModified":"2023-07-08T21:41:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan data per kuartal di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-excel-per-kuartal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengelompokkan data per kuartal di excel (dengan contoh)"}]},{"@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\/4693"}],"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=4693"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4693\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}