{"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-09-26T15:17:04","modified_gmt":"2026-09-26T15:17:04","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-12b2164 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=\"12b2164\" 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<div class=\"elementor-element elementor-element-398a47c elementor-widget elementor-widget-heading\" data-id=\"398a47c\" 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\">- EXCEL \u2022 DICAS PR\u00c1TICAS -<\/h2>\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-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<div class=\"elementor-element elementor-element-523ca9b 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=\"523ca9b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-6faa13d 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=\"6faa13d\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-af3a561 elementor-search-form--skin-classic elementor-search-form--button-type-icon elementor-search-form--icon-search elementor-widget elementor-widget-search-form\" data-id=\"af3a561\" 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-af3a561\">Search<\/label>\n\n\t\t\t\t\t\n\t\t\t\t\t<input id=\"elementor-search-form-af3a561\" 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>\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<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-3a28d78 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=\"3a28d78\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-819d572 wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"819d572\" 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\",\"dados\"]  data-filter=\".category-dados\">Dados<\/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\",\"dashboard\"]  data-filter=\".category-dashboard\">Dashboard<\/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;:116,&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-10045 post type-post status-publish format-standard has-post-thumbnail hentry category-planilhas tag-excel tag-menu-dados-completo tag-pacote-de-graficos tag-saiba-tudo-da-parte-de-dados tag-todos-os-arquivos\"><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\/10\/painel-financeiro.png\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/painel-financeiro.png\" alt=\"Dashboard Financeiro Completo\" 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\/planilhas-dashboard-financeiro-completo\/\"><\/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\/planilhas-dashboard-financeiro-completo\/\">Planilhas | Dashboard Financeiro Completo<\/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\/planilhas-dashboard-financeiro-completo\/\" 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-10004 post type-post status-publish format-standard has-post-thumbnail hentry category-planilhas tag-excel tag-menu-dados-completo tag-pacote-de-graficos tag-saiba-tudo-da-parte-de-dados tag-todos-os-arquivos\"><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\/10\/indicadores-de-rh-1.png\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/indicadores-de-rh-1.png\" alt=\"Indicadores de RH 2.6\" 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\/planilhas-indicadores-de-rh-2-6\/\"><\/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\/planilhas-indicadores-de-rh-2-6\/\">Planilhas | Indicadores de RH 2.6<\/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\/planilhas-indicadores-de-rh-2-6\/\" 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-9992 post type-post status-publish format-standard has-post-thumbnail hentry category-fpw category-tecnologia tag-curso-fpw tag-fpw tag-fpw-nuvem tag-fpw-on-prime tag-lg-nuvem 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\/10\/Transforme-seu-RH-com-agentes-de-IA-dados-e-Tecnologia.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\/10\/Transforme-seu-RH-com-agentes-de-IA-dados-e-Tecnologia.jpg\" alt=\"Transforme seu RH com agentes de IA, dados e Tecnologia\" 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-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\"><\/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-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\">FPw | Transforme seu RH com agentes de IA, dados e Tecnologia<\/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-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\" 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>\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-c60f4b8 elementor-widget elementor-widget-heading\" data-id=\"c60f4b8\" 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\">Gostaria de aprimorar seu conhecimento em Excel,  aproveite nossos Cursos.<\/h2>\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-10904ac 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=\"10904ac\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2ffc5f7 elementor-widget elementor-widget-image\" data-id=\"2ffc5f7\" 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:\/\/maisfy.com.br\/store\/st\/produto\/255edafd-e626-44de-832d-1be9942a5711\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" 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\/2026\/09\/Curso-Excel-Completo.png\" class=\"attachment-large size-large wp-image-9225\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo-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-7e36e83 elementor-widget elementor-widget-image\" data-id=\"7e36e83\" 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:\/\/maisfy.com.br\/store\/st\/produto\/6c607ccd-4032-41cf-a684-24e4155a6e2c\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#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\/2026\/09\/Curso-Dashboard-Toal.png\" class=\"attachment-large size-large wp-image-9224\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-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-956ebb8 elementor-widget elementor-widget-image\" data-id=\"956ebb8\" 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:\/\/maisfy.com.br\/store\/st\/produto\/c606ba66-754d-4046-abba-14865ca84bea\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#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\/2026\/09\/Curso-Fluxo-cde-Caixa.png\" class=\"attachment-large size-large wp-image-9226\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa-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-cb075df elementor-widget elementor-widget-image\" data-id=\"cb075df\" 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:\/\/maisfy.com.br\/store\/st\/produto\/3e5e88be-0c1f-4584-9e87-e79faadf4e16\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" 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-f3abd63 elementor-widget elementor-widget-image\" data-id=\"f3abd63\" 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:\/\/maisfy.com.br\/store\/st\/produto\/93c20c84-4cf9-4b01-bde9-346688b1d1fb\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" 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\/2026\/09\/curso-mestre-do-dashboard.png\" class=\"attachment-large size-large wp-image-9223\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-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-234dbaf elementor-widget elementor-widget-image\" data-id=\"234dbaf\" 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:\/\/maisfy.com.br\/store\/st\/produto\/d64a7982-1d4d-4e14-94cb-36dc13f393c3\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" 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\/2026\/09\/Curso-mini-curso-excel.png\" class=\"attachment-large size-large wp-image-9227\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-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 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-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-6f98b18 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=\"6f98b18\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0b20d95 elementor-widget elementor-widget-text-editor\" data-id=\"0b20d95\" 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<h2 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Tem uma d\u00favida de Excel?<\/span><\/h2><p style=\"text-align: center;\"><span style=\"color: #ffffff;\">Compartilhe sua experi\u00eancia nos coment\u00e1rios. F\u00f3rmulas, fun\u00e7\u00f5es, dashboards e erros do Excel fazem parte do dia a dia de quem trabalha com dados.<\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #ffffff;\">Quem sabe a sua d\u00favida n\u00e3o vira o pr\u00f3ximo conte\u00fado?<\/span><\/p>\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 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\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\">\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='9992' 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>&#8211; EXCEL \u2022 DICAS PR\u00c1TICAS &#8211; 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. All Posts Blog Certificados Dados Dashboard Diversos Excel FPw Membros Not\u00c3\u00adcias Planilhas Produtos SQL Tecnologia WordPress FPw | Onde encontrar cursos de FPw e LG Nuvem? Leia mais Dados | Sua empresa provavelmente n\u00e3o sofre de falta de dados. Leia mais Dashboard | 3 erros que fazem um Dashboard Financeiro parecer profissional \u2014 mas entregar decis\u00f5es ruins Leia mais 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. Gostaria de aprimorar seu conhecimento em Excel, aproveite nossos Cursos. 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. Tem uma d\u00favida de Excel? Compartilhe sua experi\u00eancia nos coment\u00e1rios. F\u00f3rmulas, fun\u00e7\u00f5es, dashboards e erros do Excel fazem parte do dia a dia de quem trabalha com dados. Quem sabe a sua d\u00favida n\u00e3o vira o pr\u00f3ximo conte\u00fado? 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. 2 Comments Bulk Material Transfer25 de setembro de 2026 at 12:24 | Edit Everyone loves what you guys tend to be up too. Such clever work and reporting! Keep up the fantastic works guys I&#8217;ve included you guys to blogroll. Responder Silo Design25 de setembro de 2026 at 05:09 | Edit Hey there, I think your site might be having browser compatibility issues. When I look at your blog site in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, wonderful blog! Responder 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":3,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8500\/revisions"}],"predecessor-version":[{"id":9917,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8500\/revisions\/9917"}],"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}]}}