{"id":4758,"date":"2023-07-08T06:05:44","date_gmt":"2023-07-08T06:05:44","guid":{"rendered":"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/"},"modified":"2023-07-08T06:05:44","modified_gmt":"2023-07-08T06:05:44","slug":"pertumbuhan-penjualan-yang-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/","title":{"rendered":"Cara menghitung pertumbuhan penjualan di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut di Excel untuk menghitung pertumbuhan penjualan antara dua periode berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">B3<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )\/ <span style=\"color: #ff0000;\">B2\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung pertumbuhan penjualan, dengan asumsi nilai pada sel <strong>B2<\/strong> mewakili nilai penjualan periode pertama dan nilai sel <strong>B3<\/strong> mewakili nilai penjualan periode kedua.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Menghitung Pertumbuhan Penjualan di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan total penjualan yang dilakukan oleh sebuah perusahaan selama 10 tahun berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37142 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sgr1.png\" alt=\"\" width=\"479\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghitung pertumbuhan penjualan setiap tahunnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C3<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">B3<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )\/ <span style=\"color: #ff0000;\">B2<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37143\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sgr2.png\" alt=\"menghitung pertumbuhan penjualan di Excel\" width=\"455\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita dapat menampilkan nilai pertumbuhan penjualan dalam bentuk persentase dengan cara menyorot cell range <strong>C3:C11<\/strong> lalu klik <strong>Persentase<\/strong> pada menu drop-down <strong>Format Angka<\/strong> pada grup <strong>Angka<\/strong> pada tab <strong>Beranda<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30965 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp3.jpg\" alt=\"\" width=\"432\" height=\"597\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai pertumbuhan penjualan kini akan ditampilkan sebagai persentase:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37145 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sgr4.png\" alt=\"\" width=\"461\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Penjualan meningkat sebesar <strong>11,54%<\/strong> antara tahun 2010 dan 2011.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan meningkat sebesar <strong>31,03%<\/strong> antara tahun 2011 dan 2012.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan menurun sebesar <strong>5,26%<\/strong> antara tahun 2012 dan 2013.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin melihat nilai-nilai ini, Anda dapat menyorot rentang sel <strong>C3:C11<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon berlabel <strong>Kolom Klaster<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-a-bandes.jpg\" alt=\"\" width=\"503\" height=\"120\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul diagram batang berikut yang menampilkan nilai pertumbuhan penjualan per tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37147 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sgr6.png\" alt=\"\" width=\"535\" height=\"293\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hal ini memungkinkan kami melihat dengan cepat tahun mana yang memiliki pertumbuhan penjualan positif atau negatif.<\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/perkiraan-penjualan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Perkiraan Penjualan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/data-ekstrapolasi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrapolasi data di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-ytd\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai tahun ini di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut di Excel untuk menghitung pertumbuhan penjualan antara dua periode berbeda: =( B3 &#8211; B2 )\/ B2 Rumus ini menghitung pertumbuhan penjualan, dengan asumsi nilai pada sel B2 mewakili nilai penjualan periode pertama dan nilai sel B3 mewakili nilai penjualan periode kedua. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. [&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 Menghitung Pertumbuhan Penjualan di Excel (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung pertumbuhan penjualan di Excel, dengan contoh lengkap.\" \/>\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\/pertumbuhan-penjualan-yang-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Pertumbuhan Penjualan di Excel (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung pertumbuhan penjualan di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T06:05:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sgr1.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\/pertumbuhan-penjualan-yang-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/\",\"name\":\"Cara Menghitung Pertumbuhan Penjualan di Excel (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T06:05:44+00:00\",\"dateModified\":\"2023-07-08T06:05:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung pertumbuhan penjualan di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung pertumbuhan penjualan 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 Menghitung Pertumbuhan Penjualan di Excel (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung pertumbuhan penjualan di Excel, dengan contoh lengkap.","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\/pertumbuhan-penjualan-yang-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Pertumbuhan Penjualan di Excel (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung pertumbuhan penjualan di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-08T06:05:44+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sgr1.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\/pertumbuhan-penjualan-yang-unggul\/","url":"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/","name":"Cara Menghitung Pertumbuhan Penjualan di Excel (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T06:05:44+00:00","dateModified":"2023-07-08T06:05:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung pertumbuhan penjualan di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pertumbuhan-penjualan-yang-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung pertumbuhan penjualan 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\/4758"}],"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=4758"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4758\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}