{"id":22906,"date":"2026-10-17T22:56:44","date_gmt":"2026-10-17T21:56:44","guid":{"rendered":"https:\/\/trident-academy.com\/courses\/tic-220-analise-de-dados-no-excel-ordenar-filtrar-tabelas-tabelas-dinamicas-e-formatacao-condicional-curso-em-ingles\/"},"modified":"2026-11-03T21:09:13","modified_gmt":"2026-11-03T20:09:13","slug":"tic-220-excel-data-analysis-sort-filter-tables-pivottables-and-conditional-formatting","status":"publish","type":"product","link":"https:\/\/trident-academy.com\/pt\/courses\/tic-220-excel-data-analysis-sort-filter-tables-pivottables-and-conditional-formatting\/","title":{"rendered":"Excel Data Analysis: Sort, Filter, Tables, PivotTables and Conditional Formatting"},"content":{"rendered":"<p>Transformar listas em informa\u00e7\u00e3o. Li\u00e7\u00f5es curtas gravadas no ecr\u00e3 tratam a ordena\u00e7\u00e3o de dados, ordenar por cor, ordens personalizadas, inverter e aleatorizar listas e a fun\u00e7\u00e3o SORT; tr\u00eas unidades completas, cada uma com ficheiros de pr\u00e1tica e question\u00e1rio, tratam filtros e ferramentas de dados, tabelas e tabelas din\u00e2micas, e formata\u00e7\u00e3o condicional. Gravado no Microsoft 365. Baseado nas boas pr\u00e1ticas do Reino Unido. Curso em ingl\u00eas. Acesso permanente ao curso. Certificado Trident Academy ao concluir as nove unidades.<\/p>","protected":false},"excerpt":{"rendered":"<p>Seis li\u00e7\u00f5es curtas (em ingl\u00eas) sobre ordena\u00e7\u00e3o (por cor, ordens personalizadas, inverter, aleatorizar, a fun\u00e7\u00e3o SORT) seguidas de unidades completas sobre filtros e ferramentas de dados, tabelas e tabelas din\u00e2micas, e formata\u00e7\u00e3o condicional.<\/p>","protected":false},"featured_media":23708,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[575,576,385],"product_tag":[],"class_list":["post-22906","product","type-product","status-publish","has-post-thumbnail","product_cat-area-tic-en","product_cat-area-tic-en-n2","product_cat-english","first","instock","virtual","sold-individually","taxable","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/product\/22906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/comments?post=22906"}],"version-history":[{"count":0,"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/product\/22906\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/media\/23708"}],"wp:attachment":[{"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/media?parent=22906"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/product_brand?post=22906"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/product_cat?post=22906"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trident-academy.com\/pt\/wp-json\/wp\/v2\/product_tag?post=22906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}