{"id":1754,"date":"2023-11-07T01:38:23","date_gmt":"2023-11-07T01:38:23","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/"},"modified":"2023-12-06T06:18:59","modified_gmt":"2023-12-06T06:18:59","slug":"subtotal-jika-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/","title":{"rendered":"Bagaimana cara menggunakan subtotal dengan if di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1994953773\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p><strong>FORMULA INI ADALAH KEAJAIBAN MURNI.<\/strong><\/p><p> Jika Anda ingin menulis rumus SUBTOTAL di Excel dengan IF (kondisi), Anda perlu menggunakan beberapa fungsi untuk melakukannya. Namun sebelum kita melakukannya, mari kita pahami data yang kita miliki untuk contoh ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82611\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"subtotal-dengan-jika\" width=\"720\" height=\"334\"><\/figure><\/div><p> Pada contoh di atas, Anda memiliki tiga kolom:<\/p><ul><li> Nama<\/li><li> Lempengan usia<\/li><li> Jenis kelamin<\/li><\/ul><p> Dan saat Anda memfilter lempengan dari kolom Lempengan Usia, jumlah wanita di sel F1 akan ditampilkan. Artinya kita mempunyai rumus yang menampilkan jumlah nilai yang difilter tetapi dengan syarat.<\/p><p> Rumus yang kami miliki:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT((C2:C41=E1)*(SUBTOTAL(3,OFFSET(C2,ROW(C2:C41)-MIN(ROW(C2:C41)),0))))<\/code><\/pre><h2 class=\"wp-block-heading\"> Memahami rumus SUBTOTAL IF<\/h2><p> Rumus ini menggunakan lima fungsi: SUMPRODUK, SUBTOTAL, OFFSET, ROW, dan MAX. Oleh karena itu, untuk memahami rumus ini kita perlu membaginya menjadi beberapa bagian.<\/p><h3 class=\"wp-block-heading\"> 1.GARIS(C2:C41)-2.0)<\/h3><p> Bagian rumus ini menggunakan fungsi MIN dan ROW. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82621\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-min-et-fonction-rangee1.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi min-dan-baris\" width=\"780\" height=\"110\"><\/figure><\/div><ul><li> Di ROW, kami telah mereferensikan kolom &#8220;Jenis Kelamin&#8221;, dan mengembalikan array nomor baris.<\/li><li> Setelah itu, MIN mengambil nomor array atau baris tersebut dan mengembalikan nomor baris minimum. Itu sebabnya kita punya 2 di bagian rumus ini.<\/li><\/ul><h3 class=\"wp-block-heading\"> 2.GARIS(C2:C41)<\/h3><p> Pada bagian ini, kita hanya memiliki fungsi ROW, yang mengembalikan array nomor baris. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82612\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-a-3-lignes-pour-renvoyer-un-tableau-de-numeros-de-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi-baris-untuk-mengembalikan-array-angka-baris\" width=\"726\" height=\"136\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. OFFSET(C2,GARIS(C2:C41)-MIN(GARIS(C2:C41)),0)<\/h3><p> Kami sekarang memiliki fungsi OFFSET. Ini membantu Anda membuat referensi ke suatu rentang menggunakan referensi sel sebagai titik awal. Dalam argumen <strong>referensi<\/strong> , kami mengacu pada sel C2, sel pertama tempat rentang gender kami dimulai. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82613\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-decalage.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi offset\" width=\"489\" height=\"94\"><\/figure><\/div><p> Dalam argumen garis kita memiliki bagian rumus yang dibahas di atas dalam dua bagian pertama. Setelah itu, dalam argumen cols, kami menggunakan 0. Dengan semua ini, OFFSET mengembalikan array dari semua nilai di kolom \u201cJenis Kelamin\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82614\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-decalage-renvoie-la-valeur-des-colonnes-de-sexe.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom offset-pengembalian-nilai-jenis kelamin\" width=\"619\" height=\"207\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. SUBTOTAL(3,OFFSET(C2,GARIS(C2:C41)-MIN(GARIS(C2:C41)),0))<\/h3><p> Kami menggunakan array yang dikembalikan oleh OFFSET di SUBTOTAL. Dan di function_num kita menggunakan 3, yang memberitahu SUBTOTAL untuk menggunakan fungsi COUNTA untuk perhitungan.<\/p><p> Saat Anda menggunakan filter pada kolom &#8220;Age Slab&#8221;, bagian SUBTOTAL dari rumus ini mengembalikan array yang berisi 0 dan 1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82615\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sous-total-a-utiliser-counta.png\" sizes=\"auto, \" srcset=\"\" alt=\"subtotal untuk digunakan\" width=\"635\" height=\"140\"><\/figure><\/div><p> Dalam tabel ini kita memiliki 1 untuk nilai yang setara dengan nilai yang kita terapkan filternya. Lihat contoh di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82616\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-valeurs-equivalentes-aux-valeurs-appliquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai-nilai-setara-dengan-nilai-yang diterapkan\" width=\"552\" height=\"247\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. (C2:C41=E1)<\/h3><p> Bagian rumus ini mengembalikan array dengan menguji suatu kondisi. Dalam kondisi ini, kami menguji apakah nilai rentangnya adalah \u201cFemale\u201d, dan mengembalikan TRUE dan FALSE dalam array. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82617\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-renvoie-vrai-et-faux-dans-le-tableau.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengembalikan-benar-dan-salah-dalam-array\" width=\"448\" height=\"320\"><\/figure><\/div><p> Dalam tabel ini, kita memiliki TRUE untuk nilai \u201cFemale\u201d dan FALSE untuk nilai lainnya.<\/p><h3 class=\"wp-block-heading\"> 7. Bagian terakhir<\/h3><p> Pada akhirnya, kita memiliki dua tabel di SUMPRODUK. Dan kami juga memiliki operator tanda bintang di antara array ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82618\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-deux-tableaux-en-sumproduct.png\" sizes=\"auto, \" srcset=\"\" alt=\"dua lukisan sekaligus diproduksi\" width=\"659\" height=\"151\"><\/figure><\/div><p> Saat kita mengalikan dua tabel satu sama lain, kita memiliki satu tabel dengan 0 dan 1. Dalam tabel ini, satu (1) untuk nilai &#8220;Perempuan&#8221; dalam jenis kelamin dan 21-30 untuk &#8220;Umur Slab&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82619\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-tableau-unique-avec-zero-et-un.png\" sizes=\"auto, \" srcset=\"\" alt=\"array tunggal dengan nol dan satu\" width=\"572\" height=\"84\"><\/figure><\/div><p> Pada akhirnya, SUMPRODUK mengembalikan jumlah menggunakan array ini. Dan jumlah ini adalah jumlah sel dengan nilai &#8220;Wanita&#8221; pada kolom gender saat Anda memfilter 21-30 pada kolom &#8220;Rentang Usia&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82620\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-sumproduct-renvoie-la-somme-en-utilisant-arroay1.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-pengembalian-jumlah-dengan-menggunakan-array\" width=\"733\" height=\"340\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/sous-total-si.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\">Centang IF 0 (nol) lalu kosongkan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/periksa-apakah-ada-nilai-dalam-suatu-rentang\/\">Periksa apakah ada nilai dalam rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\">Gabungkan fungsi IF dan AND di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\">Gabungkan fungsi IF dan OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\">IF Cell kosong (kosong) menggunakan IF + ISBLANK di Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1754","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menggunakan SUBTOTAL dengan IF di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan SUBTOTAL dengan IF (Conditional SUBTOTAL). Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan SUBTOTAL dengan IF di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan SUBTOTAL dengan IF (Conditional SUBTOTAL). Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/\",\"name\":\"Bagaimana cara menggunakan SUBTOTAL dengan IF di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\",\"datePublished\":\"2023-11-07T01:38:23+00:00\",\"dateModified\":\"2023-12-06T06:18:59+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan SUBTOTAL dengan IF (Conditional SUBTOTAL). Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan subtotal dengan if di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggunakan SUBTOTAL dengan IF di Excel? (Tutorial 2023)","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan SUBTOTAL dengan IF (Conditional SUBTOTAL). Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/subtotal-jika-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan SUBTOTAL dengan IF di Excel? (Tutorial 2023)","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan SUBTOTAL dengan IF (Conditional SUBTOTAL). Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/","url":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/","name":"Bagaimana cara menggunakan SUBTOTAL dengan IF di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png","datePublished":"2023-11-07T01:38:23+00:00","dateModified":"2023-12-06T06:18:59+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan SUBTOTAL dengan IF (Conditional SUBTOTAL). Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/subtotal-jika-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan subtotal dengan if di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1754"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1754\/revisions"}],"predecessor-version":[{"id":2795,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1754\/revisions\/2795"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}