{"id":4124,"date":"2023-07-13T10:42:03","date_gmt":"2023-07-13T10:42:03","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/"},"modified":"2023-07-13T10:42:03","modified_gmt":"2023-07-13T10:42:03","slug":"excel-mengurutkan-bulan-secara-kronologis","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/","title":{"rendered":"Cara mengurutkan bulan secara kronologis di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Untuk mengurutkan bulan secara kronologis di Excel, Anda bisa menggunakan opsi <strong>Daftar Kustom<\/strong> di fungsi <strong>Sortir<\/strong> di Excel.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32768 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique1.png\" alt=\"\" width=\"613\" height=\"288\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan opsi ini untuk mengurutkan bulan secara kronologis di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: mengurutkan bulan secara kronologis di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan oleh suatu perusahaan selama setiap bulan dalam setahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32771 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique1-1.png\" alt=\"\" width=\"495\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris saat ini tidak diurutkan secara kronologis berdasarkan bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengurutkan bulan secara kronologis, sorot sel dalam rentang <strong>A1:B13<\/strong> , lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik tombol <strong>Sortir<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik tombol <strong>Tambah Level<\/strong> di sudut kiri atas, lalu di bawah <strong>Kolom<\/strong> , pilih <strong>Bulan<\/strong> , dan di bawah <strong>Pesanan<\/strong> , pilih <strong>Daftar Kustom<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32770\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique3.png\" alt=\"urutkan bulan secara kronologis di Excel\" width=\"640\" height=\"302\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik opsi di bawah <strong>Daftar Kustom<\/strong> yang dimulai dengan <strong>bulan Januari, Februari, Maret<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32772 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique4.png\" alt=\"\" width=\"523\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik <strong>OK<\/strong> lagi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32773 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique5.png\" alt=\"\" width=\"635\" height=\"298\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , baris-baris dalam kumpulan data akan secara otomatis diurutkan secara kronologis berdasarkan bulan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32775 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique2.png\" alt=\"\" width=\"496\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa bulan-bulan tersebut sekarang dicantumkan dalam urutan kronologis dimulai dari Januari, lalu Februari, lalu Maret, dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika kumpulan data Anda berisi singkatan nama bulan seperti Januari, Februari, Maret, dll., Anda dapat memilih opsi di bawah <strong>Daftar Kustom<\/strong> yang dimulai dengan Januari, Februari, Maret.<\/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\/jumlah-berdasarkan-tanggal-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah berdasarkan tanggal di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-berdasarkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Berdasarkan Tanggal di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menambahkan-bulan-ke-tanggal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan bulan hingga saat ini di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Untuk mengurutkan bulan secara kronologis di Excel, Anda bisa menggunakan opsi Daftar Kustom di fungsi Sortir di Excel. Contoh berikut memperlihatkan cara menggunakan opsi ini untuk mengurutkan bulan secara kronologis di Excel. Contoh: mengurutkan bulan secara kronologis di Excel Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan oleh suatu perusahaan selama [&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 Mengurutkan Bulan Secara Kronologis di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan bulan secara kronologis di Excel, beserta 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\/excel-mengurutkan-bulan-secara-kronologis\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengurutkan Bulan Secara Kronologis di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan bulan secara kronologis di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T10:42:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique1.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\/excel-mengurutkan-bulan-secara-kronologis\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/\",\"name\":\"Cara Mengurutkan Bulan Secara Kronologis di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T10:42:03+00:00\",\"dateModified\":\"2023-07-13T10:42:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan bulan secara kronologis di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengurutkan bulan secara kronologis 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 Mengurutkan Bulan Secara Kronologis di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengurutkan bulan secara kronologis di Excel, beserta 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\/excel-mengurutkan-bulan-secara-kronologis\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengurutkan Bulan Secara Kronologis di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengurutkan bulan secara kronologis di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/","og_site_name":"Statorials","article_published_time":"2023-07-13T10:42:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronique1.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\/excel-mengurutkan-bulan-secara-kronologis\/","url":"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/","name":"Cara Mengurutkan Bulan Secara Kronologis di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T10:42:03+00:00","dateModified":"2023-07-13T10:42:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan bulan secara kronologis di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengurutkan-bulan-secara-kronologis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengurutkan bulan secara kronologis 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\/4124"}],"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=4124"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4124\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}