EdX

Excel avanzado: importación y análisis de datos (edX)

Offered by Universitat Politècnica de València, UPValenciaX,
Excel avanzado: importación y análisis de datos (edX)

Conoce técnicas y estrategias avanzadas para importar, consolidar y visualizar con Excel datos provenientes de cualquier fuente. En este curso de análisis e interpretación de datos te presentaremos técnicas avanzadas de importación de datos y estrategias diversas para consolidarlos y prepararlos una vez importados de forma que puedas extraer las conclusiones que necesitas (basadas en nuestra experiencia en el uso de Microsoft Excel y demostradas con casos reales).

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

Te presentaremos también las nuevas herramientas y técnicas de modelo de datos e importación avanzada incorporados desde Excel 2010 que permiten trabajar de forma mucho más cómoda con grandes volúmenes de datos repartidos en varias tablas y automatizar la importación para no tener que repetir los pasos cada vez que actualices los datos.

Veremos también las distintas opciones disponibles a la hora de configurar tablas y gráficos dinámicos en Excel para que sean lo más versátiles posibles y nos permitan analizar distintos escenarios de forma sencilla.
Estas herramientas y técnicas de análisis de datos te permitirán implementar inteligencia de negocios (Business Intelligence) en los diferentes proyectos de una organización.
This course is part of the following programs:

What you'll learn

  • Cómo hacer un preprocesado de datos con editores avanzados de texto para eliminar problemas de importación
  • Cómo usar las herramientas Powerquery de importación de datos en Excel incluidas en las últimas versiones para automatizar el proceso de ingesta de datos
  • Cómo utilizar diversas funciones y estrategias para agrupar y consolidar los datos de forma que nos den la información que necesitamos y poderla usar en la inteligencia de negocios
  • Cómo usar las funciones Powerpivot y el modelo de datos incluidos en las nuevas versiones de Excel para trabajar de forma sencilla con datos de múltiples tablas con millones de registros como las que se manejan en Big Data
  • Cómo utilizar los slicers y otras funciones avanzadas de tablas y gráficos dinámicos en Excel
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Statistics and R (edX) EdX
HarvardX,Harvard University

Statistics and R (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

An introduction to basic statistical concepts and R programming skills necessary for analyzing data in the life sciences. We will learn the basics of statistical inference in order to understand and compute p-values and confidence intervals, all while analyzing data with R. We provide R programming examples in a way that will help make the connection between concepts and implementation.

Self Paced
Self-Paced
Statistics Data Analysis Statistical Inference
Details
Analytics for Decision Making (edX) EdX
Babson College

Analytics for Decision Making (edX)

Management & Leadership Statistics & Data Analysis

Discover the foundational concepts that support modern data science and learn to analyze various data types and quality to make smart business decisions. Want to know how to avoid bad decisions with data? Making good decisions with data can give you a distinct competitive advantage in business. This statistics and data analysis course will help you understand the fundamental concepts of sound statistical thinking that can be applied in surprisingly wide contexts, sometimes even before there is any data! Key concepts like understanding variation, perceiving relative risk of alternative decisions, and pinpointing sources of variation will be highlighted.

Self Paced
Self-Paced
Data Analysis Decision Making Analytics
Details
Computational Thinking and Big Data (edX) EdX
University of Adelaide,AdelaideX

Computational Thinking and Big Data (edX)

CS: Software Engineering Statistics & Data Analysis

Learn the core concepts of computational thinking and how to collect, clean and consolidate large-scale datasets. Computational thinking is an invaluable skill that can be used across every industry, as it allows you to formulate a problem and express a solution in such a way that a computer can effectively carry it out.

Self Paced
Self-Paced
Big Data Data Science Algorithmic Thinking
Details
Advanced Statistical Inference and Modelling Using R (edX) EdX
University of Canterbury,UCx

Advanced Statistical Inference and Modelling Using R (edX)

Sci: Mathematics Statistics & Data Analysis

Extend your knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up. Advanced Statistical Inference and Modelling Using R is part two of the Statistical Analysis in R professional certificate. This course is directed at people who are already familiar with basic linear regression and fundamentals of statistical inference. It extends the knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up.

Self Paced
Self-Paced
Modeling Data Analysis Linear Regression
Details
Introduction to Computer Science and Programming (edX) EdX
Tokyo Institute of Technology,TokyoTechX

Introduction to Computer Science and Programming (edX)

CS: Programming

The term “Computation” refers to the action performed by a computer. A computation can be a basic operation and it can also be a sophisticated computer simultation requiring a large amount of data and substantial resources. This course aims at introducing learners with no prior knowledge to basics and key concepts of computer science. By following the lectures and exercises of this course you will have an understanding of algorithms and you will get a real experience of programming using the language Ruby.

Self Paced
Self-Paced
Programming Artificial Intelligence Big Data
Details
Excel for Everyone: Core Foundations (edX) EdX
The University of British Columbia,UBCx

Excel for Everyone: Core Foundations (edX)

Statistics & Data Analysis

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
Spreadsheets Excel Data Analysis
Details
Técnicas Cuantitativas y Cualitativas para la Investigación (edX) EdX
Universitat Politècnica de València,UPValenciaX

Técnicas Cuantitativas y Cualitativas para la Investigación (edX)

Statistics & Data Analysis

El curso pretende acercar al alumno al método científico y, en concreto, cómo éste se aplica al estudio y análisis de los métodos de casos. El curso que se propone es ideal para investigadores y alumnos que se encuentren cursando trabajos de fin de grado, trabajos de fin de máster o realizando tesis, así como todos aquellos del área de la administración que quieran realizar un análisis cuantitativo o cualitativo en sus estudios.

Self Paced
Self-Paced
Research Methods Data Analysis Scientific Methods
Details
Introduction to Digital Humanities (edX) EdX
HarvardX,Harvard University

Introduction to Digital Humanities (edX)

Humanities Computer Science

Develop skills in digital research and visualization techniques across subjects and fields within the humanities. This course will show you how to manage the many aspects of digital humanities research and scholarship. Whether you are a student or scholar, librarian or archivist, museum curator or public historian — or just plain curious — this course will help you bring your area of study or interest to new life using digital tools.

Self Paced
Self-Paced
Data Analysis Command Line Interface Digital Humanities
Details
RShiny for Everyone (edX) EdX
Davidson College,DavidsonX

RShiny for Everyone (edX)

Statistics & Data Analysis

Use R’s Shiny package to create data-driven, interactive web applications. In this course, you will use R Shiny to create an interactive web application that highlights the biodiversity of America’s National Parks. Your application will feature an interactive map, biodiversity calculator, trail journal and species images. Using R Shiny, you will expand your data analysis and visualization skills while developing your workflow through web application deployment.

Self Paced
Self-Paced
Data Analysis Web Applications Data Visualization
Details
Analyzing Data with Excel (edX) EdX
IBM

Analyzing Data with Excel (edX)

Statistics & Data Analysis

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
Data Spreadsheets Excel
Details