As data becomes the modern currency, so the ability to analyse the data quickly and accurately has become of paramount importance. Excel with its extraordinarily broad range of features and capabilities is one of the most widely used programs for doing this. In the first course of our Excel Skills for Data Analysis and Visualization Specialization, you will learn the fundamentals of Excel for data analysis. When you have completed the course, you will be able to use a range of Excel tools and functions to clean and prepare data for analysis; automate data analysis with the help of Named Ranges and Tables; and use logical and lookup functions to transform, link and categorise data.
Este curso faz parte do Programa de cursos integrados Excel Skills for Data Analytics and Visualization
Informações sobre o curso
Sua empresa se beneficiaria do treinamento dos funcionários em habilidades sob demanda?
Experimente o Coursera for BusinessO que você vai aprender
Use Excel tools and functions to clean and prepare data for analysis.
Use Named Ranges and Tables to automate your analysis.
Understand the different types of data in Excel and use appropriate functions to work with them.
Use logical and lookup functions to transform, link and categorise data.
Habilidades que você terá
- Data Analysis
- Microsoft Excel
- Data Cleansing
Sua empresa se beneficiaria do treinamento dos funcionários em habilidades sob demanda?
Experimente o Coursera for Businessoferecido por
Comece a trabalhar rumo ao seu mestrado
Os Certificados MasterTrack fazem parte dos programas de Mestrado divididos em módulos on-line, para que você possa obter uma credencial profissional emitida por uma universidade de alta qualidade a um preço especial, em um formato flexível e interativo. Se você se inscrever no programa, seu curso contará para seu Certificado MasterTrack.
Programa - O que você aprenderá com este curso
Welcome and critical information
Cleaning and manipulating text
Working with numbers and dates
Defined Names for working more effectively with data
Tables for automating data manipulation
Avaliações
- 5 stars81,90%
- 4 stars15,83%
- 3 stars1,51%
- 2 stars0,23%
- 1 star0,50%
Principais avaliações do EXCEL FUNDAMENTALS FOR DATA ANALYSIS
Thank you for this course! It was a lot of fun and easy to follow. I loved the assignements when not only that weeks knowledge was tested but also something randomly from previous weeks.
NICE EXPERIENCE AND LEARNT MANY USEFUL THINGS WHICH IS IS REQUIRED IN DAILY OFFICE USE
THANKS TO ALL TEAM MEMBERS AND MY ORGANISATION -RIL WHO PROVIDE ME THIS COURSERA COURSE
THANKS
Short and thorough course on sorting out data which also helps you to understand how to combine Tables and Named Ranges as well as using a combination of nested intermediate level formulas.
I thank the lecturers, Dr. Prashan and Professor Nikki. I learned the basics in an excellent and strong manner. Indeed, a strong foundation that encouraged me to complete the specialization.
Sobre Programa de cursos integrados Excel Skills for Data Analytics and Visualization

Perguntas Frequentes – FAQ
Quando terei acesso às palestras e às tarefas?
O que recebo ao me inscrever nesta Especialização?
Existe algum auxílio financeiro disponível?
Mais dúvidas? Visite o Central de Ajuda ao estudante.