EdX

Excel: Gestión de datos (edX)

Excel: Gestión de datos (edX)

En este curso profundizarás en las herramientas para el tratamiento y manejo de datos que ofrece Excel. Este es un curso de nivel intermedio que te permitirá trabajar con datos para su tratamiento y extraer conclusiones mediante el agrupamiento de datos, el uso de tablas y gráficos dinámicos, la realización de análisis de hipótesis y la vinculación de datos de otras hojas de cálculo.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

El uso de Excel es fundamental para la buena toma de decisiones y es ampliamente usado en la inteligencia de negocios (Business Intelligence) y en otras áreas como la investigativa y la académica.
Durante el curso te enseñaremos como beneficiarte del manejo e interpretación de los datos con el uso de las herramientas de Excel y cómo las puedes aplicar en la vida real.
This course is part of the following programs:

What you'll learn:

  • Crear plantillas y vincular datos externos
  • Agrupar datos en tablas para extraer información
  • Utilizar tablas y gráficos dinámicos para presentar y extraer información
  • Utilizar análisis de hipótesis para una mejor toma de decisiones
  • Aprender utilidades de conversión de datos de Excel

Syllabus

Unidades:

  • Trabajar con plantillas y hojas vinculadas
  • Trabajar con grupos de datos
  • Tablas y gráficos dinámicos
  • Ampliación del uso de funciones de cálculo
  • Análisis de hipótesis
  • Otras utilidades
  • Examen Final

Prerequisites
Para seguir este curso debes haber completado anteriormente el curso Excel: fundamentos y herramientas, también en edX.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Math for MBA and GMAT Prep (Coursera) Coursera
Emory University

Math for MBA and GMAT Prep (Coursera)

This course gives participants a basic understanding of statistics as they apply in business situations. A fair share of students considering MBA programs come from backgrounds that do not include a large amount of training in mathematics and statistics. Often, students find themselves at a disadvantage when they apply for or enroll in MBA programs. This course will give you the tools to understand how these business statistics are calculated for navigating the built-in formulas that are included in Excel, but also how to apply these formulas in an range of business settings and situations.

Aug 10th 2026
5-12 Weeks
Ciencia de Datos Aplicada al Marketing (edX) EdX
Universidad Anáhuac,AnahuacX

Ciencia de Datos Aplicada al Marketing (edX)

Toma decisiones en marketing basadas en los datos. Históricamente las matemáticas nacieron por primera vez, debido a la necesidad de entender nuestro entorno y tomar decisiones. En particular, la ciencia de datos (data science), se enfoca en el procesamiento de datos: analizar, explorar e interpretar conjuntos de datos, y con base en ello, tener un panorama completo del presente.

Self Paced
Self-Paced
Excel/VBA for Creative Problem Solving, Part 2 (Coursera) Coursera
University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 2 (Coursera)

Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Aug 10th 2026
4 Weeks
Análisis de datos: Llévalo al MAX() (edX) EdX
Delft University of Technology,DelftX

Análisis de datos: Llévalo al MAX() (edX)

Incrementa tus habilidades de análisis de datos utilizando hojas de cálculo y visualización de datos en Excel. Aumenta tu productividad y produce mejores decisiones de negocio. Este curso de análisis de datos (business intelligence: BI) y estadísticas es para todos aquellos que quieren mejorar sus habilidades en el análisis de datos. ¿Buscas una forma inteligente de visualizar los datos para que tengan sentido? ¿Quieres entender esa colección de datos loca que te dio tu jefe? ¿Tienes Megabytes de sensores de datos para analizar? ¡No te preocupes, lo tenemos cubierto!

Self Paced
Self-Paced
Excel for Beginners (edX) EdX
Davidson College,DavidsonX

Excel for Beginners (edX)

No knowledge of Excel? No problem! Mastering a few basic skills in Excel will open the door to new opportunities, jobs, and more advanced skills that can help you be more efficient in your work or advance your career in your current or a future position. If you’re hoping to move from knowing almost nothing about spreadsheets to basic comfort and competence in Excel, then this is a perfect course for you. The goal of this course is to give you a foundation on which you can build more advanced skills in the future.

Self Paced
Self-Paced
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Aug 10th 2026
5-12 Weeks
Data Visualization and Building Dashboards with Excel and Cognos (edX) EdX
IBM

Data Visualization and Building Dashboards with Excel and Cognos (edX)

Build the fundamental knowledge necessary to use Excel and IBM Cognos Analytics to create data visualizations and to create dashboards containing those visualizations to help tell a lucid story about data. This course provides students with the basics required to create data visualizations and dashboards using both Microsoft Excel and IBM Cognos Analytics.

Self Paced
Self-Paced
Analyzing Data with Excel (edX) EdX
IBM

Analyzing Data with Excel (edX)

Build the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course covers the basic workings and key features of Excel to help students analyze their data. This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis.The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.

Self Paced
Self-Paced
Excel for Everyone: Core Foundations (edX) EdX
The University of British Columbia,UBCx

Excel for Everyone: Core Foundations (edX)

Learn Excel fundamentals including data wrangling, spreadsheet management, and basic data analysis. This introductory Excel course will equip you with a strong foundational knowledge of Excel to organize, analyze and work with data. You will develop essential Excel skills, such as simple data wrangling and managing spreadsheets, along with a foundational understanding of business data analysis.

Self Paced
Self-Paced