{"id":8500,"date":"2026-06-29T12:23:30","date_gmt":"2026-06-29T12:23:30","guid":{"rendered":"https:\/\/www.fpw.com.br\/?p=8500"},"modified":"2026-06-29T12:33:52","modified_gmt":"2026-06-29T12:33:52","slug":"excel-4-funcoes-do-excel-que-pouca-gente-usa-mas-que-podem-dobrar-sua-produtividade","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/excel-4-funcoes-do-excel-que-pouca-gente-usa-mas-que-podem-dobrar-sua-produtividade\/","title":{"rendered":"Excel | 4 Fun\u00e7\u00f5es do Excel que Pouca Gente Usa, Mas Que Podem Dobrar Sua Produtividade"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8500\" class=\"elementor elementor-8500\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-76c1340 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"76c1340\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-40b0655 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"40b0655\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3c6add9 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3c6add9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a7f66c1 elementor-widget elementor-widget-heading\" data-id=\"a7f66c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">4 Fun\u00e7\u00f5es do Excel<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6fbbe7 elementor-widget elementor-widget-text-editor\" data-id=\"b6fbbe7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1>Pouca Gente Usa, Mas Que Podem Dobrar Sua Produtividade<\/h1><p class=\"isSelectedEnd\">Voc\u00ea j\u00e1 teve a sensa\u00e7\u00e3o de que passa mais tempo ajustando planilhas do que analisando informa\u00e7\u00f5es?<\/p><p class=\"isSelectedEnd\">Enquanto muitos usu\u00e1rios utilizam apenas SOMA, M\u00c9DIA e PROCV, existe um grupo de fun\u00e7\u00f5es que permanece &#8220;escondido&#8221; para a maioria dos profissionais. Curiosamente, s\u00e3o justamente essas fun\u00e7\u00f5es que analistas, controladores financeiros e especialistas em Business Intelligence utilizam para automatizar tarefas e construir planilhas inteligentes.<\/p><p class=\"isSelectedEnd\">O mais interessante \u00e9 que elas n\u00e3o s\u00e3o dif\u00edceis de aprender.<\/p><p class=\"isSelectedEnd\">Neste artigo voc\u00ea conhecer\u00e1 quatro fun\u00e7\u00f5es que podem elevar seu n\u00edvel no Excel: <strong>INDIRETO<\/strong>, <strong>SOMASES<\/strong>, <strong>\u00daNICO<\/strong> e um recurso extremamente \u00fatil chamado <strong>Lista Personalizada<\/strong>.<\/p><p>Ao final da leitura, voc\u00ea perceber\u00e1 que provavelmente j\u00e1 enfrentou problemas que poderiam ser resolvidos com apenas uma dessas ferramentas.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea8143d elementor-widget elementor-widget-heading\" data-id=\"ea8143d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Adquira nossos produtos \u00e0 partir de R$ 5,99 e ajude-nos a continuar a trazer novos conte\u00fados relevantes<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-223f332 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"223f332\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-1fbf01b e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"1fbf01b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-9372d0e e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"9372d0e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-4333299 e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"4333299\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2899411 elementor-widget elementor-widget-image\" data-id=\"2899411\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/pay.kiwify.com.br\/8bGr7UE\" target=\"_blank\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-canva.png\" class=\"attachment-large size-large wp-image-8373\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-canva.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-canva-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-canva-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-84f8944 elementor-widget elementor-widget-image\" data-id=\"84f8944\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Htc7yfd8\/Kbrpzup2?utm_source=Direto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=planilhas-controle-financeiro-dual&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-financeira2.png\" class=\"attachment-large size-large wp-image-8354\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-financeira2.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-financeira2-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-financeira2-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1fdbb1 elementor-widget elementor-widget-image\" data-id=\"e1fdbb1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/pay.kiwify.com.br\/ncKTGdo\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-fc.png\" class=\"attachment-large size-large wp-image-8377\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-fc.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-fc-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-fc-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67a6ea1 elementor-widget elementor-widget-image\" data-id=\"67a6ea1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Tjvp3h33\/Q8zra5d6\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png\" class=\"attachment-large size-large wp-image-8381\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a4d5354 elementor-widget elementor-widget-image\" data-id=\"a4d5354\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/C433xjc5\/Mdv632r4\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m15.png\" class=\"attachment-large size-large wp-image-8383\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m15.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m15-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m15-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a4e5f7 elementor-widget elementor-widget-text-editor\" data-id=\"2a4e5f7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1>1. Fun\u00e7\u00e3o INDIRETO: Tornando suas planilhas din\u00e2micas<\/h1><p class=\"isSelectedEnd\">A fun\u00e7\u00e3o <strong>INDIRETO<\/strong> permite transformar um texto em uma refer\u00eancia de c\u00e9lula.<\/p><p class=\"isSelectedEnd\">Em outras palavras, voc\u00ea pode construir refer\u00eancias automaticamente sem precisar alterar suas f\u00f3rmulas.<\/p><h3>Sintaxe<\/h3><pre dir=\"ltr\"><code dir=\"ltr\">=INDIRETO(ref_texto)<\/code><\/pre><h3>Exemplo<\/h3><p class=\"isSelectedEnd\">Imagine que a c\u00e9lula A1 contenha o texto:<\/p><pre dir=\"ltr\"><code dir=\"ltr\">B10<\/code><\/pre><p class=\"isSelectedEnd\">Na c\u00e9lula C1 voc\u00ea utiliza:<\/p><pre dir=\"ltr\"><code dir=\"ltr\">=INDIRETO(A1)<\/code><\/pre><p class=\"isSelectedEnd\">O Excel retornar\u00e1 exatamente o conte\u00fado da c\u00e9lula B10.<\/p><h3>Onde utilizar<\/h3><ul data-spread=\"false\"><li>Dashboards din\u00e2micos<\/li><li>Consolida\u00e7\u00e3o de planilhas<\/li><li>Relat\u00f3rios mensais<\/li><li>Sele\u00e7\u00e3o autom\u00e1tica de intervalos<\/li><li>Refer\u00eancias entre abas<\/li><\/ul><h3>Dica Profissional<\/h3><p>Voc\u00ea pode combinar INDIRETO com listas suspensas para criar pain\u00e9is totalmente din\u00e2micos.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86403a5 elementor-widget elementor-widget-video\" data-id=\"86403a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=EzevwywpZ6I&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-621913e elementor-widget elementor-widget-text-editor\" data-id=\"621913e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1>2. SOMASES: Muito mais poderosa que a SOMA<\/h1><p class=\"isSelectedEnd\">Se voc\u00ea ainda utiliza filtros para descobrir quanto vendeu determinada equipe ou regi\u00e3o, provavelmente est\u00e1 desperdi\u00e7ando tempo.<\/p><p class=\"isSelectedEnd\">A fun\u00e7\u00e3o <strong>SOMASES<\/strong> soma valores considerando v\u00e1rios crit\u00e9rios ao mesmo tempo.<\/p><h3>Sintaxe<\/h3><pre dir=\"ltr\"><code dir=\"ltr\">=SOMASES(intervalo_soma; intervalo_criterio1; criterio1; intervalo_criterio2; criterio2)<\/code><\/pre><h3>Exemplo<\/h3><p class=\"isSelectedEnd\">Imagine uma tabela com:<\/p><table><tbody><tr><th>Regi\u00e3o<\/th><th>Vendedor<\/th><th>Valor<\/th><\/tr><tr><td>Sul<\/td><td>Jo\u00e3o<\/td><td>2500<\/td><\/tr><tr><td>Sul<\/td><td>Maria<\/td><td>1800<\/td><\/tr><tr><td>Norte<\/td><td>Jo\u00e3o<\/td><td>3200<\/td><\/tr><\/tbody><\/table><p class=\"isSelectedEnd\">Desejando somar apenas as vendas do Jo\u00e3o na Regi\u00e3o Sul:<\/p><pre dir=\"ltr\"><code dir=\"ltr\">=SOMASES(C2:C4;A2:A4;\"Sul\";B2:B4;\"Jo\u00e3o\")<\/code><\/pre><p class=\"isSelectedEnd\">Resultado:<\/p><p class=\"isSelectedEnd\"><strong>R$ 2.500<\/strong><\/p><h3>Aplica\u00e7\u00f5es<\/h3><ul data-spread=\"false\"><li>Controle financeiro<\/li><li>RH<\/li><li>Comercial<\/li><li>Estoque<\/li><li>Indicadores<\/li><\/ul><p>\u00c9 uma das fun\u00e7\u00f5es mais utilizadas em dashboards profissionais.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ba9308 elementor-widget elementor-widget-heading\" data-id=\"4ba9308\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Que tal aproveitar as ofertas exclusivas dos nossos cursos online?<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0defca7 elementor-widget elementor-widget-text-editor\" data-id=\"0defca7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>OBS. Os valores podem sofre altera\u00e7\u00f5es sem aviso pr\u00e9vio! Clique sobre a imagem para acessar a oferta.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-502fce1 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"502fce1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-0d697c8 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"0d697c8\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-dcb4061 e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"dcb4061\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9db341e elementor-widget elementor-widget-image\" data-id=\"9db341e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/pay.kiwify.com.br\/8bGr7UE\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"720\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva.png\" class=\"attachment-large size-large wp-image-7976\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva.png 720w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-300x300.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-230x230.png 230w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-400x400.png 400w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-600x600.png 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-640x640.png 640w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14d6d2a elementor-widget elementor-widget-image\" data-id=\"14d6d2a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/pay.kiwify.com.br\/ncKTGdo\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"720\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc.png\" class=\"attachment-large size-large wp-image-7979\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc.png 720w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-300x300.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-230x230.png 230w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-400x400.png 400w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-600x600.png 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-640x640.png 640w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efc494c elementor-widget elementor-widget-image\" data-id=\"efc494c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/pay.kiwify.com.br\/BUhjO61\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-1024x1024.jpg\" class=\"attachment-large size-large wp-image-7980\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-1024x1024.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-300x300.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-150x150.jpg 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-768x768.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-230x230.jpg 230w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-400x400.jpg 400w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-600x600.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-640x640.jpg 640w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1.jpg 1125w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be147cd elementor-widget elementor-widget-text-editor\" data-id=\"be147cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1>3. \u00daNICO: O fim das listas duplicadas<\/h1><p class=\"isSelectedEnd\">Se voc\u00ea utiliza &#8220;Remover Duplicatas&#8221; toda semana, vai gostar desta fun\u00e7\u00e3o.<\/p><p class=\"isSelectedEnd\">A fun\u00e7\u00e3o <strong>\u00daNICO<\/strong> gera automaticamente uma lista sem repeti\u00e7\u00f5es.<\/p><h3>Sintaxe<\/h3><pre dir=\"ltr\"><code dir=\"ltr\">=\u00daNICO(intervalo)<\/code><\/pre><h3>Exemplo<\/h3><p class=\"isSelectedEnd\">Lista original:<\/p><pre dir=\"ltr\"><code dir=\"ltr\">Jo\u00e3o\nMaria\nJo\u00e3o\nCarlos\nMaria<\/code><\/pre><p class=\"isSelectedEnd\">Resultado:<\/p><pre dir=\"ltr\"><code dir=\"ltr\">Jo\u00e3o\nMaria\nCarlos<\/code><\/pre><p class=\"isSelectedEnd\">Sempre que novos dados forem adicionados, a lista ser\u00e1 atualizada automaticamente.<\/p><h3>Onde usar<\/h3><ul data-spread=\"false\"><li>Listas suspensas<\/li><li>Dashboards<\/li><li>Relat\u00f3rios<\/li><li>Cadastro de clientes<\/li><li>Produtos<\/li><li>Departamentos<\/li><\/ul><div contenteditable=\"false\"><hr \/><\/div><h1>4. Lista Personalizada: O recurso escondido do Excel<\/h1><p class=\"isSelectedEnd\">Pouqu\u00edssimas pessoas conhecem esse recurso.<\/p><p class=\"isSelectedEnd\">A Lista Personalizada permite criar sequ\u00eancias pr\u00f3prias para preencher c\u00e9lulas automaticamente.<\/p><p class=\"isSelectedEnd\">Por exemplo:<\/p><pre dir=\"ltr\"><code dir=\"ltr\">N\u00edvel 1\nN\u00edvel 2\nN\u00edvel 3\nN\u00edvel 4<\/code><\/pre><p class=\"isSelectedEnd\">Ou<\/p><pre dir=\"ltr\"><code dir=\"ltr\">Financeiro\nRH\nCompras\nProdu\u00e7\u00e3o\nLog\u00edstica<\/code><\/pre><p class=\"isSelectedEnd\">Depois de cadastrada, basta arrastar a al\u00e7a de preenchimento para que o Excel complete toda a sequ\u00eancia.<\/p><h3>Como criar<\/h3><ol start=\"1\" data-spread=\"false\"><li>Arquivo<\/li><li>Op\u00e7\u00f5es<\/li><li>Avan\u00e7ado<\/li><li>Editar Listas Personalizadas<\/li><li>Inserir sua lista<\/li><\/ol><p class=\"isSelectedEnd\">Pronto.<\/p><p>Sempre que precisar dessa sequ\u00eancia, ela estar\u00e1 dispon\u00edvel.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b7af720 elementor-widget elementor-widget-image\" data-id=\"b7af720\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/api.whatsapp.com\/send\/?phone=5511968986914&#038;text=Gostaria+de+saber+como+fa%C3%A7o+para+ter+minha+marca+divulgada+em+seu+site%3F&#038;type=phone_number&#038;app_absent=0&#038;utm_source=Direto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=x&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1022\" height=\"186\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902.jpg\" class=\"attachment-large size-large wp-image-7970\" alt=\"sua marca aqui\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902.jpg 1022w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902-300x55.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902-768x140.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902-600x109.jpg 600w\" sizes=\"(max-width: 1022px) 100vw, 1022px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c1da7 elementor-widget elementor-widget-text-editor\" data-id=\"e8c1da7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1>Como essas fun\u00e7\u00f5es trabalham juntas?<\/h1><p class=\"isSelectedEnd\">Imagine um Dashboard Comercial.<\/p><p class=\"isSelectedEnd\">Voc\u00ea pode utilizar:<\/p><ul data-spread=\"false\"><li><strong>\u00daNICO<\/strong> para listar automaticamente os vendedores;<\/li><li><strong>Lista Personalizada<\/strong> para ordenar departamentos;<\/li><li><strong>SOMASES<\/strong> para calcular indicadores;<\/li><li><strong>INDIRETO<\/strong> para trocar dinamicamente a origem das informa\u00e7\u00f5es.<\/li><\/ul><p>\u00c9 exatamente essa combina\u00e7\u00e3o que torna dashboards profissionais r\u00e1pidos, organizados e f\u00e1ceis de atualizar.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6dcca85 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"6dcca85\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-68f3c5c e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"68f3c5c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-599927c elementor-widget elementor-widget-heading\" data-id=\"599927c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Conhe\u00e7am nossos pacotes de Dashboards<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d17c751 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"d17c751\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-652ab5f e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"652ab5f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-86798dd elementor-widget elementor-widget-image\" data-id=\"86798dd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Z6kmgtk2\/Yh6egwp4\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"903\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000.png\" class=\"attachment-large size-large wp-image-7843\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000.png 621w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000-206x300.png 206w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000-600x872.png 600w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-65ca8f7 elementor-widget elementor-widget-image\" data-id=\"65ca8f7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/pay.kiwify.com.br\/Tv5opMh\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"903\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150.png\" class=\"attachment-large size-large wp-image-7844\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150.png 621w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150-206x300.png 206w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150-600x872.png 600w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aae76c5 elementor-widget elementor-widget-image\" data-id=\"aae76c5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Uvsnz837\/Kgapf219\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"903\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400.png\" class=\"attachment-large size-large wp-image-7845\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400.png 621w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400-206x300.png 206w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400-600x872.png 600w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c0c2b4 elementor-widget elementor-widget-text-editor\" data-id=\"1c0c2b4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1>Qual delas voc\u00ea deveria aprender primeiro?<\/h1><p class=\"isSelectedEnd\">Se sua rotina envolve an\u00e1lises de dados, esta \u00e9 uma boa ordem de aprendizado:<\/p><p class=\"isSelectedEnd\">\ud83e\udd47 SOMASES<\/p><p class=\"isSelectedEnd\">\ud83e\udd48 \u00daNICO<\/p><p class=\"isSelectedEnd\">\ud83e\udd49 INDIRETO<\/p><p class=\"isSelectedEnd\">\ud83c\udfc5 Lista Personalizada<\/p><p class=\"isSelectedEnd\">Em poucas horas de pr\u00e1tica, voc\u00ea j\u00e1 perceber\u00e1 ganhos significativos de produtividade.<\/p><div contenteditable=\"false\"><hr \/><\/div><h1>Conclus\u00e3o<\/h1><p class=\"isSelectedEnd\">O Excel possui centenas de fun\u00e7\u00f5es, mas poucas conseguem gerar tanto impacto quanto <strong>INDIRETO<\/strong>, <strong>SOMASES<\/strong>, <strong>\u00daNICO<\/strong> e o recurso de <strong>Lista Personalizada<\/strong>.<\/p><p class=\"isSelectedEnd\">Essas ferramentas permitem automatizar tarefas, reduzir erros, criar relat\u00f3rios inteligentes e construir dashboards que impressionam gestores e clientes.<\/p><p class=\"isSelectedEnd\">Se voc\u00ea deseja se destacar no mercado de trabalho, dominar essas fun\u00e7\u00f5es \u00e9 um excelente pr\u00f3ximo passo.<\/p><p>Lembre-se: produtividade n\u00e3o significa trabalhar mais. Significa permitir que o Excel trabalhe por voc\u00ea.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b4987b elementor-widget elementor-widget-image\" data-id=\"2b4987b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4-1024x576.jpg\" class=\"attachment-large size-large wp-image-8501\" alt=\"4 Fun\u00e7\u00f5es do Excel que Pouca Gente Usa, Mas Que Podem Dobrar Sua Produtividade\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4-1024x576.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4-300x169.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4-768x432.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4-150x85.jpg 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4-600x338.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c4ea7cd e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"c4ea7cd\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-db7938c wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"db7938c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"wpr-grid-filters elementor-clearfix wpr-grid-filters-sep-right\"><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span  data-filter=\"*\" class=\"wpr-grid-filters-item wpr-active-filter \">All Posts<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"blog\"]  data-filter=\".category-blog\">Blog<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"certificados\"]  data-filter=\".category-certificados\">Certificados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"diversos\"]  data-filter=\".category-diversos\">Diversos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"excel\"]  data-filter=\".category-excel\">Excel<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"fpw\"]  data-filter=\".category-fpw\">FPw<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"membros\"]  data-filter=\".category-membros\">Membros<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"noticias\"]  data-filter=\".category-noticias\">Not\u00c3\u00adcias<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"planilhas\"]  data-filter=\".category-planilhas\">Planilhas<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"produtos\"]  data-filter=\".category-produtos\">Produtos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"sql\"]  data-filter=\".category-sql\">SQL<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"tecnologia\"]  data-filter=\".category-tecnologia\">Tecnologia<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"wordpress\"]  data-filter=\".category-wordpress\">WordPress<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><\/ul><section class=\"wpr-grid elementor-clearfix\" data-settings=\"{&quot;layout&quot;:&quot;fitRows&quot;,&quot;stick_last_element_to_bottom&quot;:&quot;&quot;,&quot;columns_desktop&quot;:3,&quot;gutter_hr&quot;:15,&quot;gutter_hr_mobile&quot;:15,&quot;gutter_hr_mobile_extra&quot;:15,&quot;gutter_hr_tablet&quot;:15,&quot;gutter_hr_tablet_extra&quot;:15,&quot;gutter_hr_laptop&quot;:15,&quot;gutter_hr_widescreen&quot;:15,&quot;gutter_vr&quot;:15,&quot;gutter_vr_mobile&quot;:15,&quot;gutter_vr_mobile_extra&quot;:15,&quot;gutter_vr_tablet&quot;:15,&quot;gutter_vr_tablet_extra&quot;:15,&quot;gutter_vr_laptop&quot;:15,&quot;gutter_vr_widescreen&quot;:15,&quot;animation&quot;:&quot;default&quot;,&quot;animation_duration&quot;:0.3,&quot;animation_delay&quot;:0.1,&quot;deeplinking&quot;:&quot;&quot;,&quot;filters_linkable&quot;:&quot;no&quot;,&quot;filters_default_filter&quot;:&quot;&quot;,&quot;filters_count&quot;:&quot;&quot;,&quot;filters_hide_empty&quot;:&quot;no&quot;,&quot;filters_animation&quot;:&quot;default&quot;,&quot;filters_animation_duration&quot;:0.3,&quot;filters_animation_delay&quot;:0.1,&quot;pagination_type&quot;:&quot;load-more&quot;,&quot;pagination_max_pages&quot;:113,&quot;lightbox&quot;:{&quot;selector&quot;:&quot;.wpr-grid-image-wrap&quot;,&quot;iframeMaxWidth&quot;:&quot;60%&quot;,&quot;hash&quot;:false,&quot;autoplay&quot;:&quot;true&quot;,&quot;pause&quot;:5000,&quot;progressBar&quot;:&quot;true&quot;,&quot;counter&quot;:&quot;true&quot;,&quot;controls&quot;:&quot;true&quot;,&quot;getCaptionFromTitleOrAlt&quot;:&quot;true&quot;,&quot;thumbnail&quot;:&quot;&quot;,&quot;showThumbByDefault&quot;:&quot;&quot;,&quot;share&quot;:&quot;&quot;,&quot;zoom&quot;:&quot;true&quot;,&quot;fullScreen&quot;:&quot;true&quot;,&quot;download&quot;:&quot;true&quot;}}\" data-advanced-filters=\"no\"><article class=\"wpr-grid-item elementor-clearfix post-9253 post type-post status-publish format-standard has-post-thumbnail hentry category-excel\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.jpg\" alt=\"Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\">Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9168 post type-post status-publish format-standard has-post-thumbnail hentry category-excel tag-aprenda-como-usar-no-excel-avancado tag-aprenda-todas-as-possibilidades-de-formatacoes-no-excel tag-como-desproteger-um-arquivo-do-excel-protegido-por-senha tag-crie-um-sistema-de-sorteio-no-excel-de-forma-simples tag-dashboard tag-dashboard-financeiro tag-dashboard-financeiro-pessoal tag-dashboard-para-controle-financeiro tag-dashboard-rh-controle-de-desligamentos tag-dashboard-seguranca-do-trabalho tag-excel tag-formula-se-com-procv tag-funcao-arrumar-com-alguns-truques tag-funcoes-basicas-do-excel tag-funcoes-basicas-operadores tag-grafico-medidor-de-bateria tag-menu-dados-completo tag-montando-um-resumo-de-diversas-planilhas-com-somase tag-planilha-de-controle-financeiro-tudo-o-que-voce-precisa-saber tag-planilhas tag-procv-junto-com-o-corresp tag-protegendo-celulas tag-saiba-tudo-da-parte-de-dados tag-software-de-planilha-online-gratuito-excel-microsoft-365 tag-tudo-sobre-formatacao-de-celulas tag-tudo-sobre-lista-suspensa-no-excel tag-tudo-sobre-tabela-e-graficos-dinamicos\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Excel-Como-corrigir-o-erro-ND-no-Excel.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Excel-Como-corrigir-o-erro-ND-no-Excel.jpg\" alt=\"Como corrigir o erro #N\/D no Excel?\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\">Excel | Como corrigir o erro #N\/D no Excel?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9018 post type-post status-publish format-standard has-post-thumbnail hentry category-fpw tag-curso-fpw tag-fpw tag-fpw-nuvem tag-fpw-on-prime tag-o-que-e-fpw-on-prime tag-o-que-significa-fpw tag-porque-o-fpw-trocou-de-nome tag-sistema-fpw-da-lg-sistemas-uma-visao-abrangente\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/fpw-Por-que-o-FPw-e-o-LG-Nuvem-sao-referencias-em-Folha-de-Pagamento-no-Brasil.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/fpw-Por-que-o-FPw-e-o-LG-Nuvem-sao-referencias-em-Folha-de-Pagamento-no-Brasil.jpg\" alt=\"Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\">FPw | Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><\/section>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0e421c9 elementor-search-form--skin-classic elementor-search-form--button-type-icon elementor-search-form--icon-search elementor-widget elementor-widget-search-form\" data-id=\"0e421c9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;skin&quot;:&quot;classic&quot;}\" data-widget_type=\"search-form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<search role=\"search\">\n\t\t\t<form class=\"elementor-search-form\" action=\"https:\/\/fpw.com.br\/m\" method=\"get\">\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-search-form__container\">\n\t\t\t\t\t<label class=\"elementor-screen-only\" for=\"elementor-search-form-0e421c9\">Search<\/label>\n\n\t\t\t\t\t\n\t\t\t\t\t<input id=\"elementor-search-form-0e421c9\" placeholder=\"Search...\" class=\"elementor-search-form__input\" type=\"search\" name=\"s\" value=\"\">\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<button class=\"elementor-search-form__submit\" type=\"submit\" aria-label=\"Search\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"e-font-icon-svg-container\"><svg class=\"fa fa-search e-font-icon-svg e-fas-search\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M505 442.7L405.3 343c-4.5-4.5-10.6-7-17-7H372c27.6-35.3 44-79.7 44-128C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c48.3 0 92.7-16.4 128-44v16.3c0 6.4 2.5 12.5 7 17l99.7 99.7c9.4 9.4 24.6 9.4 33.9 0l28.3-28.3c9.4-9.4 9.4-24.6.1-34zM208 336c-70.7 0-128-57.2-128-128 0-70.7 57.2-128 128-128 70.7 0 128 57.2 128 128 0 70.7-57.2 128-128 128z\"><\/path><\/svg><\/div>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/form>\n\t\t<\/search>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73e0cad elementor-widget elementor-widget-image\" data-id=\"73e0cad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/pay.kiwify.com.br\/k8pQpys\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"480\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/09\/dash-oferta.jpg\" class=\"attachment-large size-large wp-image-7443\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/09\/dash-oferta.jpg 320w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/09\/dash-oferta-200x300.jpg 200w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dfe196e elementor-widget elementor-widget-image\" data-id=\"dfe196e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Zww7rrr4\/Hi8hxk47\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"480\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/precificacao.jpg\" class=\"attachment-large size-large wp-image-8204\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/precificacao.jpg 320w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/precificacao-200x300.jpg 200w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9418cd9 elementor-widget elementor-widget-image\" data-id=\"9418cd9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Gjplwgr4\/Kk18fkp5\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-planilnha-premium.png\" class=\"attachment-large size-large wp-image-8323\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-planilnha-premium.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-planilnha-premium-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-planilnha-premium-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e0f208 elementor-widget elementor-widget-link-in-bio\" data-id=\"4e0f208\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"link-in-bio.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio e-link-in-bio\">\n\t\t\t<div class=\"e-link-in-bio__content\">\n\n\t\t\t\t\t\t<div class=\"e-link-in-bio__identity\">\n\t\t\t\t\t\t\t\t\t<div class=\"e-link-in-bio__identity-image e-link-in-bio__identity-image-profile has-style-circle\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"291\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli-300x291.png\" class=\"e-link-in-bio__identity-image-element\" alt=\"Marco Antonio Chinarelli\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli-300x291.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli.png 386w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"e-link-in-bio__bio\">\n\t\t\t\t<h3 class=\"e-link-in-bio__heading\">Marco Chinarelli<\/h3>\t\t\t\t<h3 class=\"e-link-in-bio__title\">Especialista e Professor em Excel, pacote Office e Sistema de Folha de Pagamento<\/h3>\t\t\t\t\t\t\t\t<p class=\"e-link-in-bio__description\">Junte-se a n\u00f3s nesta Jornada pelo Mundo da Tecnologia recheada de Excel<\/p>\t\t\t<\/div>\n\t\t\t\t\t<div class=\"e-link-in-bio__icons has-size-small\">\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/chinarelliti\/\" target=\"_blank\" rel=\"noopener \" aria-label=\"LinkedIn\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin-in\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M100.28 448H7.4V148.9h92.88zM53.79 108.1C24.09 108.1 0 83.5 0 53.8a53.79 53.79 0 0 1 107.58 0c0 29.7-24.1 54.3-53.79 54.3zM447.9 448h-92.68V302.4c0-34.7-.7-79.2-48.29-79.2-48.29 0-55.69 37.7-55.69 76.7V448h-92.78V148.9h89.08v40.8h1.3c12.4-23.5 42.69-48.3 87.88-48.3 94 0 111.28 61.9 111.28 142.3V448z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.instagram.com\/marco_chinarelli\" target=\"_blank\" rel=\"noopener \" aria-label=\"Instagram\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-instagram\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M224.1 141c-63.6 0-114.9 51.3-114.9 114.9s51.3 114.9 114.9 114.9S339 319.5 339 255.9 287.7 141 224.1 141zm0 189.6c-41.1 0-74.7-33.5-74.7-74.7s33.5-74.7 74.7-74.7 74.7 33.5 74.7 74.7-33.6 74.7-74.7 74.7zm146.4-194.3c0 14.9-12 26.8-26.8 26.8-14.9 0-26.8-12-26.8-26.8s12-26.8 26.8-26.8 26.8 12 26.8 26.8zm76.1 27.2c-1.7-35.9-9.9-67.7-36.2-93.9-26.2-26.2-58-34.4-93.9-36.2-37-2.1-147.9-2.1-184.9 0-35.8 1.7-67.6 9.9-93.9 36.1s-34.4 58-36.2 93.9c-2.1 37-2.1 147.9 0 184.9 1.7 35.9 9.9 67.7 36.2 93.9s58 34.4 93.9 36.2c37 2.1 147.9 2.1 184.9 0 35.9-1.7 67.7-9.9 93.9-36.2 26.2-26.2 34.4-58 36.2-93.9 2.1-37 2.1-147.8 0-184.8zM398.8 388c-7.8 19.6-22.9 34.7-42.6 42.6-29.5 11.7-99.5 9-132.1 9s-102.7 2.6-132.1-9c-19.6-7.8-34.7-22.9-42.6-42.6-11.7-29.5-9-99.5-9-132.1s-2.6-102.7 9-132.1c7.8-19.6 22.9-34.7 42.6-42.6 29.5-11.7 99.5-9 132.1-9s102.7-2.6 132.1 9c19.6 7.8 34.7 22.9 42.6 42.6 11.7 29.5 9 99.5 9 132.1s2.7 102.7-9 132.1z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.youtube.com\/@dashimpressionador\" target=\"_blank\" rel=\"noopener \" aria-label=\"YouTube\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-youtube\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M549.655 124.083c-6.281-23.65-24.787-42.276-48.284-48.597C458.781 64 288 64 288 64S117.22 64 74.629 75.486c-23.497 6.322-42.003 24.947-48.284 48.597-11.412 42.867-11.412 132.305-11.412 132.305s0 89.438 11.412 132.305c6.281 23.65 24.787 41.5 48.284 47.821C117.22 448 288 448 288 448s170.78 0 213.371-11.486c23.497-6.321 42.003-24.171 48.284-47.821 11.412-42.867 11.412-132.305 11.412-132.305s0-89.438-11.412-132.305zm-317.51 213.508V175.185l142.739 81.205-142.739 81.201z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/twitter.com\/mchinarelli\" target=\"_blank\" rel=\"noopener \" aria-label=\"X (Twitter)\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-x-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\n\t\t<div class=\"e-link-in-bio__ctas has-type-button\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/pay.hotmart.com\/G98229179R?off=ru4d1ctf&#038;bid=1747747718132\" target=\"_blank\" rel=\"noopener \" class=\"e-link-in-bio__cta is-type-button has-corners-rounded\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"e-link-in-bio__cta-text\">\n\t\t\t\t\t\tCurso Excel Total Promo\u00e7\u00e3o\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\t\t\t<a href=\"https:\/\/fpw.com.br\/m\/produtos-curso-de-dashboard\/\" target=\"_blank\" rel=\"noopener \" class=\"e-link-in-bio__cta is-type-button has-corners-rounded\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"e-link-in-bio__cta-text\">\n\t\t\t\t\t\tCurso Do Zero ao Dashboard\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\n\t\t\t<\/div>\n\t\t\t<div class=\"e-link-in-bio__bg\">\n\t\t\t\t<div class=\"e-link-in-bio__bg-overlay\"><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f8d714 elementor-widget elementor-widget-image\" data-id=\"3f8d714\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Vye79iq6\/Z9nnhh91\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"394\" height=\"506\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/pb2.png\" class=\"attachment-large size-large wp-image-8312\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/pb2.png 394w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/pb2-234x300.png 234w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42fc103 elementor-widget elementor-widget-image\" data-id=\"42fc103\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Mx31hue3\/Bp4icrc3\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"636\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-sst.png\" class=\"attachment-large size-large wp-image-8180\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-sst.png 458w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-sst-216x300.png 216w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d333768 elementor-widget elementor-widget-image\" data-id=\"d333768\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/checkout\/Yjhhihn5\/M9quupr6\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"636\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-rh.png\" class=\"attachment-large size-large wp-image-8179\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-rh.png 458w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-rh-216x300.png 216w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f6809c1 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"f6809c1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8d3b722 wpr-comment-reply-separate wpr-comment-reply-align-right elementor-widget elementor-widget-wpr-post-comments\" data-id=\"8d3b722\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-post-comments.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"wpr-comments-wrap\" id=\"comments\"><h3> 3 Comments<\/h3><ul class=\"wpr-comments-list\"><li id=\"comment-171556\" class=\"pingback even thread-even depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-botoes-interativos-no-excel\/\">Excel | Bot\u00f5es interativos no Excel &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>21 de setembro de 2026 at 22:50<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/?replytocom=171556#respond\" data-commentid=\"171556\" data-postid=\"9018\" data-belowelement=\"comment-171556\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Bot\u00f5es interativos no Excel &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Bot\u00f5es interativos no Excel &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<li id=\"comment-171555\" class=\"pingback odd alt thread-odd thread-alt depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\">Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>20 de setembro de 2026 at 14:59<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/?replytocom=171555#respond\" data-commentid=\"171555\" data-postid=\"9018\" data-belowelement=\"comment-171555\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<li id=\"comment-171553\" class=\"pingback even thread-even depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\">Excel | Como corrigir o erro #N\/D no Excel? &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>16 de setembro de 2026 at 13:59<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Por que o FPw e o LG Nuvem s\u00c3\u00a3o refer\u00c3\u00aancias em Folha de Pagamento no Brasil? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/?replytocom=171553#respond\" data-commentid=\"171553\" data-postid=\"9018\" data-belowelement=\"comment-171553\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Como corrigir o erro #N\/D no Excel? &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Como corrigir o erro #N\/D no Excel? &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<\/ul>\t<div id=\"respond\" class=\"comment-respond\">\n\t\t<h3 id=\"wpr-reply-title\" class=\"wpr-comment-reply-title\">Leave a Reply <small><a rel=\"nofollow\" id=\"cancel-comment-reply-link\" href=\"\/m\/wp-json\/wp\/v2\/posts\/8500#respond\" style=\"display:none;\">Cancelar resposta<\/a><\/small><\/h3><form action=\"https:\/\/fpw.com.br\/m\/wp-comments-post.php\" method=\"post\" id=\"wpr-comment-form\" class=\"wpr-comment-form wpr-cf-style-5\"><p class=\"comment-notes\"><span id=\"email-notes\">O seu endere\u00e7o de e-mail n\u00e3o ser\u00e1 publicado.<\/span> <span class=\"required-field-message\">Campos obrigat\u00f3rios s\u00e3o marcados com <span class=\"required\">*<\/span><\/span><\/p><div class=\"wpr-comment-form-text\"><label>Message<span>*<\/span><\/label><textarea autocomplete=\"new-password\"   name=\"ea4449d22c\"  placeholder=\"\" cols=\"45\" rows=\"8\" maxlength=\"65525\"><\/textarea><textarea id=\"comment\" aria-label=\"hp-comment\" aria-hidden=\"true\" name=\"comment\" autocomplete=\"new-password\" style=\"padding:0 !important;clip:rect(1px, 1px, 1px, 1px) !important;position:absolute !important;white-space:nowrap !important;height:1px !important;width:1px !important;overflow:hidden !important;\" tabindex=\"-1\"><\/textarea><\/div><p class=\"comment-form-author\"><input id=\"author\" class=\"comment-form__field\" name=\"author\" type=\"text\" placeholder=\"Nome *\" value=\"\" size=\"30\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-email\"><input id=\"email\" class=\"comment-form__field\" name=\"email\" type=\"text\" placeholder=\"E-mail *\" value=\"\" size=\"30\" aria-describedby=\"email-notes\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-url\"><input id=\"url\" class=\"comment-form__field\" name=\"url\" type=\"text\" placeholder=\"Site\" value=\"\" size=\"30\" \/><\/p>\n<p class=\"form-submit\"><input name=\"submit\" type=\"submit\" id=\"wpr-submit-comment\" class=\"wpr-submit-comment\" value=\"Submit\" \/> <input type='hidden' name='comment_post_ID' value='9018' id='comment_post_ID' \/>\n<input type='hidden' name='comment_parent' id='comment_parent' value='0' \/>\n<\/p><\/form>\t<\/div><!-- #respond -->\n\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>4 Fun\u00e7\u00f5es do Excel Pouca Gente Usa, Mas Que Podem Dobrar Sua Produtividade Voc\u00ea j\u00e1 teve a sensa\u00e7\u00e3o de que passa mais tempo ajustando planilhas do que analisando informa\u00e7\u00f5es? Enquanto muitos usu\u00e1rios utilizam apenas SOMA, M\u00c9DIA e PROCV, existe um grupo de fun\u00e7\u00f5es que permanece &#8220;escondido&#8221; para a maioria dos profissionais. Curiosamente, s\u00e3o justamente essas fun\u00e7\u00f5es que analistas, controladores financeiros e especialistas em Business Intelligence utilizam para automatizar tarefas e construir planilhas inteligentes. O mais interessante \u00e9 que elas n\u00e3o s\u00e3o dif\u00edceis de aprender. Neste artigo voc\u00ea conhecer\u00e1 quatro fun\u00e7\u00f5es que podem elevar seu n\u00edvel no Excel: INDIRETO, SOMASES, \u00daNICO e um recurso extremamente \u00fatil chamado Lista Personalizada. Ao final da leitura, voc\u00ea perceber\u00e1 que provavelmente j\u00e1 enfrentou problemas que poderiam ser resolvidos com apenas uma dessas ferramentas. Adquira nossos produtos \u00e0 partir de R$ 5,99 e ajude-nos a continuar a trazer novos conte\u00fados relevantes 1. Fun\u00e7\u00e3o INDIRETO: Tornando suas planilhas din\u00e2micas A fun\u00e7\u00e3o INDIRETO permite transformar um texto em uma refer\u00eancia de c\u00e9lula. Em outras palavras, voc\u00ea pode construir refer\u00eancias automaticamente sem precisar alterar suas f\u00f3rmulas. Sintaxe =INDIRETO(ref_texto) Exemplo Imagine que a c\u00e9lula A1 contenha o texto: B10 Na c\u00e9lula C1 voc\u00ea utiliza: =INDIRETO(A1) O Excel retornar\u00e1 exatamente o conte\u00fado da c\u00e9lula B10. Onde utilizar Dashboards din\u00e2micos Consolida\u00e7\u00e3o de planilhas Relat\u00f3rios mensais Sele\u00e7\u00e3o autom\u00e1tica de intervalos Refer\u00eancias entre abas Dica Profissional Voc\u00ea pode combinar INDIRETO com listas suspensas para criar pain\u00e9is totalmente din\u00e2micos. https:\/\/www.youtube.com\/watch?v=EzevwywpZ6I 2. SOMASES: Muito mais poderosa que a SOMA Se voc\u00ea ainda utiliza filtros para descobrir quanto vendeu determinada equipe ou regi\u00e3o, provavelmente est\u00e1 desperdi\u00e7ando tempo. A fun\u00e7\u00e3o SOMASES soma valores considerando v\u00e1rios crit\u00e9rios ao mesmo tempo. Sintaxe =SOMASES(intervalo_soma; intervalo_criterio1; criterio1; intervalo_criterio2; criterio2) Exemplo Imagine uma tabela com: Regi\u00e3o Vendedor Valor Sul Jo\u00e3o 2500 Sul Maria 1800 Norte Jo\u00e3o 3200 Desejando somar apenas as vendas do Jo\u00e3o na Regi\u00e3o Sul: =SOMASES(C2:C4;A2:A4;&#8221;Sul&#8221;;B2:B4;&#8221;Jo\u00e3o&#8221;) Resultado: R$ 2.500 Aplica\u00e7\u00f5es Controle financeiro RH Comercial Estoque Indicadores \u00c9 uma das fun\u00e7\u00f5es mais utilizadas em dashboards profissionais. Que tal aproveitar as ofertas exclusivas dos nossos cursos online? OBS. Os valores podem sofre altera\u00e7\u00f5es sem aviso pr\u00e9vio! Clique sobre a imagem para acessar a oferta. 3. \u00daNICO: O fim das listas duplicadas Se voc\u00ea utiliza &#8220;Remover Duplicatas&#8221; toda semana, vai gostar desta fun\u00e7\u00e3o. A fun\u00e7\u00e3o \u00daNICO gera automaticamente uma lista sem repeti\u00e7\u00f5es. Sintaxe =\u00daNICO(intervalo) Exemplo Lista original: Jo\u00e3o Maria Jo\u00e3o Carlos Maria Resultado: Jo\u00e3o Maria Carlos Sempre que novos dados forem adicionados, a lista ser\u00e1 atualizada automaticamente. Onde usar Listas suspensas Dashboards Relat\u00f3rios Cadastro de clientes Produtos Departamentos 4. Lista Personalizada: O recurso escondido do Excel Pouqu\u00edssimas pessoas conhecem esse recurso. A Lista Personalizada permite criar sequ\u00eancias pr\u00f3prias para preencher c\u00e9lulas automaticamente. Por exemplo: N\u00edvel 1 N\u00edvel 2 N\u00edvel 3 N\u00edvel 4 Ou Financeiro RH Compras Produ\u00e7\u00e3o Log\u00edstica Depois de cadastrada, basta arrastar a al\u00e7a de preenchimento para que o Excel complete toda a sequ\u00eancia. Como criar Arquivo Op\u00e7\u00f5es Avan\u00e7ado Editar Listas Personalizadas Inserir sua lista Pronto. Sempre que precisar dessa sequ\u00eancia, ela estar\u00e1 dispon\u00edvel. Como essas fun\u00e7\u00f5es trabalham juntas? Imagine um Dashboard Comercial. Voc\u00ea pode utilizar: \u00daNICO para listar automaticamente os vendedores; Lista Personalizada para ordenar departamentos; SOMASES para calcular indicadores; INDIRETO para trocar dinamicamente a origem das informa\u00e7\u00f5es. \u00c9 exatamente essa combina\u00e7\u00e3o que torna dashboards profissionais r\u00e1pidos, organizados e f\u00e1ceis de atualizar. Conhe\u00e7am nossos pacotes de Dashboards Qual delas voc\u00ea deveria aprender primeiro? Se sua rotina envolve an\u00e1lises de dados, esta \u00e9 uma boa ordem de aprendizado: \ud83e\udd47 SOMASES \ud83e\udd48 \u00daNICO \ud83e\udd49 INDIRETO \ud83c\udfc5 Lista Personalizada Em poucas horas de pr\u00e1tica, voc\u00ea j\u00e1 perceber\u00e1 ganhos significativos de produtividade. Conclus\u00e3o O Excel possui centenas de fun\u00e7\u00f5es, mas poucas conseguem gerar tanto impacto quanto INDIRETO, SOMASES, \u00daNICO e o recurso de Lista Personalizada. Essas ferramentas permitem automatizar tarefas, reduzir erros, criar relat\u00f3rios inteligentes e construir dashboards que impressionam gestores e clientes. Se voc\u00ea deseja se destacar no mercado de trabalho, dominar essas fun\u00e7\u00f5es \u00e9 um excelente pr\u00f3ximo passo. Lembre-se: produtividade n\u00e3o significa trabalhar mais. Significa permitir que o Excel trabalhe por voc\u00ea. All Posts Blog Certificados Diversos Excel FPw Membros Not\u00edcias Planilhas Produtos SQL Tecnologia WordPress Excel | 4 Fun\u00e7\u00f5es do Excel que Pouca Gente Usa, Mas Que Podem Dobrar Sua Produtividade Leia mais Excel | Fun\u00e7\u00e3o PROCV no Excel Leia mais Excel | A habilidade de Excel que est\u00e1 fazendo profissionais serem promovidos em 2026 Leia mais Marco Chinarelli Especialista e Professor em Excel, pacote Office e Sistema de Folha de Pagamento Junte-se a n\u00f3s nesta Jornada pelo Mundo da Tecnologia recheada de Excel Curso Excel Total Promo\u00e7\u00e3o Curso Do Zero ao Dashboard Leave a Reply Cancelar resposta Conectado como Marco Chinarelli. Edite seu perfil. Sair? Campos obrigat\u00f3rios s\u00e3o marcados com * Message*<\/p>\n","protected":false},"author":2000,"featured_media":8501,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[49,90,84,92,259,260,261,40,262,263,29,48,77,55,56,103,5,101,81,86,98,87,6,47,74,75,93],"class_list":["post-8500","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-aprenda-como-usar-no-excel-avancado","tag-aprenda-todas-as-possibilidades-de-formatacoes-no-excel","tag-como-desproteger-um-arquivo-do-excel-protegido-por-senha","tag-crie-um-sistema-de-sorteio-no-excel-de-forma-simples","tag-dashboard","tag-dashboard-financeiro","tag-dashboard-financeiro-pessoal","tag-dashboard-para-controle-financeiro","tag-dashboard-rh-controle-de-desligamentos","tag-dashboard-seguranca-do-trabalho","tag-excel","tag-formula-se-com-procv","tag-funcao-arrumar-com-alguns-truques","tag-funcoes-basicas-do-excel","tag-funcoes-basicas-operadores","tag-grafico-medidor-de-bateria","tag-menu-dados-completo","tag-montando-um-resumo-de-diversas-planilhas-com-somase","tag-planilha-de-controle-financeiro-tudo-o-que-voce-precisa-saber","tag-planilhas","tag-procv-junto-com-o-corresp","tag-protegendo-celulas","tag-saiba-tudo-da-parte-de-dados","tag-software-de-planilha-online-gratuito-excel-microsoft-365","tag-tudo-sobre-formatacao-de-celulas","tag-tudo-sobre-lista-suspensa-no-excel","tag-tudo-sobre-tabela-e-graficos-dinamicos"],"jetpack_sharing_enabled":true,"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/4.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/users\/2000"}],"replies":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/comments?post=8500"}],"version-history":[{"count":0,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8500\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/8501"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=8500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=8500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=8500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}