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 forma parte de Programa especializado: Excel Skills for Data Analytics and Visualization
Acerca de este Curso
¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negociosQué aprenderás
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 obtendrás
- Data Analysis
- Microsoft Excel
- Data Cleansing
¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negociosOfrecido por
Comienza a trabajar para obtener tu maestría
Los Certificados MasterTrack™ representan secciones de los programas de las Maestrías que se han dividido en módulos en línea para que puedas obtener una credencial profesional en línea otorgada por una universidad de excelente calidad a un precio sorprendente y con un formato interactivo y flexible. Si te inscribes en el programa, el trabajo del curso se tomará en cuenta para tu Certificado MasterTrack.
Programa - Qué aprenderás en 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
Reseñas
- 5 stars81,93 %
- 4 stars15,79 %
- 3 stars1,50 %
- 2 stars0,23 %
- 1 star0,53 %
Principales reseñas sobre EXCEL FUNDAMENTALS FOR DATA ANALYSIS
Super fun and and intellectual course. Real need of hour to excel in Excel :) . This course helped a lot, in improving skills in excel analytics.
special thanks to both the instructors !!!!!!!
A very well structured course with easy to follow examples. I would give it a 4.5 because there is some error in the workbook and quizzes but apparently, it hasn't been changed despite to complaints
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.
This Course has really giving me a better insight to the things i can do with Excel and even more. i am building on the knowledge gained for my work in other areas
Yaw Agyakwa Adu
Acerca de Programa especializado: Excel Skills for Data Analytics and Visualization

Preguntas Frecuentes
¿Cuándo podré acceder a las lecciones y tareas?
¿Qué recibiré si me suscribo a este Programa especializado?
¿Hay ayuda económica disponible?
¿Tienes más preguntas? Visita el Centro de Ayuda al Estudiante.