Microsoft Excel 2016 - Nível Básico

Comece a dominar o Excel a partir do nível básico

4.65 (3373 reviews)
Udemy
platform
Português
language
Microsoft
category
Microsoft Excel 2016 - Nível Básico
26,456
students
6 hours
content
Jul 2017
last update
FREE
regular price

What you will learn

Usar a planilha de cálculo como ferramenta para controles, cálculos, análise s e demais trabalhos.

Why take this course?

Meu treinamento de Excel 2016 - nível básico apresenta os principais recursos oferecidos pela planilha de cálculo mais adotada do mercado, para que você utilize-os com eficácia na criação de planilhas eletrônicas, com cálculos, referência a células, utilização de funções, controle da aparência da planilha, uso de sequência, classificação e filtragem de dados, trabalho com gráficos, imagens e minigráficos.

Content

Introdução

Interface
Entenda a diferença entre Pastas de Trabalho, Planilhas e Tabelas
Personalizando a Faixa de Opções

Formatação e Aparência

Personalizando a Aparência de Planilhas
Alinhamento de células
Trabalhando com bordas
Trabalhando com comentários em células
Alterando a fonte
Copiando e colando formatos
Ocultando e reexibindo Linhas de Grade
Ocultando e reexibindo linhas e colunas
Manuseando planilhas simultaneamente
Configurações de Layout de Página
Trabalhando com formatação numérica de dados

Gráficos

Trabalhando com gráficos
Alterando elementos de um gráfico através da Faixa de Opções
Alterando elementos de um gráfico através dos botões contextuais
Trabalhando com imagens e elementos gráficos
Criando Minigráficos (Sparklines)
Personalizando Minigráficos

Fórmulas e Funções

Trabalhando com Fórmulas e Funções
Função SOMA
Funções MÍNIMO e MÁXIMO
Função MEDIA
Função HOJE
Função CONT.VALORES
Função CONT.NUM
Função SE
Função SOMASE
Função CONT.SE

Cálculos e Manipulação de Dados

Introdução à Tabela Dinâmica
Introdução à Gráficos Dinâmicos
Classificação e filtragem de dados
Introdução à Formatação Condicional

Screenshots

Microsoft Excel 2016 - Nível Básico - Screenshot_01Microsoft Excel 2016 - Nível Básico - Screenshot_02Microsoft Excel 2016 - Nível Básico - Screenshot_03Microsoft Excel 2016 - Nível Básico - Screenshot_04

Our review

🌟 **Overall Course Review** 🌟 **Pros:** - *Comprehensive Content:* The course covers a wide range of Excel skills, from the basics to more advanced topics, which is highly appreciated by learners. - *Clear and Effective Teaching:* The instructor is praised for their excellent didactic approach, clear explanations, and the ability to explain concepts in multiple ways. - *Engaging and Simplistic:* The course is noted for its engaging presentation style and breaking down complex topics into simple, understandable segments. - *Great for Beginners:* Many learners found the course particularly beneficial for those with no prior knowledge of Excel or for those looking to refresh their skills. - *Positive Impact:* Learners report that the course has helped them improve their daily work efficiency and has provided a solid foundation in Excel. - *Recommendation Worthiness:* The overwhelming positive feedback indicates that the course is likely worth the investment, with some learners expressing willingness to pay for the content. **Cons:** - *Technical Issues:* A few learners encountered issues such as video errors (e.g., missing a specific lesson) and screen size limitations that affected the learning experience. - *Accessibility Concerns:* Some learners found the font size in videos to be small, making it difficult to follow along without additional zoom functionality. - *Language Preference:* A learner expressed a desire for the course content to be available in Spanish, indicating potential for language barriers. - *Potential Redundancy:* One learner pointed out that similar content can be found for free on YouTube, suggesting that supplementary materials like downloadable templates and exercises could enhance the learning experience. - *Pricing & Value:* A few learners deducted points for perceived enrolment costs and a desire for more concise explanations or faster pacing during certain parts of the course. **Additional Notes:** - It's worth noting that the course has inspired some learners to explore further, mentioning other resources like #Treinamento e Ninja do Excel. - The feedback indicates a general satisfaction with the course's educational value and a positive outlook on its effectiveness in teaching Excel skills. **Conclusion:** The Excel course, based on the feedback provided, is generally highly regarded for its comprehensive content, clear instruction, and impactful learning outcomes. While there are some technical and accessibility issues to address, as well as considerations regarding content availability and cost, the overall sentiment suggests that this course is an valuable educational resource for those looking to improve their Excel proficiency.

Charts

Price

Microsoft Excel 2016 - Nível Básico - Price chart

Rating

Microsoft Excel 2016 - Nível Básico - Ratings chart

Enrollment distribution

Microsoft Excel 2016 - Nível Básico - Distribution chart

Related Topics

1208060
udemy ID
5/8/2017
course created date
6/11/2019
course indexed date
Bot
course submited by