{"id":3248,"date":"2023-07-18T11:41:24","date_gmt":"2023-07-18T11:41:24","guid":{"rendered":"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/"},"modified":"2023-07-18T11:41:24","modified_gmt":"2023-07-18T11:41:24","slug":"grup-excel-per-minggu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/","title":{"rendered":"Cara mengelompokkan data berdasarkan minggu di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengelompokkan data berdasarkan minggu di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi <strong>WEEKNUM()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsi ini untuk mengelompokkan data berdasarkan minggu di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data yang menunjukkan total penjualan yang dilakukan suatu bisnis pada hari yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27532 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numerodesemaine1.jpg\" alt=\"\" width=\"488\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat variabel mingguan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk mengekstrak minggu dalam setahun dari kolom Tanggal, kita dapat menggunakan fungsi <strong>WEEKNUM()<\/strong> untuk mengembalikan nilai antara 1 dan 53.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel C2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=WEEKNUM( <span style=\"color: #ff6600;\">A2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke sel lainnya di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27530 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numerodesemaine2.jpg\" alt=\"\" width=\"479\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat PivotTable<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, Anda dapat membuat tabel pivot untuk mengetahui jumlah penjualan yang dilakukan setiap minggunya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk membuat PivotTable, sorot sel dalam rentang <strong>B1:C11<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas dan klik <strong>PivotTable<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, kita akan menempatkan tabel pivot di sel <strong>E2<\/strong> lembar kerja yang ada:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27533 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numerodesemaine3.jpg\" alt=\"\" width=\"673\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>OK<\/strong> , panel PivotTable Fields akan muncul di sisi kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tarik variabel <b>Minggu<\/b> ke area Baris dan variabel <b>Penjualan<\/b> ke area Nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27534 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numerodesemaine4.jpg\" alt=\"\" width=\"366\" height=\"599\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai tabel pivot sekarang akan terisi.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27535 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numerodesemaine5.jpg\" alt=\"\" width=\"583\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari tabel pivot kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total penjualan yang dilakukan pada minggu ke 2 adalah <strong>37<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total penjualan yang dilakukan pada minggu ke 3 adalah <strong>65<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total penjualan yang dilakukan pada minggu ke 4 adalah <strong>62<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita juga dapat melihat bahwa total penjualan yang dilakukan berjumlah <strong>164<\/strong> .<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/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\/excel-mengkonversi-hari-ke-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah hari menjadi bulan di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hitungan-excel-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung berdasarkan bulan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-excel-berdasarkan-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter tanggal berdasarkan bulan di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mengelompokkan data berdasarkan minggu di Excel. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi WEEKNUM() . Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsi ini untuk mengelompokkan data berdasarkan minggu di Excel. Langkah 1: Buat datanya Pertama, mari buat kumpulan data yang menunjukkan total penjualan yang dilakukan suatu bisnis [&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 minggu di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan minggu di Excel, dengan sebuah contoh.\" \/>\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\/grup-excel-per-minggu\/\" \/>\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 minggu di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan minggu di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T11:41:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numerodesemaine1.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\/grup-excel-per-minggu\/\",\"url\":\"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/\",\"name\":\"Cara mengelompokkan data berdasarkan minggu di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T11:41:24+00:00\",\"dateModified\":\"2023-07-18T11:41:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan minggu di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengelompokkan data berdasarkan minggu di excel\"}]},{\"@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 minggu di Excel - Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan minggu di Excel, dengan sebuah contoh.","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\/grup-excel-per-minggu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengelompokkan data berdasarkan minggu di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan minggu di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/","og_site_name":"Statorials","article_published_time":"2023-07-18T11:41:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/numerodesemaine1.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\/grup-excel-per-minggu\/","url":"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/","name":"Cara mengelompokkan data berdasarkan minggu di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T11:41:24+00:00","dateModified":"2023-07-18T11:41:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan data berdasarkan minggu di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grup-excel-per-minggu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grup-excel-per-minggu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengelompokkan data berdasarkan minggu di excel"}]},{"@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\/3248"}],"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=3248"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3248\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}