Worskhop Dia 2 - Minhas Planilhas

Add New Row

Edit Element Clone Element Advanced Element Options Move Remove Element

[button_1 text="DIA%201%20-%20LIVE" text_size="20" text_color="#ffffff" text_font="Helvetica;default" text_bold="Y" text_letter_spacing="0" subtext_panel="Y" subtext="Live%20dia%2002%2F03%2F20%20-%2021%3A00h" subtext_size="14" subtext_color="#ffffff" subtext_letter_spacing="0" text_shadow_panel="N" styling_width="35" styling_height="16" styling_border_color="#000000" styling_border_size="0" styling_border_radius="11" styling_border_opacity="100" styling_gradient_start_color="#53a540" drop_shadow_panel="N" inset_shadow_panel="N" align="center" href="http://minhasplanilhas.com.br/worskhop-dia-1"/]

Add Element

Edit Element Clone Element Advanced Element Options Move Remove Element

DIA 2Liberado dia 04/03 as 08:00h

[button_1 text="DIA%202" text_size="20" text_color="#ffffff" text_font="Helvetica;default" text_bold="Y" text_letter_spacing="0" subtext_panel="Y" subtext="Liberado%20dia%2004%2F03%20as%2008%3A00h" subtext_size="14" subtext_color="#ffffff" subtext_letter_spacing="0" text_shadow_panel="N" styling_width="25" styling_height="16" styling_border_color="#000000" styling_border_size="0" styling_border_radius="11" styling_border_opacity="100" styling_gradient_start_color="#53a540" drop_shadow_panel="N" inset_shadow_panel="N" align="center"/]

Add Element

Edit Element Clone Element Advanced Element Options Move Remove Element

DIA 3Liberado dia 05/03 – 08:00h

[button_1 text="DIA%203" text_size="20" text_color="#ffffff" text_font="Helvetica;default" text_bold="Y" text_letter_spacing="0" subtext_panel="Y" subtext="Liberado%20dia%2005%2F03%20-%2008%3A00h" subtext_size="14" subtext_color="#ffffff" subtext_letter_spacing="0" text_shadow_panel="N" styling_width="25" styling_height="16" styling_border_color="#000000" styling_border_size="0" styling_border_radius="11" styling_border_opacity="100" styling_gradient_start_color="#53a540" drop_shadow_panel="N" inset_shadow_panel="N" align="center"/]

Add Element

Add New Row

Edit Element Clone Element Advanced Element Options Move Remove Element

Importação e Tratamento de Dados (Video 2)

[headline style="1" font_size="35" font_spacing="-1" align="center" headline_tag="h2" bottom_margin="20"]Importação e Tratamento de Dados<span style="color: #ff6600;"> (Video 2)</span>[/headline]

Add Element

Add New Row

Edit Element Clone Element Advanced Element Options Move Remove Element

[video_player type="embed" style="1" dimensions="560×315" width="800" height="450" align="center" margin_top="0" margin_bottom="25" ipad_color="black"]<img src="http://minhasplanilhas.com.br/wp-content/plugins/optimizePressPlugin/lib/images/video_placeholder.png" alt="PGlmcmFtZSBzcmM9Imh0dHBzOi8vcGxheWVyLnZpbWVvLmNvbS92aWRlby8zMzgzODU5MTciIHdpZHRoPSI2NDAiIGhlaWdodD0iMzYwIiBmcmFtZWJvcmRlcj0iMCIgYWxsb3c9ImF1dG9wbGF5OyBmdWxsc2NyZWVuIiBhbGxvd2Z1bGxzY3JlZW49IiI+PC9pZnJhbWU+" width="1" height="1" />[/video_player]

Edit Element Clone Element Advanced Element Options Move Remove Element

[custom_html]

[/custom_html]

[custom_html]<div align="center"><br />
<script src="https://apis.google.com/js/platform.js"></script></p>
<p><div class="g-ytsubscribe" data-channelid="UCNaIAElKPANu-d7ysRpLcUg" data-layout="full" data-count="default"></div><br />
</div>[/custom_html]

Edit Element Clone Element Advanced Element Options Move Remove Element

[divider style="0"]

Edit Element Clone Element Advanced Element Options Move Remove Element

Downloads

Base de Dados do Workshop

Esta Base de dados tem os anos de 2016 e 2017
Base de Dados Compactado

Esta base de dados é completa, igual ao da aula com dados de 2015 a 2017

[file_download style="2"][download title="Base%20de%20Dados%20do%20Workshop" icon="style1-Xls-64×64.png" file="http://bit.ly/base_workshop" package="" level="" new_window="Y"]Esta%20Base%20de%20dados%20tem%20os%20anos%20de%202016%20e%202017[/download][download title="Base%20de%20Dados%20Compactado" icon="style1-Zip-64×64.png" file="https://minhasplanilhas-my.sharepoint.com/:u:/g/personal/contato_minhasplanilhas_com_br/ESb6hHdmk39CllJSFzGBZdMBk-RjvfYT7qCGVUk4v4_FOw?e=pVzbY8" package="" level="" new_window="Y"]Esta%20base%20de%20dados%20%C3%A9%20completa%2C%20igual%20ao%20da%20aula%20com%20dados%20de%202015%20a%202017[/download][/file_download]

Edit Element Clone Element Advanced Element Options Move Remove Element

[divider style="0"]

Edit Element Clone Element Advanced Element Options Move Remove Element

Veja mais sobre Power Query

[headline style="1" font_size="25" font_color="%232a628d" font_spacing="-1" align="center" headline_tag="h2" bottom_margin="20"]Veja mais sobre Power Query[/headline]

Edit Element Clone Element Advanced Element Options Move Remove Element

Como Instalar o Power Query

[hyperlink style="1" href="http%3A%2F%2Fminhasplanilhas.com.br%2Fcomo-instalar-o-power-query-no-excel%2F" new_window="Y" align="center"]Como Instalar o Power Query[/hyperlink]

Edit Element Clone Element Advanced Element Options Move Remove Element

O que é Power Query

[hyperlink style="1" href="http%3A%2F%2Fminhasplanilhas.com.br%2Fo-que-e-power-query%2F" new_window="Y" align="center"]O que é Power Query[/hyperlink]

Add Element

Edit Element Clone Element Advanced Element Options Move Remove Element

O que veremos nesta aula…

Power Query:

Importar de Pasta de Trabalho de Excel

Tratamento de Dados

Excluir Colunas

Dividir Colunas

Mesclar Colunas

Power Pivot:

Modelagem de Dados

Categoria de Dados

Criação da Tabela Calendário

Relacionamento entre Tabelas

Medidas DAX

Tabela Dinâmica:

Criação e Formatação de Tabela Dinâmica

Formatação Condicional

Classificação de Tabela Dinâmica

Top 5

[course_description style="1" icon="1.png" icon_folder="feature_block" image="" title="O%20que%20veremos%20nesta%20aula…" content="PHA+PHN0cm9uZz5Qb3dlciBRdWVyeTo8L3N0cm9uZz48L3A+CjxwPkltcG9ydGFyIGRlIFBhc3RhIGRlIFRyYWJhbGhvIGRlIEV4Y2VsPC9wPgo8cD5UcmF0YW1lbnRvIGRlIERhZG9zPC9wPgo8cD5FeGNsdWlyIENvbHVuYXM8L3A+CjxwPkRpdmlkaXIgQ29sdW5hczwvcD4KPHA+TWVzY2xhciBDb2x1bmFzPC9wPgo8cD4mbmJzcDs8L3A+CjxwPjxzdHJvbmc+UG93ZXIgUGl2b3Q6PC9zdHJvbmc+PC9wPgo8cD5Nb2RlbGFnZW0gZGUgRGFkb3M8L3A+CjxwPkNhdGVnb3JpYSBkZSBEYWRvczwvcD4KPHA+Q3JpYcOnw6NvIGRhIFRhYmVsYSBDYWxlbmTDoXJpbzwvcD4KPHA+UmVsYWNpb25hbWVudG8gZW50cmUgVGFiZWxhczwvcD4KPHA+TWVkaWRhcyBEQVg8L3A+CjxwPiZuYnNwOzwvcD4KPHA+PHN0cm9uZz5UYWJlbGEgRGluw6JtaWNhOjwvc3Ryb25nPjwvcD4KPHA+Q3JpYcOnw6NvIGUgRm9ybWF0YcOnw6NvIGRlIFRhYmVsYSBEaW7Dom1pY2E8L3A+CjxwPkZvcm1hdGHDp8OjbyBDb25kaWNpb25hbDwvcD4KPHA+Q2xhc3NpZmljYcOnw6NvIGRlIFRhYmVsYSBEaW7Dom1pY2E8L3A+CjxwPlRvcCA1PC9wPgo8cD4mbmJzcDs8L3A+Cg=="][/course_description]

Add Element

Add New Row

Edit Element Clone Element Advanced Element Options Move Remove Element

[countdown_timer style="2" end_date="2020/03/08 23:0:00 GMT -3" redirect_url="http://minhasplanilhas.com.br/curso-especialista-em-dashboards-no-excel/" years_text="Anos" years_text_singular="Ano" months_text="Meses" months_text_singular="Mês" days_text="Dias" days_text_singular="Dia" hours_text="Horas" hours_text_singular="Hora" minutes_text="Minutos" minutes_text_singular="Minuto" seconds_text="Segundos" seconds_text_singular="Segundo"][/countdown_timer]

Edit Element Clone Element Advanced Element Options Move Remove Element

Ficarei muito feliz se você deixar seu feedback. Deixe seu comentário abaixo:

[headline style="1" font_size="25" font_color="%232a628d" font_spacing="-1" align="center" headline_tag="h2" bottom_margin="20"]Ficarei muito feliz se você deixar seu feedback. Deixe seu comentário abaixo:[/headline]

Edit Element Clone Element Advanced Element Options Move Remove Element

[fb_comments style=”light” title=”O%20que%20est%C3%A1%20achando%20do%20Workshop%3F” lang=”pt_BR” posts_number=”50″ src_url=”http%3A%2F%2Fminhasplanilhas.com.br” width=”835″ order=”reverse_time”]

[fb_comments style="light" title="O%20que%20est%C3%A1%20achando%20do%20Workshop%3F" lang="pt_BR" posts_number="50" src_url="http%3A%2F%2Fminhasplanilhas.com.br" width="835" order="reverse_time"]

Add Element