{"id":2652,"date":"2025-02-22T10:39:12","date_gmt":"2025-02-22T03:39:12","guid":{"rendered":"https:\/\/digitalqueen.digitalmama.id\/?p=2652"},"modified":"2025-02-24T09:08:56","modified_gmt":"2025-02-24T02:08:56","slug":"rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir","status":"publish","type":"post","link":"https:\/\/digitalqueen.digitalmama.id\/id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/","title":{"rendered":"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Microsoft Excel adalah salah satu alat paling populer dan serbaguna yang digunakan di dunia kerja, pendidikan, dan kehidupan sehari-hari. Salah satu alasan utama popularitasnya adalah kemampuannya untuk melakukan perhitungan dan analisis data dengan cepat menggunakan&nbsp;<strong>rumus Excel<\/strong>. Dalam artikel ini, kami akan membahas&nbsp;<strong>rumus Excel paling penting dan selalu dipakai<\/strong>&nbsp;yang dapat membantu Anda meningkatkan produktivitas dan efisiensi dalam bekerja.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>1. Rumus SUM<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus SUM<\/strong>&nbsp;adalah salah satu rumus paling dasar dan sering digunakan di Excel. Fungsi ini digunakan untuk menjumlahkan sekelompok angka.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=SUM(A1:A10)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan menjumlahkan semua nilai dari sel A1 hingga A10.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>2. Rumus AVERAGE<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus AVERAGE<\/strong>&nbsp;digunakan untuk menghitung rata-rata dari sekelompok angka.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=AVERAGE(B1:B10)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan menghitung rata-rata nilai dari sel B1 hingga B10.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>3. Rumus IF<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus IF<\/strong>&nbsp;adalah rumus yang sangat berguna untuk membuat keputusan berdasarkan kondisi tertentu.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=IF(C1 &gt; 50, \"Lulus\", \"Tidak Lulus\")<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan mengecek apakah nilai di sel C1 lebih besar dari 50. Jika ya, hasilnya adalah &#8220;Lulus&#8221;; jika tidak, hasilnya adalah &#8220;Tidak Lulus&#8221;.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>4. Rumus VLOOKUP<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus VLOOKUP<\/strong>&nbsp;digunakan untuk mencari nilai tertentu dalam tabel atau rentang data.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=VLOOKUP(D1, A1:B10, 2, FALSE)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan mencari nilai di sel D1 dalam rentang A1:B10&nbsp;dan mengembalikan nilai dari kolom kedua (B) yang sesuai.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>5. Rumus HLOOKUP<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus HLOOKUP<\/strong>&nbsp;mirip dengan VLOOKUP, tetapi mencari nilai secara horizontal (baris) daripada vertikal (kolom).<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=HLOOKUP(E1, A1:J2, 2, FALSE)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan mencari nilai di sel E1 dalam rentang A1:J2&nbsp;dan mengembalikan nilai dari baris kedua yang sesuai.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>6. Rumus COUNT<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus COUNT<\/strong>&nbsp;digunakan untuk menghitung jumlah sel yang berisi angka dalam suatu rentang.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=COUNT(F1:F10)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan menghitung berapa banyak sel dalam rentang F1 hingga F10 yang berisi angka.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>7. Rumus COUNTIF<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus COUNTIF<\/strong>&nbsp;digunakan untuk menghitung jumlah sel yang memenuhi kriteria tertentu.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=COUNTIF(G1:G10, \"&gt;20\")<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan menghitung berapa banyak sel dalam rentang G1 hingga G10 yang memiliki nilai lebih besar dari 20.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>8. Rumus SUMIF<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus SUMIF<\/strong>&nbsp;digunakan untuk menjumlahkan nilai dalam suatu rentang yang memenuhi kriteria tertentu.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=SUMIF(H1:H10, \"&gt;50\")<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan menjumlahkan semua nilai dalam rentang H1 hingga H10 yang lebih besar dari 50.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>9. Rumus CONCATENATE (atau CONCAT)<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus CONCATENATE<\/strong>&nbsp;digunakan untuk menggabungkan teks dari beberapa sel menjadi satu.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=CONCATENATE(I1, \" \", J1)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan menggabungkan teks dari sel I1 dan J1 dengan spasi di antaranya.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>10. Rumus LEFT, RIGHT, dan MID<\/strong><\/h3><ul class=\"wp-block-list\"><li><strong>LEFT<\/strong>: Mengambil sejumlah karakter dari awal teks.excelCopy=LEFT(K1, 3)Rumus ini akan mengambil 3 karakter pertama dari teks di sel K1.<\/li>\n\n<li><strong>RIGHT<\/strong>: Mengambil sejumlah karakter dari akhir teks.excelCopy=RIGHT(L1, 2)Rumus ini akan mengambil 2 karakter terakhir dari teks di sel L1.<\/li>\n\n<li><strong>MID<\/strong>: Mengambil sejumlah karakter dari tengah teks.excelCopy=MID(M1, 4, 5)Rumus ini akan mengambil 5 karakter dari teks di sel M1, dimulai dari karakter ke-4.<\/li><\/ul><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>11. Rumus TODAY dan NOW<\/strong><\/h3><ul class=\"wp-block-list\"><li><strong>TODAY<\/strong>: Menampilkan tanggal hari ini.excelCopy=TODAY()<\/li>\n\n<li><strong>NOW<\/strong>: Menampilkan tanggal dan waktu saat ini.excelCopy=NOW()<\/li><\/ul><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>12. Rumus IFERROR<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus IFERROR<\/strong>&nbsp;digunakan untuk menangani kesalahan dalam rumus. Jika rumus menghasilkan error, nilai alternatif akan ditampilkan.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=IFERROR(VLOOKUP(N1, A1:B10, 2, FALSE), \"Tidak Ditemukan\")<\/pre><p class=\"wp-block-paragraph\">Jika VLOOKUP menghasilkan error, rumus ini akan menampilkan &#8220;Tidak Ditemukan&#8221;.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>13. Rumus INDEX dan MATCH<\/strong><\/h3><p class=\"wp-block-paragraph\">Kombinasi&nbsp;<strong>INDEX<\/strong>&nbsp;dan&nbsp;<strong>MATCH<\/strong>&nbsp;adalah alternatif yang lebih fleksibel daripada VLOOKUP.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=INDEX(A1:B10, MATCH(O1, A1:A10, 0), 2)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan mencari nilai di sel O1 dalam rentang A1:A10&nbsp;dan mengembalikan nilai dari kolom kedua (B) yang sesuai.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>14. Rumus ROUND<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus ROUND<\/strong>&nbsp;digunakan untuk membulatkan angka ke jumlah digit tertentu.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=ROUND(P1, 2)<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan membulatkan nilai di sel P1 menjadi 2 digit di belakang koma.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>15. Rumus TEXT<\/strong><\/h3><p class=\"wp-block-paragraph\"><strong>Rumus TEXT<\/strong>&nbsp;digunakan untuk mengubah format angka atau tanggal menjadi teks dengan format tertentu.<\/p><p class=\"wp-block-paragraph\"><strong>Contoh Penggunaan:<\/strong><\/p><p class=\"wp-block-paragraph\">excel<\/p><p class=\"wp-block-paragraph\">Copy<\/p><pre class=\"wp-block-preformatted\">=TEXT(Q1, \"dd\/mm\/yyyy\")<\/pre><p class=\"wp-block-paragraph\">Rumus ini akan mengubah tanggal di sel Q1 menjadi teks dengan format &#8220;dd\/mm\/yyyy&#8221;.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\"\/><h3 class=\"wp-block-heading\"><strong>Kesimpulan<\/strong><\/h3><p class=\"wp-block-paragraph\">Rumus-rumus Excel di atas adalah yang paling penting dan sering digunakan dalam berbagai situasi. Dengan menguasai rumus-rumus ini, Anda dapat meningkatkan efisiensi kerja, melakukan analisis data dengan lebih baik, dan membuat laporan yang lebih profesional.<\/p><p class=\"wp-block-paragraph\">Jangan ragu untuk terus berlatih dan mengeksplorasi fitur-fitur lain di Excel. Semakin Anda terbiasa menggunakan rumus-rumus ini, semakin mudah Anda menyelesaikan tugas-tugas yang kompleks.<\/p>","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel adalah salah satu alat paling populer dan serbaguna yang digunakan di dunia kerja, pendidikan, dan kehidupan sehari-hari. Salah satu alasan utama popularitasnya adalah kemampuannya untuk melakukan perhitungan dan analisis data dengan cepat menggunakan&nbsp;rumus Excel. Dalam artikel ini, kami akan membahas&nbsp;rumus Excel paling penting dan selalu dipakai&nbsp;yang dapat membantu Anda meningkatkan produktivitas dan efisiensi [&hellip;]<\/p>","protected":false},"author":2,"featured_media":2686,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[35],"tags":[48,49,47],"class_list":["post-2652","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-skill-improvement","tag-rumus-excel-paling-dipakai","tag-rumus-excel-paling-penting","tag-skill-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir - Support Perempuan Indonesia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/digitalqueen.digitalmama.id\/id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir - Support Perempuan Indonesia\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel adalah salah satu alat paling populer dan serbaguna yang digunakan di dunia kerja, pendidikan, dan kehidupan sehari-hari. Salah satu alasan utama popularitasnya adalah kemampuannya untuk melakukan perhitungan dan analisis data dengan cepat menggunakan&nbsp;rumus Excel. Dalam artikel ini, kami akan membahas&nbsp;rumus Excel paling penting dan selalu dipakai&nbsp;yang dapat membantu Anda meningkatkan produktivitas dan efisiensi [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/digitalqueen.digitalmama.id\/id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/\" \/>\n<meta property=\"og:site_name\" content=\"Support Perempuan Indonesia\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-22T03:39:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-24T02:08:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"2143\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Rachmadwipa Novandri\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rachmadwipa Novandri\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/\"},\"author\":{\"name\":\"Rachmadwipa Novandri\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/person\/a0ea83b45a43ab7a22cafab30862fcb2\"},\"headline\":\"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir\",\"datePublished\":\"2025-02-22T03:39:12+00:00\",\"dateModified\":\"2025-02-24T02:08:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/\"},\"wordCount\":702,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#organization\"},\"image\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp\",\"keywords\":[\"Rumus Excel Paling Dipakai\",\"Rumus Excel Paling Penting\",\"Skill Excel\"],\"articleSection\":[\"Skill Improvement\"],\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/\",\"url\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/\",\"name\":\"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir - Support Perempuan Indonesia\",\"isPartOf\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp\",\"datePublished\":\"2025-02-22T03:39:12+00:00\",\"dateModified\":\"2025-02-24T02:08:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage\",\"url\":\"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp\",\"contentUrl\":\"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp\",\"width\":2560,\"height\":2143},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/digitalqueen.digitalmama.id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#website\",\"url\":\"https:\/\/digitalqueen.digitalmama.id\/\",\"name\":\"Support Perempuan Indonesia\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/digitalqueen.digitalmama.id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#organization\",\"name\":\"Support Perempuan Indonesia\",\"url\":\"https:\/\/digitalqueen.digitalmama.id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/01\/image-16.png\",\"contentUrl\":\"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/01\/image-16.png\",\"width\":440,\"height\":280,\"caption\":\"Support Perempuan Indonesia\"},\"image\":{\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/person\/a0ea83b45a43ab7a22cafab30862fcb2\",\"name\":\"Rachmadwipa Novandri\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c09d3a7a65d7ddb04978f4ea4d426eecca603d09939adcc535febbf05ebd10e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c09d3a7a65d7ddb04978f4ea4d426eecca603d09939adcc535febbf05ebd10e6?s=96&d=mm&r=g\",\"caption\":\"Rachmadwipa Novandri\"},\"url\":\"https:\/\/digitalqueen.digitalmama.id\/id\/author\/novandri511\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir - Support Perempuan Indonesia","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:\/\/digitalqueen.digitalmama.id\/id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/","og_locale":"id_ID","og_type":"article","og_title":"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir - Support Perempuan Indonesia","og_description":"Microsoft Excel adalah salah satu alat paling populer dan serbaguna yang digunakan di dunia kerja, pendidikan, dan kehidupan sehari-hari. Salah satu alasan utama popularitasnya adalah kemampuannya untuk melakukan perhitungan dan analisis data dengan cepat menggunakan&nbsp;rumus Excel. Dalam artikel ini, kami akan membahas&nbsp;rumus Excel paling penting dan selalu dipakai&nbsp;yang dapat membantu Anda meningkatkan produktivitas dan efisiensi [&hellip;]","og_url":"https:\/\/digitalqueen.digitalmama.id\/id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/","og_site_name":"Support Perempuan Indonesia","article_published_time":"2025-02-22T03:39:12+00:00","article_modified_time":"2025-02-24T02:08:56+00:00","og_image":[{"width":2560,"height":2143,"url":"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp","type":"image\/webp"}],"author":"Rachmadwipa Novandri","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Rachmadwipa Novandri","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#article","isPartOf":{"@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/"},"author":{"name":"Rachmadwipa Novandri","@id":"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/person\/a0ea83b45a43ab7a22cafab30862fcb2"},"headline":"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir","datePublished":"2025-02-22T03:39:12+00:00","dateModified":"2025-02-24T02:08:56+00:00","mainEntityOfPage":{"@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/"},"wordCount":702,"commentCount":0,"publisher":{"@id":"https:\/\/digitalqueen.digitalmama.id\/#organization"},"image":{"@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage"},"thumbnailUrl":"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp","keywords":["Rumus Excel Paling Dipakai","Rumus Excel Paling Penting","Skill Excel"],"articleSection":["Skill Improvement"],"inLanguage":"id","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/","url":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/","name":"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir - Support Perempuan Indonesia","isPartOf":{"@id":"https:\/\/digitalqueen.digitalmama.id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage"},"image":{"@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage"},"thumbnailUrl":"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp","datePublished":"2025-02-22T03:39:12+00:00","dateModified":"2025-02-24T02:08:56+00:00","breadcrumb":{"@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#primaryimage","url":"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp","contentUrl":"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/02\/data-information-report-statistics-strategy-concept_result-scaled.webp","width":2560,"height":2143},{"@type":"BreadcrumbList","@id":"https:\/\/digitalqueen.digitalmama.id\/rumus-excel-paling-penting-dan-sering-digunakan-panduan-lengkap-untuk-pemula-hingga-mahir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/digitalqueen.digitalmama.id\/"},{"@type":"ListItem","position":2,"name":"Rumus Excel Paling Penting dan Sering Digunakan: Panduan Lengkap untuk Pemula hingga Mahir"}]},{"@type":"WebSite","@id":"https:\/\/digitalqueen.digitalmama.id\/#website","url":"https:\/\/digitalqueen.digitalmama.id\/","name":"Support Perempuan Indonesia","description":"","publisher":{"@id":"https:\/\/digitalqueen.digitalmama.id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/digitalqueen.digitalmama.id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/digitalqueen.digitalmama.id\/#organization","name":"Support Perempuan Indonesia","url":"https:\/\/digitalqueen.digitalmama.id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/logo\/image\/","url":"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/01\/image-16.png","contentUrl":"https:\/\/digitalqueen.digitalmama.id\/wp-content\/uploads\/2025\/01\/image-16.png","width":440,"height":280,"caption":"Support Perempuan Indonesia"},"image":{"@id":"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/person\/a0ea83b45a43ab7a22cafab30862fcb2","name":"Rachmadwipa Novandri","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/digitalqueen.digitalmama.id\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c09d3a7a65d7ddb04978f4ea4d426eecca603d09939adcc535febbf05ebd10e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c09d3a7a65d7ddb04978f4ea4d426eecca603d09939adcc535febbf05ebd10e6?s=96&d=mm&r=g","caption":"Rachmadwipa Novandri"},"url":"https:\/\/digitalqueen.digitalmama.id\/id\/author\/novandri511\/"}]}},"_links":{"self":[{"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/posts\/2652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/comments?post=2652"}],"version-history":[{"count":1,"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/posts\/2652\/revisions"}],"predecessor-version":[{"id":2653,"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/posts\/2652\/revisions\/2653"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/media\/2686"}],"wp:attachment":[{"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/media?parent=2652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/categories?post=2652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalqueen.digitalmama.id\/id\/wp-json\/wp\/v2\/tags?post=2652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}