<!–NoAds–>

Edit Element Clone Element Advanced Element Options Move Remove Element

CURSO PRESENCIAL DE EXCEL

A Arte de Criar Dashboards no Excel com Gerson Viergutz

Dias 25 e 26 de Março de 2020

[headline style="1" font_font="Lato" font_style="300" font_color="%2394a8ba" align="center" headline_tag="h3" bottom_margin="0"]<h1 class="mbr-section-title mbr-white pt-5 pb-3 mbr-fonts-style display-1 align-right"><span style="color: #ffffff;"><strong>CURSO PRESENCIAL DE EXCEL</strong></span></h1><br />
<h3 class="mbr-section-title mbr-white pt-5 pb-3 mbr-fonts-style display-1 align-right"><span style="color: #ffffff;">A Arte de Criar Dashboards no Excel com Gerson Viergutz</span></h3><br />
<span style="color: #ffffff;">Dias 25 e 26 de Março de 2020</span></p>
<p><!–NoAds–>[/headline]

Edit Element Clone Element Advanced Element Options Move Remove Element

[video_player type="youtube" youtube_auto_play="Y" style="5" dimensions="640×360" width="640" height="360" align="center" margin_top="0" margin_bottom="0" ipad_color="black"]aHR0cHM6Ly93d3cueW91dHViZS5jb20vd2F0Y2g/dj01VnlQVWRwY29IMA==[/video_player]

Edit Element Clone Element Advanced Element Options Move Remove Element

QUERO ME INSCREVER AGORA

[button_1 text="QUERO%20ME%20INSCREVER%20AGORA" text_size="24" text_color="#ffffff" text_font="Gill Sans;default" text_bold="Y" text_letter_spacing="0" subtext_panel="N" text_shadow_panel="Y" text_shadow_vertical="-1" text_shadow_horizontal="0" text_shadow_color="#080808" text_shadow_blur="0" styling_width="40" styling_height="20" styling_border_color="#000000" styling_border_size="1" styling_border_radius="3" styling_border_opacity="100" styling_gradient="Y" styling_gradient_start_color="#d90000" drop_shadow_panel="Y" drop_shadow_vertical="1" drop_shadow_horizontal="0" drop_shadow_blur="1" drop_shadow_spread="0" drop_shadow_color="#000000" drop_shadow_opacity="50" inset_shadow_panel="Y" inset_shadow_vertical="0" inset_shadow_horizontal="0" inset_shadow_blur="0" inset_shadow_spread="1" inset_shadow_color="#ffff00" inset_shadow_opacity="25" align="center" href="https://www.sympla.com.br/a-arte-de-criar-dashboard-no-excel-com-gerson-viergutz__748147"/]

Add Element

<!–NoAds–>

Add New Row

Edit Element Clone Element Advanced Element Options Move Remove Element

CONTEÚDO DO CURSO

[headline style="17" font_size="30" font_font="Lato" align="left" headline_tag="h2"]CONTEÚDO DO CURSO[/headline]

Add Element

Add New Row

Edit Element Clone Element Advanced Element Options Move Remove Element

Introdução

Material de Apoio

O que é Dashboard

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Introdu%C3%A7%C3%A3o" content="PHA+TWF0ZXJpYWwgZGUgQXBvaW88L3A+CjxwPk8gcXVlIMOpIERhc2hib2FyZDwvcD4K"][/course_description]

Edit Element Clone Element Advanced Element Options Move Remove Element

Planejando seu Dashboard

Primeiros passos antes de começar seu dashboard

Checklist para Dashboard

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Planejando%20seu%20Dashboard" content="PHA+UHJpbWVpcm9zIHBhc3NvcyBhbnRlcyBkZSBjb21lw6dhciBzZXUgZGFzaGJvYXJkPC9wPgo8cD5DaGVja2xpc3QgcGFyYSBEYXNoYm9hcmQ8L3A+Cg=="][/course_description]

Edit Element Clone Element Advanced Element Options Move Remove Element

Modelagem de Dados

Organização das Planilhas

Importação de Dados (Power Query)

Tabela de Dados

Análises com Tabela Dinâmica

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Modelagem%20de%20Dados" content="PHA+T3JnYW5pemHDp8OjbyBkYXMgUGxhbmlsaGFzPC9wPgo8cD5JbXBvcnRhw6fDo28gZGUgRGFkb3MgKFBvd2VyIFF1ZXJ5KTwvcD4KPHA+VGFiZWxhIGRlIERhZG9zPC9wPgo8cD5BbsOhbGlzZXMgY29tIFRhYmVsYSBEaW7Dom1pY2E8L3A+Cg=="][/course_description]

Edit Element Clone Element Advanced Element Options Move Remove Element

Visualização de Dados

Quais gráficos não usar

Qual o melhor gráfico para cada tipo de dado

A Importância das cores em Dashboards

O que faz um dashboard ser efetivo

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Visualiza%C3%A7%C3%A3o%20de%20Dados" content="PHA+UXVhaXMgZ3LDoWZpY29zIG7Do28gdXNhcjwvcD4KPHA+UXVhbCBvIG1lbGhvciBncsOhZmljbyBwYXJhIGNhZGEgdGlwbyBkZSBkYWRvPC9wPgo8cD5BIEltcG9ydMOibmNpYSBkYXMgY29yZXMgZW0gRGFzaGJvYXJkczwvcD4KPHA+TyBxdWUgZmF6IHVtIGRhc2hib2FyZCBzZXIgZWZldGl2bzwvcD4K"][/course_description]

Edit Element Clone Element Advanced Element Options Move Remove Element

Seu Primeiro Dahboard – Dashboard de Vendas

Modelagem de Dados (Importação de Dados com Power Query)

Análise e Cálculos para Criação do Dashboard (Tabela Dinâmica)

Criação do Dashboard (Melhores Práticas)

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Seu%20Primeiro%20Dahboard%20-%20Dashboard%20de%20Vendas" content="PHA+TW9kZWxhZ2VtIGRlIERhZG9zIChJbXBvcnRhw6fDo28gZGUgRGFkb3MgY29tIFBvd2VyIFF1ZXJ5KTwvcD4KPHA+QW7DoWxpc2UgZSBDw6FsY3Vsb3MgcGFyYSBDcmlhw6fDo28gZG8gRGFzaGJvYXJkIChUYWJlbGEgRGluw6JtaWNhKTwvcD4KPHA+Q3JpYcOnw6NvIGRvIERhc2hib2FyZCAoTWVsaG9yZXMgUHLDoXRpY2FzKTwvcD4K"][/course_description]

Add Element

Edit Element Clone Element Advanced Element Options Move Remove Element

Formatação (Simultaneamente com o Desenvolvimento do Dashboard)

Formatos Personalizados

Formatação Condicional

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Formata%C3%A7%C3%A3o%20(Simultaneamente%20com%20o%20Desenvolvimento%20do%20Dashboard)" content="PHA+Rm9ybWF0b3MgUGVyc29uYWxpemFkb3M8L3A+CjxwPkZvcm1hdGHDp8OjbyBDb25kaWNpb25hbDwvcD4K"][/course_description]

Edit Element Clone Element Advanced Element Options Move Remove Element

Funções do Excel (Simultaneamente com o Desenvolvimento do Dashboard)

PROCV

DESLOC

ÍNDICE

INFODADOSTABELADINAMICA

ESCOLHER

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Fun%C3%A7%C3%B5es%20do%20Excel%20(Simultaneamente%20com%20o%20Desenvolvimento%20do%20Dashboard)" content="PHA+UFJPQ1Y8L3A+CjxwPkRFU0xPQzwvcD4KPHA+w41ORElDRTwvcD4KPHA+SU5GT0RBRE9TVEFCRUxBRElOQU1JQ0E8L3A+CjxwPkVTQ09MSEVSPC9wPgo8cD4mbmJzcDs8L3A+Cg=="][/course_description]

Edit Element Clone Element Advanced Element Options Move Remove Element

Controles de Formulário (Simultaneamente com o Desenvolvimento do Dashboard)

Habilitando a Guia Desenvolvedor

Botão de Opção

Caixa de Listagem

Caixa de Seleção

[course_description style="1" icon="19.png" icon_folder="feature_block" image="" title="Controles%20de%20Formul%C3%A1rio%20(Simultaneamente%20com%20o%20Desenvolvimento%20do%20Dashboard)" content="PHA+SGFiaWxpdGFuZG8gYSBHdWlhIERlc2Vudm9sdmVkb3I8L3A+CjxwPkJvdMOjbyBkZSBPcMOnw6NvPC9wPgo8cD5DYWl4YSBkZSBMaXN0YWdlbTwvcD4KPHA+Q2FpeGEgZGUgU2VsZcOnw6NvPC9wPgo8cD4mbmJzcDs8L3A+Cg=="][/course_description]

Add Element