{"id":12983,"date":"2024-11-04T09:56:24","date_gmt":"2024-11-04T12:56:24","guid":{"rendered":"https:\/\/goias.gov.br\/escoladegoverno\/?p=12983"},"modified":"2025-04-22T10:25:35","modified_gmt":"2025-04-22T13:25:35","slug":"excel-avancado-2","status":"publish","type":"post","link":"https:\/\/goias.gov.br\/escoladegoverno\/excel-avancado-2\/","title":{"rendered":"Excel &#8211; Avan\u00e7ado"},"content":{"rendered":"\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:25%\">\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-8057eaf3 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/sgc.escoladegoverno.go.gov.br\/\" style=\"background-color:#ec9c00\" target=\"_blank\" rel=\"noreferrer noopener\">Inscreva-se<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:25%\"><div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"213\" height=\"41\" src=\"https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2020\/07\/ead-assincrono-2.png\" alt=\"\" class=\"wp-image-9457\" style=\"object-fit:cover\"\/><\/figure>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-medium\"><img decoding=\"async\" width=\"300\" height=\"41\" src=\"https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-300x41.png\" alt=\"\" class=\"wp-image-12876\" srcset=\"https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-300x41.png 300w, https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-1024x140.png 1024w, https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-768x105.png 768w, https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1.png 1254w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center has-black-color has-text-color has-link-color wp-elements-b771095c89635cd46cdf19b995819baa is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:20%\">\n<p><\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100 is-style-fill\"><a class=\"wp-block-button__link has-text-color has-background has-link-color has-text-align-center wp-element-button\" style=\"border-radius:0px;color:#00296b;background-color:#f9f9f9\"><mark style=\"background-color:rgba(0, 0, 0, 0);color:#00296b\" class=\"has-inline-color\"><strong>\u2714<\/strong><\/mark> Este curso faz parte da Trilha Analista de Dados<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n<h4><strong>Modalidade<\/strong><\/h4>\n<p>EaD Ass\u00edncrono \u2013 conte\u00fados gravados e material para leitura, sem aulas ao vivo e sem intera\u00e7\u00e3o com o professor no f\u00f3rum.<\/p>\n<h4><strong>Carga Hor\u00e1ria<\/strong><\/h4>\n<p>20 horas.<\/p>\n<h4><strong>Objetivo<\/strong><\/h4>\n<p>Apresentar informa\u00e7\u00f5es espec\u00edficas para a opera\u00e7\u00e3o do Microsoft Excel como conhecer e utilizar os recursos avan\u00e7ados de cria\u00e7\u00e3o de planilhas,\u00a0formata\u00e7\u00e3o condicional,\u00a0gerenciar nomes,\u00a0validar dados,\u00a0utilizar diversas fun\u00e7\u00f5es para manipula\u00e7\u00e3o de dados,\u00a0realizar auditoria em c\u00e9lulas,\u00a0tabela din\u00e2mica e gr\u00e1fico din\u00e2mico, dashboard e macro.<\/p>\n<h4><strong>Pr\u00e9-requisito<\/strong><\/h4>\n<p>Ser concluinte do curso de Inform\u00e1tica B\u00e1sica ou ser\u00a0aprovado no Teste de Nivelamento\u00a0Pr\u00e9-requisito para o curso de Excel &#8211; B\u00e1sico\u00a0dispon\u00edvel no Ambiente Virtual de Aprendizadem &#8211; AVA. Acesse o AVA pelo link <a href=\"https:\/\/ead.escoladegoverno.go.gov.br\" target=\"_blank\" rel=\"noopener\" data-cke-saved-href=\"https:\/\/ead.escoladegoverno.go.gov.br\">ead.escoladegoverno.go.gov.br<\/a>, selecione a imagem do curso &#8220;Teste de Nivelamento\u00a0Pr\u00e9-requisito para o curso de Excel &#8211; B\u00e1sico&#8221; e clique em Inscreva-me. Siga as orienta\u00e7\u00f5es dispon\u00edveis no AVA e responda o question\u00e1rio antes de solicitar a inscri\u00e7\u00e3o\u00a0no curso pelo Novo Portal do Aluno.<\/p>\n<h4><strong>P\u00fablico-Alvo<\/strong><\/h4>\n<p>Servidores P\u00fablicos do Poder Executivo Estadual que utilizam a planilha eletr\u00f4nica do Excel como ferramenta de trabalho, ou que trabalhem com a manipula\u00e7\u00e3o de dados, planilhas e tabelas.<\/p>\n<h4><strong>Conte\u00fado Program\u00e1tico<\/strong><\/h4>\n<ul>\n<li>Revis\u00e3o de Conceitos B\u00e1sicos do Excel;<\/li>\n<li>Nomes e Formata\u00e7\u00e3o Condicional;<\/li>\n<li>Organizando Dados;<\/li>\n<li>Fun\u00e7\u00f5es Avan\u00e7adas;<\/li>\n<li>Tabela din\u00e2mica e Dashboard;<\/li>\n<li>Cen\u00e1rios e Seguran\u00e7a de Planilhas;<\/li>\n<li>Valida\u00e7\u00e3o e Auditoria em C\u00e9lulas;<\/li>\n<li>Fun\u00e7\u00e3o Macro.<\/li>\n<\/ul>\n<h4><strong>Crit\u00e9rios de Aprova\u00e7\u00e3o<\/strong><\/h4>\n<p>Aproveitamento igual ou superior a 70% (setenta por cento) na atividade avaliativa do curso.<\/p>","protected":false},"excerpt":{"rendered":"<p>(EaD Ass\u00edncrono) \u2013 Capacitar o servidor a usar recursos avan\u00e7ados do Excel, como tabela din\u00e2mica, manipula\u00e7\u00e3o de dados, fun\u00e7\u00f5es avan\u00e7adas e auditoria em c\u00e9lulas.<\/p>\n","protected":false},"author":179,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,102],"tags":[118],"class_list":["post-12983","post","type-post","status-publish","format-standard","hentry","category-cursos-ead","category-area-analista-dados","tag-sempre-abertas"],"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"ilaneluz","author_link":"https:\/\/goias.gov.br\/escoladegoverno\/author\/ilaneluz\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/goias.gov.br\/escoladegoverno\/categoria\/capacitacao\/modalidade\/cursos-ead\/\" rel=\"category tag\">Cursos EaD<\/a> <a href=\"https:\/\/goias.gov.br\/escoladegoverno\/categoria\/capacitacao\/areas-cursos\/area-analista-dados\/\" rel=\"category tag\">Trilha Analista de Dados<\/a>","rttpg_excerpt":"(EaD Ass\u00edncrono) \u2013 Capacitar o servidor a usar recursos avan\u00e7ados do Excel, como tabela din\u00e2mica, manipula\u00e7\u00e3o de dados, fun\u00e7\u00f5es avan\u00e7adas e auditoria em c\u00e9lulas.","_links":{"self":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts\/12983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/users\/179"}],"replies":[{"embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/comments?post=12983"}],"version-history":[{"count":2,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts\/12983\/revisions"}],"predecessor-version":[{"id":14283,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts\/12983\/revisions\/14283"}],"wp:attachment":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/media?parent=12983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/categories?post=12983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/tags?post=12983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}