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

Wiretaps to Big Data: Privacy and Surveillance in the Age of Interconnection (edX) EdX
Cornell University

Wiretaps to Big Data: Privacy and Surveillance in the Age of Interconnection (edX)

Social Sciences

Explore the privacy issues of an interconnected world. How does cellular technology enable massive surveillance? Do users have rights against surveillance? How does surveillance affect how we use cellular and other technologies? How does it affect our democratic institutions? Do you know that the metadata collected by a cellular network speaks volumes about its users? In this course you will explore all of these questions while investigating related issues in WiFi and Internet surveillance.

No sessions available
5-12 Weeks
Cryptography Technology Big Data
Details
Computing for Data Analysis (edX) EdX
Georgia Institute of Technology,GTx

Computing for Data Analysis (edX)

CS: Software Engineering Statistics & Data Analysis

A hands-on introduction to basic programming principles and practice relevant to modern data analysis, data mining, and machine learning. The modern data analysis pipeline involves collection, preprocessing, storage, analysis, and interactive visualization of data. In the course, you’ll see how computing and mathematics come together.

Aug 19th 2024
13-24 Weeks
Programming Python Computing
Details
Introduction to Applied Biostatistics: Statistics for Medical Research (edX) EdX
Osaka University

Introduction to Applied Biostatistics: Statistics for Medical Research (edX)

Medicine & Pharmacology Statistics & Data Analysis

Learn data analysis for medical research with practical hands-on examples using R Commander. Want to learn how to analyze real-world medical data, but unsure where to begin? This Applied Biostatistics course provides an introduction to important topics in medical statistical concepts and reasoning.

No sessions available
5-12 Weeks
Statistics Biostatistics Data Analysis
Details
Knowledge Management and Big Data in Business (edX) EdX
The Hong Kong Polytechnic University,HKPolyUx

Knowledge Management and Big Data in Business (edX)

Management & Leadership Social Sciences

Learn why and how knowledge management and Big Data are vital to the new business era. The business landscape is changing so rapidly that traditional management, business and computing courses do not meet the needs for the next generation of workers in the business world. Most traditional methods are of a repetitive, rule-based nature and will be gradually replaced by Artificial Intelligence.

Self Paced
Self-Paced
Business Management Big Data
Details
Introduction to Apache Spark (edX) EdX
University of California, Berkeley

Introduction to Apache Spark (edX)

CS: Software Engineering Statistics & Data Analysis

Learn the fundamentals and architecture of Apache Spark, the leading cluster-computing framework among professionals. Spark is rapidly becoming the compute engine of choice for big data. Spark programs are more concise and often run 10-100 times faster than Hadoop MapReduce jobs. As companies realize this, Spark developers are becoming increasingly valued.

Not Available
Course Not Available
Programming Big Data Apache Spark
Details
Enabling Technologies for Data Science and Analytics: The Internet of Things (edX) EdX
Columbia University,ColumbiaX

Enabling Technologies for Data Science and Analytics: The Internet of Things (edX)

Statistics & Data Analysis

Discover the relationship between Big Data and the Internet of Things (IoT). The Internet of Things is rapidly growing. It is predicted that more than 25 billion devices will be connected by 2020. In this data science course, you will learn about the major components of the Internet of Things and how data is acquired from sensors. You will also examine ways of analyzing event data, sentiment analysis, facial recognition software and how data generated from devices can be used to make decisions.

Self Paced
Self-Paced
Analysis Big Data Data Analysis
Details
Big Data Analytics Using Spark (edX) EdX
University of California, San Diego,UC San DiegoX

Big Data Analytics Using Spark (edX)

Statistics & Data Analysis Data Science

Learn how to analyze large datasets using Jupyter notebooks, MapReduce and Spark as a platform. In data science, data is called “big” if it cannot fit into the memory of a single standard laptop or workstation. The analysis of big datasets requires using a cluster of tens, hundreds or thousands of computers. Effectively using such clusters requires the use of distributed files systems, such as the Hadoop Distributed File System (HDFS) and corresponding computational models, such as Hadoop, MapReduce and Spark.

Dec 5th 2023
5-12 Weeks
Machine Learning Big Data Hadoop
Details
Quantitative Biology Workshop (edX) EdX
MIT,MITx

Quantitative Biology Workshop (edX)

Sci: Biology & Life Sciences

A workshop-style introduction to tools used in biological research. Discover how to analyze data using computational methods. Do you have an interest in biology and quantitative tools? Do you know computational methods but do not realize how they apply to biological problems? Do you know biology but do not understand how scientists really analyze complicated data? 7.QBWx: Quantitative Biology Workshop is designed to give learners exposure to the application of quantitative tools to analyze biological data at an introductory level.

Self Paced
Self-Paced
Biology Quantitative Computational Methods
Details
The Analytics Edge (edX) EdX
MIT,MITx

The Analytics Edge (edX)

Statistics & Data Analysis

Through inspiring examples and stories, discover the power of data and use analytics to provide an edge to your career and your life. In the last decade, the amount of data available to organizations has reached unprecedented levels. Data is transforming business, social interactions, and the future of our society. In this course, you will learn how to use data and analytics to give an edge to your career and your life.

This course is archived
13-24 Weeks
Data Clustering Data Analysis
Details
Case Studies in Functional Genomics (edX) EdX
HarvardX,Harvard University

Case Studies in Functional Genomics (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

Perform RNA-Seq, ChIP-Seq, and DNA methylation data analyses, using open source software, including R and Bioconductor. We will explain how to perform the standard processing and normalization steps, starting with raw data, to get to the point where one can investigate relevant biological questions.

Self Paced
Self-Paced
Data Analysis Biological Data Genomics
Details
Probability: Basic Concepts & Discrete Random Variables (edX) EdX
Purdue University,PurdueX

Probability: Basic Concepts & Discrete Random Variables (edX)

Sci: Mathematics Statistics & Data Analysis

Learn fundamental concepts of mathematical probability to prepare for a career in the growing field of information and data science. Our capacity to collect and store data has exponentially increased, but deriving information from data from a scientific perspective requires a foundational knowledge of probability. Are you interested in a career in the emerging data science field, or as an actuarial scientist? Or want better to understand statistical theory and mathematical modeling?

No sessions available
5-12 Weeks
Statistics Probability Data Analysis
Details