Beginner Level
Análise de dados com tabelas e tabelas dinâmicas no Microsoft Excel 2013
39,215Learners already enrolled
3-4 Avg Hours
CPD Accredited
Análise de dados com tabelas e tabelas dinâmicas no Microsoft Excel 2013
Aprenda tudo sobre tabelas e tabelas dinâmicas e como realizar técnicas de análise de dados com este curso online gratuito do Excel.
Este curso on-line gratuito de Análise de Dados no Excel, com o tutor especialista da Simon Sez IT, ensinará sobre os fundamentos da configuração de tabelas e tabelas dinâmicas no Excel. Você aprenderá... Este curso on-line gratuito de Análise de Dados no Excel, com o tutor especialista da Simon Sez IT, ensinará sobre os fundamentos da configuração de tabelas e tabelas dinâmicas no Excel. Você aprenderá como criar e nomear uma tabela, remover linhas duplicadas e inserir linhas e colunas em tabelas. Este curso também discutirá o uso do Scenario Manager, Goal Seek, Solver Tool, quando o uso dessas ferramentas de análise de dados é mais apropriado e muito mais!
COURSE PUBLISHER -
What You Will Learn In This Free Course
- Identify how to create a table, nam...
- Recognize how to insert rows and co...
- Discuss the use of table styles, re...
- Identify the basic principles of a ...
- Identify how to create a table, name a table and remove duplicate rows
- Recognize how to insert rows and columns into tables
- Discuss the use of table styles, reference and selection
- Identify the basic principles of a PivotTable
- Recognize how to create a PivotTable
- Recognize how to filter in PivotTables
- Identify how to perform data analysis using a PivotTable
- Discuss how to use the Scenario Manager
- Outline how to use Goal Seek
- Discuss how to use the Solver tool in Excel
Course Modules
Course Description
Alison Certificates
![]()
Knowledge & Skills You Will Learn
Knowledge & Skills You Will LearnComplete This CPD Accredited Course & Get Your certificate!
![]()
Certify Your Skills
A CPD accredited Alison Diploma/Certificate certifies the skills you’ve learned![]()
Stand Out From The Crowd
Add your Alison Certification to your resumé and stay ahead of the competition![]()
Advance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities
Learner Reviews & Feedback For Análise de dados com tabelas e tabelas dinâmicas no Microsoft Excel 2013
Learners should be able to skip questions while doing assessment
Great course!
Murungi D. ![]()
Alison Graduate
Alison Graduate what a wonderful course, glad im to be part of it
This was so eye opening and nice to study
Michael A. ![]()
Alison Graduate
Alison Graduate I really enjoyed it and it was so practical.
View 8 More Reviews
Back to course information
Want to create a customised learning path for your team?
Our dedicated Learning Advisors are here to help you curate a customised learning path tailored to your organisation's needs and goals.
Not sure where to begin?
Discover the career most suitable for you and get started in the field with a step-by-step plan.
Get your Plan
Learners Who Took This Course Also Enrolled In
- Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
- Mastering Data Analysis Using Microsoft Excel
- Microsoft Excel Formulas and Functions
- Basics of Data Analysis with Excel
- Advanced Excel 2021
- Introduction to Data Analysis
- Learning Lean Six Sigma: White Belt
- MS Excel: Manage and Report with Microsoft Excel (Basic)
