Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Pivot Tables

ANÁLISE DE DADOS COM TABELA DINÂMICA - DO ZERO AO MASTER

Domine essa fantástica ferramenta do Excel e se destaque.
Highest Rated
Rating: 4.6 out of 54.6 (441 ratings)
1,693 students
Created by CRISTIAN FIRMINO
Last updated 7/2018
Portuguese
Portuguese [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Desenvolver análises mais rápidas e eficientes
  • Desenvolver Dashboards
  • Ser capaz de criar tabelas dinâmicas de diferentes formas

Requirements

  • Excel Instalado (de preferência para Windows)
  • Conhecimento Básico de Computador

Description

A tabela Dinâmica é um dos melhores recursos do Excel sem dúvidas, mas poucos sabem utiliza-lá no seu extremo. Neste curso irei ensinar desde os conceitos mais básicos até técnicas avançadas para que você se transforme em um mito nas tabelas dinâmicas. Após esse curso você irá melhorar significativamente as suas análises no Excel.

Who this course is for:

  • Todos que desejam dominar as tabelas dinâmicas.

Course content

7 sections • 37 lectures • 3h 56m total length

  • Preview09:22

  • Preview08:15
  • Tratando a nossa fonte de dados
    07:32
  • Utilizando tabelas para criar a dinâmica
    06:27
  • Preview04:39
  • Formatação de Números
    04:30

  • Checando os rótulos das colunas e agrupando por Data
    07:54
  • Um pouco mais sobre agrupamento de datas
    09:38
  • Agrupamento de Campos Numéricos
    04:26
  • Preview05:26
  • Tabelas dinâmicas sobrepostas
    04:50
  • Criando duas tabelas diferentes da mesma base
    07:16

  • Formatando como tabela normal
    05:33
  • Subtotais, espaço tabela dinamica e zebrados
    03:35
  • Personalizando a formatação
    05:02
  • Auto-ajustar tabela e preservar a formatação
    05:36
  • Formatação condicional na dinâmica
    06:48
  • Tabela dinâmica versão .xls
    04:14
  • Mesclar na tabela dinâmica
    06:04

  • Utilizando o infodadostabeladinamica
    05:28
  • Percentual de variação entre os elementos
    04:57
  • Percentual em relação a uma referencia
    02:09
  • Fazendo pareto com tabela dinâmica
    02:49
  • Percentual em relação ao total
    06:01
  • Ranking utilizando a dinâmica
    01:51
  • Numero índice
    08:46

  • Detalhando valores da tabela
    02:39
  • Campos calculados
    08:10
  • Item calculado
    09:01
  • Arquivos externos parte 1
    06:10
  • Arquivos externos parte 2
    11:05
  • Atualizando Dinâmica Automaticamente via VBA
    04:47
  • Modelo de Dados
    09:35
  • Calculando Campos no Modelo de Dados
    02:25

  • Adicionando Segmentação de Dados
    05:57
  • Gráficos
    05:56
  • Dashboard
    21:18

Instructor

CRISTIAN FIRMINO
Apaixonado por Análise de Dados
CRISTIAN FIRMINO
  • 4.6 Instructor Rating
  • 441 Reviews
  • 1,693 Students
  • 1 Course

Formado em Economia, porém mudei a minha rota no meio do caminho. Com mais de 8 anos de experiência com análise de dados com Excel, VBA, Qlikview, R e Javascript. Faço do meu dia-a-dia aprendizado e ensino contínuo. Acredito fortemente que a educação transforma e promove riqueza nos povos. Por isso estudo massivamente vários assuntos e assim que posso, compartilho o máximo do que sei. Já ensinei muitas pessoas direta e indiretamente e isso sempre me traz felicidade.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.