{"id":279,"date":"2023-11-07T01:38:23","date_gmt":"2023-11-07T01:38:23","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/"},"modified":"2023-12-06T11:50:18","modified_gmt":"2023-12-06T11:50:18","slug":"subtotal-se-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/","title":{"rendered":"Como usar subtotal com if no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1643423014\"><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><div class=\"excel-before-content\" id=\"excel-3130306747\"><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>ESTA F\u00d3RMULA \u00c9 PURA M\u00c1GICA.<\/strong><\/p><p> Se voc\u00ea deseja escrever uma f\u00f3rmula SUBTOTAL no Excel com IF (condi\u00e7\u00e3o), voc\u00ea precisa usar v\u00e1rias fun\u00e7\u00f5es para fazer isso. Mas antes de fazermos isso, vamos entender os dados que temos para este exemplo. <\/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 com se\" width=\"720\" height=\"334\"><\/figure><\/div><p> No exemplo acima, voc\u00ea tem tr\u00eas colunas:<\/p><ul><li> Nome<\/li><li> Laje de idade<\/li><li> G\u00eanero<\/li><\/ul><p> E quando voc\u00ea filtra uma laje da coluna Laje de Idade, ela exibe o n\u00famero de mulheres na c\u00e9lula F1. Ent\u00e3o isso significa que temos uma f\u00f3rmula que exibe o n\u00famero de valores filtrados, mas com uma condi\u00e7\u00e3o.<\/p><p> A f\u00f3rmula que temos:<\/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\"> Compreendendo a f\u00f3rmula SUBTOTAL IF<\/h2><p> Esta f\u00f3rmula usa cinco fun\u00e7\u00f5es: SUMPRODUCT, SUBTOTAL, OFFSET, ROW e MAX. Portanto, para compreender esta f\u00f3rmula, precisamos dividi-la em v\u00e1rias partes.<\/p><h3 class=\"wp-block-heading\"> 1.LINHA(C2:C41)-2.0)<\/h3><p> Esta parte da f\u00f3rmula usa as fun\u00e7\u00f5es MIN e 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=\"fun\u00e7\u00e3o min-and-row\" width=\"780\" height=\"110\"><\/figure><\/div><ul><li> No ROW, referenciamos as colunas &#8220;G\u00eanero&#8221; e ela retorna uma matriz de n\u00fameros de linha.<\/li><li> Depois disso, MIN pega esse array ou n\u00fameros de linha e retorna o n\u00famero m\u00ednimo de linha. \u00c9 por isso que temos 2 nesta parte da f\u00f3rmula.<\/li><\/ul><h3 class=\"wp-block-heading\"> 2.LINHA(C2:C41)<\/h3><p> Nesta parte, temos apenas a fun\u00e7\u00e3o ROW, que retorna um array de n\u00fameros de linhas. <\/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=\"fun\u00e7\u00e3o de linha para retornar matriz de n\u00fameros de linha\" width=\"726\" height=\"136\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. DESLOCAMENTO(C2,LINHA(C2:C41)-MIN(LINHA(C2:C41)),0)<\/h3><p> Agora temos a fun\u00e7\u00e3o OFFSET. Ajuda a criar uma refer\u00eancia a um intervalo usando uma refer\u00eancia de c\u00e9lula como ponto de partida. No argumento <strong>de refer\u00eancia<\/strong> , nos referimos \u00e0 c\u00e9lula C2, a primeira c\u00e9lula a partir da qual come\u00e7a nossa faixa de g\u00eanero. <\/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=\"fun\u00e7\u00e3o de deslocamento\" width=\"489\" height=\"94\"><\/figure><\/div><p> No argumento das linhas temos esta parte da f\u00f3rmula discutida acima nas duas primeiras partes. Depois disso, no argumento cols, usamos 0. Com tudo isso, OFFSET retorna um array com todos os valores da coluna \u201cSexo\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=\"deslocamento-retorna-valor-das-colunas-sexuais\" width=\"619\" height=\"207\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. SUBTOTAL(3,OFFSET(C2,LINHA(C2:C41)-MIN(LINHA(C2:C41)),0))<\/h3><p> Usamos o array retornado pelo OFFSET no SUBTOTAL. E no function_num usamos 3, que diz ao SUBTOTAL para usar a fun\u00e7\u00e3o COUNTA para c\u00e1lculo.<\/p><p> Quando voc\u00ea usa um filtro na coluna &#8220;Age Slab&#8221;, esta parte SUBTOTAL da f\u00f3rmula retorna uma matriz contendo 0 e 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 a ser usado\" width=\"635\" height=\"140\"><\/figure><\/div><p> Nesta tabela temos 1 para valores equivalentes ao valor para o qual aplicamos o filtro. Veja o exemplo abaixo: <\/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=\"valores equivalentes a valores aplicados\" width=\"552\" height=\"247\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. (C2:C41=E1)<\/h3><p> Esta parte da f\u00f3rmula retorna uma matriz testando uma condi\u00e7\u00e3o. Nesta condi\u00e7\u00e3o, testamos se o valor do intervalo \u00e9 \u201cFemale\u201d, e retorna TRUE e FALSE no 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=\"retorna verdadeiro e falso em array\" width=\"448\" height=\"320\"><\/figure><\/div><p> Nesta tabela temos TRUE para o valor \u201cFemale\u201d e FALSE para os demais.<\/p><h3 class=\"wp-block-heading\"> 7. \u00daltima parte<\/h3><p> No final, temos duas tabelas em SUMPRODUCT. E tamb\u00e9m temos um operador asterisco entre essas matrizes. <\/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=\"duas pinturas em soma produzidas\" width=\"659\" height=\"151\"><\/figure><\/div><p> Quando multiplicamos as duas tabelas entre si, temos uma \u00fanica tabela com 0 e 1. Nesta tabela, um (1) \u00e9 para o valor \u201cFeminino\u201d em g\u00eanero e 21-30 para \u201cLaje de Idade\u201d. <\/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=\"matriz \u00fanica com zero e um\" width=\"572\" height=\"84\"><\/figure><\/div><p> No final, SUMPRODUCT retorna a soma usando este array. E essa soma \u00e9 o n\u00famero de c\u00e9lulas com o valor \u201cFeminino\u201d na coluna de g\u00eanero quando voc\u00ea filtra de 21 a 30 anos na coluna \u201cFaixa et\u00e1ria\u201d. <\/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=\"sumproduct-retorna-sum-usando-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\"> Obtenha o arquivo Excel<\/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\">Download<\/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\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/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\/pt\/se-zero-entao-vazio\/\">Marque SE 0 (zero) e deixe em branco no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/verificar-se-existe-um-valor-em-um-intervalo\/\">Verifique se existe um valor em um intervalo no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/se-e-1\/\">Combine fun\u00e7\u00f5es SE e AND no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/se-ou-1\/\">Combine fun\u00e7\u00f5es SE e OU no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/se-a-celula-estiver-vazia\/\">SE a c\u00e9lula estiver vazia (vazia) usando IF + ISBLANK no 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-279","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>Como usar SUBTOTAL com IF no Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Este tutorial vai te ensinar como escrever uma f\u00f3rmula Excel para usar SUBTOTAL com IF (SUBTOTAL Condicional). Vamos verificar isso\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\/pt\/subtotal-se-2\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como usar SUBTOTAL com IF no Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Este tutorial vai te ensinar como escrever uma f\u00f3rmula Excel para usar SUBTOTAL com IF (SUBTOTAL Condicional). Vamos verificar isso\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:50:18+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=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/\",\"name\":\"Como usar SUBTOTAL com IF no Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/subtotal-se-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-06T11:50:18+00:00\",\"description\":\"Este tutorial vai te ensinar como escrever uma f\u00f3rmula Excel para usar SUBTOTAL com IF (SUBTOTAL Condicional). Vamos verificar isso\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/subtotal-se-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\/pt\/subtotal-se-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar subtotal com if no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como usar SUBTOTAL com IF no Excel? (Tutorial 2023)","description":"Este tutorial vai te ensinar como escrever uma f\u00f3rmula Excel para usar SUBTOTAL com IF (SUBTOTAL Condicional). Vamos verificar isso\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\/pt\/subtotal-se-2\/","og_locale":"pt_PT","og_type":"article","og_title":"Como usar SUBTOTAL com IF no Excel? (Tutorial 2023)","og_description":"Este tutorial vai te ensinar como escrever uma f\u00f3rmula Excel para usar SUBTOTAL com IF (SUBTOTAL Condicional). Vamos verificar isso\u2026","og_url":"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:50:18+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":{"Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/","url":"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/","name":"Como usar SUBTOTAL com IF no Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/subtotal-se-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-06T11:50:18+00:00","description":"Este tutorial vai te ensinar como escrever uma f\u00f3rmula Excel para usar SUBTOTAL com IF (SUBTOTAL Condicional). Vamos verificar isso\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/subtotal-se-2\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/subtotal-se-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\/pt\/subtotal-se-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar subtotal com if no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/279\/revisions"}],"predecessor-version":[{"id":1380,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/279\/revisions\/1380"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}