{"id":8147,"date":"2026-02-07T18:28:22","date_gmt":"2026-02-07T18:28:22","guid":{"rendered":"https:\/\/www.fpw.com.br\/?p=8147"},"modified":"2026-02-07T18:34:33","modified_gmt":"2026-02-07T18:34:33","slug":"certificados-curso-power-query-no-excel","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/certificados-curso-power-query-no-excel\/","title":{"rendered":"Certificados | Curso Power Query no Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8147\" class=\"elementor elementor-8147\" 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\">Certificado Curso de Power Query<\/h2>\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 fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"735\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p1-1024x735.jpg\" class=\"attachment-large size-large wp-image-8148\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p1-1024x735.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p1-300x215.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p1-768x551.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p1-370x265.jpg 370w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p1-600x430.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p1.jpg 1132w\" 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 class=\"elementor-element elementor-element-106bab2 elementor-widget elementor-widget-image\" data-id=\"106bab2\" 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 decoding=\"async\" width=\"1024\" height=\"735\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p2-1024x735.jpg\" class=\"attachment-large size-large wp-image-8149\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p2-1024x735.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p2-300x215.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p2-768x551.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p2-370x265.jpg 370w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p2-600x430.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/certificado-p2.jpg 1132w\" 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 class=\"elementor-element elementor-element-89d3d5a elementor-widget elementor-widget-text-editor\" data-id=\"89d3d5a\" 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 data-start=\"187\" data-end=\"266\">\ud83d\udcd8 O que \u00e9 ensinado no curso <strong data-start=\"219\" data-end=\"266\">Power Query no Excel D1 \u2013 Doutores do Excel<\/strong><\/h2><p data-start=\"268\" data-end=\"551\">O curso <strong data-start=\"276\" data-end=\"303\">Power Query no Excel D1<\/strong>, da <strong data-start=\"308\" data-end=\"329\">Doutores do Excel<\/strong>, \u00e9 focado em ensinar o uso pr\u00e1tico do Power Query para <strong data-start=\"385\" data-end=\"456\">importa\u00e7\u00e3o, tratamento, transforma\u00e7\u00e3o e automa\u00e7\u00e3o de dados no Excel<\/strong>. Ele \u00e9 ideal para quem lida com grandes volumes de informa\u00e7\u00f5es e quer reduzir trabalho manual.<\/p><p data-start=\"553\" data-end=\"588\">Ao longo do curso, o aluno aprende:<\/p><h3 data-start=\"590\" data-end=\"623\">\ud83d\udd39 Fundamentos do Power Query<\/h3><ul data-start=\"624\" data-end=\"797\"><li data-start=\"624\" data-end=\"670\"><p data-start=\"626\" data-end=\"670\">O que \u00e9 o Power Query e para que ele serve<\/p><\/li><li data-start=\"671\" data-end=\"731\"><p data-start=\"673\" data-end=\"731\">Interface da ferramenta e conceitos b\u00e1sicos de consultas<\/p><\/li><li data-start=\"732\" data-end=\"797\"><p data-start=\"734\" data-end=\"797\">Diferen\u00e7a entre importar dados e tratar dados automaticamente<\/p><\/li><\/ul><h3 data-start=\"799\" data-end=\"825\">\ud83d\udd39 Importa\u00e7\u00e3o de Dados<\/h3><ul data-start=\"826\" data-end=\"975\"><li data-start=\"826\" data-end=\"932\"><p data-start=\"828\" data-end=\"846\">Importar dados de:<\/p><ul data-start=\"849\" data-end=\"932\"><li data-start=\"849\" data-end=\"890\"><p data-start=\"851\" data-end=\"890\">Tabelas e intervalos do pr\u00f3prio Excel<\/p><\/li><li data-start=\"893\" data-end=\"932\"><p data-start=\"895\" data-end=\"932\">Arquivos externos (Excel, CSV, TXT)<\/p><\/li><\/ul><\/li><li data-start=\"933\" data-end=\"975\"><p data-start=\"935\" data-end=\"975\">Atualiza\u00e7\u00e3o autom\u00e1tica das informa\u00e7\u00f5es<\/p><\/li><\/ul><h3 data-start=\"977\" data-end=\"1019\">\ud83d\udd39 Tratamento e Transforma\u00e7\u00e3o de Dados<\/h3><ul data-start=\"1020\" data-end=\"1209\"><li data-start=\"1020\" data-end=\"1089\"><p data-start=\"1022\" data-end=\"1089\">Limpeza de dados (remover erros, linhas e colunas desnecess\u00e1rias)<\/p><\/li><li data-start=\"1090\" data-end=\"1121\"><p data-start=\"1092\" data-end=\"1121\">Altera\u00e7\u00e3o de tipos de dados<\/p><\/li><li data-start=\"1122\" data-end=\"1159\"><p data-start=\"1124\" data-end=\"1159\">Cria\u00e7\u00e3o de colunas personalizadas<\/p><\/li><li data-start=\"1160\" data-end=\"1209\"><p data-start=\"1162\" data-end=\"1209\">Divis\u00e3o, jun\u00e7\u00e3o e padroniza\u00e7\u00e3o de informa\u00e7\u00f5es<\/p><\/li><\/ul><h3 data-start=\"1211\" data-end=\"1239\">\ud83d\udd39 Combina\u00e7\u00e3o de Tabelas<\/h3><ul data-start=\"1240\" data-end=\"1370\"><li data-start=\"1240\" data-end=\"1284\"><p data-start=\"1242\" data-end=\"1284\">Mesclar consultas (JOINs no Power Query)<\/p><\/li><li data-start=\"1285\" data-end=\"1318\"><p data-start=\"1287\" data-end=\"1318\">Acrescentar consultas (UNION)<\/p><\/li><li data-start=\"1319\" data-end=\"1370\"><p data-start=\"1321\" data-end=\"1370\">Consolidar dados de m\u00faltiplos arquivos e pastas<\/p><\/li><\/ul><h3 data-start=\"1372\" data-end=\"1408\">\ud83d\udd39 Automatiza\u00e7\u00e3o e Boas Pr\u00e1ticas<\/h3><ul data-start=\"1409\" data-end=\"1571\"><li data-start=\"1409\" data-end=\"1450\"><p data-start=\"1411\" data-end=\"1450\">Uso de caminhos din\u00e2micos de arquivos<\/p><\/li><li data-start=\"1451\" data-end=\"1490\"><p data-start=\"1453\" data-end=\"1490\">Atualiza\u00e7\u00e3o de dados sem retrabalho<\/p><\/li><li data-start=\"1491\" data-end=\"1527\"><p data-start=\"1493\" data-end=\"1527\">Manuten\u00e7\u00e3o de hist\u00f3rico de dados<\/p><\/li><li data-start=\"1528\" data-end=\"1571\"><p data-start=\"1530\" data-end=\"1571\">Aplica\u00e7\u00e3o pr\u00e1tica para relat\u00f3rios reais<\/p><\/li><\/ul><h3 data-start=\"1573\" data-end=\"1602\">\ud83c\udfaf Resultado para o aluno<\/h3><p data-start=\"1603\" data-end=\"1775\">Ao final do curso, o aluno \u00e9 capaz de <strong data-start=\"1641\" data-end=\"1678\">automatizar processos repetitivos<\/strong>, tratar dados de forma profissional e criar bases s\u00f3lidas para relat\u00f3rios e dashboards no Excel.<\/p><hr data-start=\"1777\" data-end=\"1780\" \/><h2 data-start=\"1782\" data-end=\"1821\">\ud83d\udcbc <strong data-start=\"1788\" data-end=\"1821\">Vers\u00e3o Adaptada para LinkedIn<\/strong><\/h2><p data-start=\"1823\" data-end=\"2047\">Voc\u00ea ainda trata dados manualmente no Excel? \ud83e\udd2f<br data-start=\"1870\" data-end=\"1873\" \/>O <strong data-start=\"1875\" data-end=\"1890\">Power Query<\/strong> \u00e9 uma das ferramentas mais poderosas do Excel para <strong data-start=\"1942\" data-end=\"1995\">importar, limpar, transformar e automatizar dados<\/strong> \u2014 e muita gente ainda n\u00e3o usa todo o seu potencial.<\/p><p data-start=\"2049\" data-end=\"2330\">No curso <strong data-start=\"2058\" data-end=\"2085\">Power Query no Excel D1<\/strong>, da <strong data-start=\"2090\" data-end=\"2111\">Doutores do Excel<\/strong>, voc\u00ea aprende desde os fundamentos at\u00e9 aplica\u00e7\u00f5es pr\u00e1ticas, como:<br \/>\u2714\ufe0f Importar dados de v\u00e1rias fontes<br data-start=\"2212\" data-end=\"2215\" \/>\u2714\ufe0f Tratar e padronizar informa\u00e7\u00f5es<br data-start=\"2249\" data-end=\"2252\" \/>\u2714\ufe0f Combinar tabelas automaticamente<br data-start=\"2287\" data-end=\"2290\" \/>\u2714\ufe0f Atualizar relat\u00f3rios sem retrabalho<\/p><p data-start=\"2332\" data-end=\"2430\">\u00c9 o caminho ideal para quem quer ganhar produtividade e trabalhar com dados de forma profissional.<\/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<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-0496a0b elementor-widget elementor-widget-html\" data-id=\"0496a0b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-9545756132587918\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- Post Quadrado 2 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-9545756132587918\"\r\n     data-ad-slot=\"1542008967\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa85d6f wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"fa85d6f\" 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-f61c64e wpr-pricing-table-animation-none wpr-pricing-table-heading-center elementor-widget elementor-widget-wpr-pricing-table\" data-id=\"f61c64e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-pricing-table.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n\t<div class=\"wpr-pricing-table\">\n\t\t\n\t\t\t<div class=\"elementor-repeater-item-d174595 wpr-pricing-table-item wpr-pricing-table-heading wpr-pricing-table-item-first\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\t<div class=\"wpr-pricing-table-headding-inner\">\n\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"wpr-pricing-table-icon\">\n\t\t\t\t\t\t\t<i class=\"far fa-gem\"><\/i>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"wpr-pricing-table-title-wrap\">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<h3 class=\"wpr-pricing-table-title\">Cursos<\/h3>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<span class=\"wpr-pricing-table-sub-title\">Promo\u00e7\u00e3o<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\t\t\n\t\t\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t\t<div class=\"elementor-repeater-item-d49d49e wpr-pricing-table-item wpr-pricing-table-price\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\t<div class=\"wpr-pricing-table-price-inner\">\n\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-currency\">R$<\/span>\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-pricing-table-main-price\">500<\/span>\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-pricing-table-sub-price\">00<\/span>\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\n\t\t\t\t\t<div class=\"wpr-pricing-table-preiod\">\/Ano<\/div>\n\t\t\t\t\t\t\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t\t<section class=\"elementor-repeater-item-76eab2a wpr-pricing-table-item wpr-pricing-table-feature\">\n\t\t\t\t<div class=\"wpr-pricing-table-feature-inner\">\n\t\t\t\t\t\t\t\t\t\t\t<i class=\"wpr-pricing-table-feature-icon fas fa-check\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-feature-text wpr-pricing-table-ftext-line-\">\n\t\t\t\t\t\t<span>\n\t\t\t\t\t\tExcel para todos\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/section>\n\n\t\t\t\n\t\t\t<section class=\"elementor-repeater-item-79373a6 wpr-pricing-table-item wpr-pricing-table-feature\">\n\t\t\t\t<div class=\"wpr-pricing-table-feature-inner\">\n\t\t\t\t\t\t\t\t\t\t\t<i class=\"wpr-pricing-table-feature-icon fas fa-check\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-feature-text wpr-pricing-table-ftext-line-\">\n\t\t\t\t\t\t<span>\n\t\t\t\t\t\tSQL do B\u00e1sico ao Avan\u00e7ado\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/section>\n\n\t\t\t\n\t\t\t<section class=\"elementor-repeater-item-f655bbf wpr-pricing-table-item wpr-pricing-table-feature\">\n\t\t\t\t<div class=\"wpr-pricing-table-feature-inner\">\n\t\t\t\t\t\t\t\t\t\t\t<i class=\"wpr-pricing-table-feature-icon fas fa-check\"><\/i>\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t<span class=\"wpr-pricing-table-feature-text wpr-pricing-table-ftext-line-\">\n\t\t\t\t\t\t<span>\n\t\t\t\t\t\tFPw INtermedi\u00e1rio\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/section>\n\n\t\t\t\n\t\t\t<div class=\"elementor-repeater-item-702a29f wpr-pricing-table-item wpr-pricing-table-button\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\t<a class=\"wpr-pricing-table-btn wpr-button-effect wpr-button-none\" href=\"https:\/\/fpw.com.br\/ead\/todos-os-cursos\/\" target=\"_blank\" rel=\"noopener noreferrer\">\n\t\t\t\t\t<span>\n\n\t\t\t\t\t\t\n\t\t\t\t\t\tAcessar\n\t\t\t\t\t\t\n\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t\t<div class=\"elementor-repeater-item-d45bc4a wpr-pricing-table-item wpr-pricing-table-text wpr-pricing-table-item-last\">\t\t\n\t\t\t\n\t\t\t\n\t\t\t\tuseo Cupom VALE50 e tenha 50% de desconto!\n\t\t\t\n\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"wpr-pricing-table-badge wpr-pricing-table-badge-corner wpr-pricing-table-badge-right\">\t\n\t\t\t\t<div class=\"wpr-pricing-table-badge-inner\">Sale<\/div>\t\n\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c171d27 wpr-author-box-arrange-vertical elementor-widget elementor-widget-wpr-author-box\" data-id=\"c171d27\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-author-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"wpr-author-box\"><div class=\"wpr-author-box-image\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/secure.gravatar.com\/avatar\/4d29370c4e3a80d286809ea97855951799d2f2ef82aa2bee944ce60205ad92b5?s=264&amp;d=mm&amp;r=g\" class=\"avatar avatar-264 photo\" height=\"264\" width=\"264\" \/><\/div><div class=\"wpr-author-box-text\"><h3 class=\"wpr-author-box-name\">Marco Chinarelli<\/h3><h3 class=\"wpr-author-box-title\">Writer &amp; Blogger<\/h3><\/div><\/div>\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\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Certificado Curso de Power Query \ud83d\udcd8 O que \u00e9 ensinado no curso Power Query no Excel D1 \u2013 Doutores do Excel O curso Power Query no Excel D1, da Doutores do Excel, \u00e9 focado em ensinar o uso pr\u00e1tico do Power Query para importa\u00e7\u00e3o, tratamento, transforma\u00e7\u00e3o e automa\u00e7\u00e3o de dados no Excel. Ele \u00e9 ideal para quem lida com grandes volumes de informa\u00e7\u00f5es e quer reduzir trabalho manual. Ao longo do curso, o aluno aprende: \ud83d\udd39 Fundamentos do Power Query O que \u00e9 o Power Query e para que ele serve Interface da ferramenta e conceitos b\u00e1sicos de consultas Diferen\u00e7a entre importar dados e tratar dados automaticamente \ud83d\udd39 Importa\u00e7\u00e3o de Dados Importar dados de: Tabelas e intervalos do pr\u00f3prio Excel Arquivos externos (Excel, CSV, TXT) Atualiza\u00e7\u00e3o autom\u00e1tica das informa\u00e7\u00f5es \ud83d\udd39 Tratamento e Transforma\u00e7\u00e3o de Dados Limpeza de dados (remover erros, linhas e colunas desnecess\u00e1rias) Altera\u00e7\u00e3o de tipos de dados Cria\u00e7\u00e3o de colunas personalizadas Divis\u00e3o, jun\u00e7\u00e3o e padroniza\u00e7\u00e3o de informa\u00e7\u00f5es \ud83d\udd39 Combina\u00e7\u00e3o de Tabelas Mesclar consultas (JOINs no Power Query) Acrescentar consultas (UNION) Consolidar dados de m\u00faltiplos arquivos e pastas \ud83d\udd39 Automatiza\u00e7\u00e3o e Boas Pr\u00e1ticas Uso de caminhos din\u00e2micos de arquivos Atualiza\u00e7\u00e3o de dados sem retrabalho Manuten\u00e7\u00e3o de hist\u00f3rico de dados Aplica\u00e7\u00e3o pr\u00e1tica para relat\u00f3rios reais \ud83c\udfaf Resultado para o aluno Ao final do curso, o aluno \u00e9 capaz de automatizar processos repetitivos, tratar dados de forma profissional e criar bases s\u00f3lidas para relat\u00f3rios e dashboards no Excel. \ud83d\udcbc Vers\u00e3o Adaptada para LinkedIn Voc\u00ea ainda trata dados manualmente no Excel? \ud83e\udd2fO Power Query \u00e9 uma das ferramentas mais poderosas do Excel para importar, limpar, transformar e automatizar dados \u2014 e muita gente ainda n\u00e3o usa todo o seu potencial. No curso Power Query no Excel D1, da Doutores do Excel, voc\u00ea aprende desde os fundamentos at\u00e9 aplica\u00e7\u00f5es pr\u00e1ticas, como:\u2714\ufe0f Importar dados de v\u00e1rias fontes\u2714\ufe0f Tratar e padronizar informa\u00e7\u00f5es\u2714\ufe0f Combinar tabelas automaticamente\u2714\ufe0f Atualizar relat\u00f3rios sem retrabalho \u00c9 o caminho ideal para quem quer ganhar produtividade e trabalhar com dados de forma profissional. All Posts Blog Certificados Diversos Excel FPw Membros Not\u00edcias Planilhas Produtos SQL Tecnologia WordPress Certificados | Curso Power Query no Excel Leia mais Excel | Como alterar a cor de uma Segmenta\u00e7\u00e3o de Dados no Excel Leia mais Certificados | SQL Consultas e Conex\u00f5es com Power Query e BY Leia mais Cursos Promo\u00e7\u00e3o R$ 500 00 \/Ano Excel para todos SQL do B\u00e1sico ao Avan\u00e7ado FPw INtermedi\u00e1rio Acessar useo Cupom VALE50 e tenha 50% de desconto! Sale Marco Chinarelli Writer &amp; Blogger<\/p>\n","protected":false},"author":2000,"featured_media":8150,"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":[105],"tags":[],"class_list":["post-8147","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-certificados"],"jetpack_sharing_enabled":true,"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/02\/doutores.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8147","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=8147"}],"version-history":[{"count":0,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8147\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/8150"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=8147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=8147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=8147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}