{"id":5870,"date":"2025-11-11T20:15:26","date_gmt":"2025-11-11T20:15:26","guid":{"rendered":"https:\/\/valueconsultoria.com.br\/site\/?p=5870"},"modified":"2025-12-09T20:16:44","modified_gmt":"2025-12-09T20:16:44","slug":"power-query-excel","status":"publish","type":"post","link":"https:\/\/valueconsultoria.com.br\/site\/power-query-excel\/","title":{"rendered":"Treinamento: Do Power Query ao Dashboard no Excel"},"content":{"rendered":"<p data-start=\"204\" data-end=\"364\">\ud83d\udcd8TREINAMENTO: <strong>DO POWER QUERY AO DASHBOARD NO EXCEL<\/strong> \u2013 24 a 27 de Novembro<\/p>\n<p>Quer transformar dados brutos em informa\u00e7\u00f5es estrat\u00e9gicas e criar dashboards interativos no Excel?<\/p>\n<p>Este curso vai te ensinar a importar, transformar e analisar dados de forma pr\u00e1tica, al\u00e9m de desenvolver relat\u00f3rios visuais e din\u00e2micos para tomadas de decis\u00e3o empresariais.<\/p>\n<p>\ud83d\udccc T\u00f3picos abordados:<\/p>\n<p>\u2714\ufe0f Introdu\u00e7\u00e3o ao Power Query: conceitos e interface<br \/>\n\u2714\ufe0f Importa\u00e7\u00e3o de dados de diferentes fontes (Excel, CSV, Banco de Dados)<br \/>\n\u2714\ufe0f Transforma\u00e7\u00e3o e Limpeza: filtros, renomea\u00e7\u00f5es e exclus\u00f5es<br \/>\n\u2714\ufe0f Combina\u00e7\u00e3o de Consultas: mesclar e anexar tabelas<br \/>\n\u2714\ufe0f Cria\u00e7\u00e3o de Colunas Personalizadas<br \/>\n\u2714\ufe0f Integra\u00e7\u00e3o do Power Query com ferramentas Microsoft 365 (Copilot)<br \/>\n\u2714\ufe0f Relacionamento entre tabelas com Power Pivot<\/p>\n<p>\ud83c\udfaf P\u00fablico-Alvo: Estudantes e profissionais que querem otimizar suas habilidades no Excel e se destacar com an\u00e1lise de dados avan\u00e7ada.<\/p>\n<p>\ud83d\udcc5 Data: 24 a 27 de Novembro<br \/>\n\ud83d\udd57 Hor\u00e1rio: 18h \u00e0s 22h<br \/>\n\ud83d\udccd Modalidade: Presencial<br \/>\n\u23f1\ufe0f Carga hor\u00e1ria: 16 horas (teoria e pr\u00e1tica)<\/p>\n<p>\ud83d\udcf2 Garanta sua vaga com o Grupo Value &#8211; Consultoria em RH!<\/p>\n<p>\ud83d\udcde (92) 98413-9393 | \ud83d\udcde (92) 98445-0474<br \/>\n\ud83d\udcf8\u00a0<a class=\"x1i10hfl xjbqb8w x1ejq31n x18oe1m7 x1sy0etr xstzfhl x972fbf x10w94by x1qhh985 x14e42zd x9f619 x1ypdohk xt0psk2 x3ct3a4 xdj266r x14z9mp xat24cr x1lziwak xexx8yu xyri2b x18d9i69 x1c1uobl x16tdsg8 x1hl2dhg xggy1nq x1a2a7pz notranslate _a6hd\" role=\"link\" href=\"https:\/\/www.instagram.com\/valueconsultoria_oficial\/\">@valueconsultoria_oficial<\/a><br \/>\n.<br \/>\n.<br \/>\n.<br \/>\n\ud83d\udcaaRecrutamento &amp; Sele\u00e7\u00e3o<br \/>\n\ud83d\udcda Treinamento &amp; Desenvolvimento<br \/>\n\ud83d\udc77M\u00e3o de obra Tempor\u00e1ria<br \/>\n\ud83c\udfe2 M\u00e3o de obra Terceirizada<br \/>\n\ud83c\udfaf Constru\u00e7\u00e3o Civil<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur lectus lacus, rutrum sit amet placerat et, bibendum nec mauris. Duis&#8230;<\/p>\n","protected":false},"author":3,"featured_media":5871,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5870","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"featured_image_src":{"landsacpe":["https:\/\/valueconsultoria.com.br\/site\/wp-content\/uploads\/2025\/12\/Dashboard-no-excel-4-1140x445.jpg",1140,445,true],"list":["https:\/\/valueconsultoria.com.br\/site\/wp-content\/uploads\/2025\/12\/Dashboard-no-excel-4-463x348.jpg",463,348,true],"medium":["https:\/\/valueconsultoria.com.br\/site\/wp-content\/uploads\/2025\/12\/Dashboard-no-excel-4-241x300.jpg",241,300,true],"full":["https:\/\/valueconsultoria.com.br\/site\/wp-content\/uploads\/2025\/12\/Dashboard-no-excel-4.jpg",1170,1458,false]},"_links":{"self":[{"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/posts\/5870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/comments?post=5870"}],"version-history":[{"count":1,"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/posts\/5870\/revisions"}],"predecessor-version":[{"id":5872,"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/posts\/5870\/revisions\/5872"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/media\/5871"}],"wp:attachment":[{"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/media?parent=5870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/categories?post=5870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/valueconsultoria.com.br\/site\/wp-json\/wp\/v2\/tags?post=5870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}