EdX

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

Offered by Universitat Politècnica de València, UPValenciaX,

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

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

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

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

Excel for Everyone: Data Management (edX)

EdX

The University of British Columbia,UBCx

Excel for Everyone: Data Management (edX)

Statistics & Data Analysis

Further your Excel skills to manage larger datasets and more complex data wrangling, management and modelling. This intermediate Excel course builds on the teachings of the introductory Core Foundations course, teaching you to leverage the power of data calculations and reports to make informed personal or organizational decisions.

Self Paced

Self-Paced

Excel Data Management Microsoft Excel

EdX

University of Adelaide,AdelaideX

Big Data Capstone Project (edX)

Statistics & Data Analysis Data Science

Further develop your knowledge of big data by applying the skills you have learned to a real-world data science project. This project will give you the opportunity to deepen your learning by giving you valuable experience in evaluating, selecting and applying relevant data science techniques, principles and theory to a data science problem. This project will see you plan and execute a reasonably substantial project and demonstrate autonomy, initiative and accountability.

Self Paced

Self-Paced

Big Data Data Science Data Analytics

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

EdX

University of Adelaide,AdelaideX

Programming for Data Science (edX)

CS: Programming Data Science

Learn how to apply fundamental programming concepts, computational thinking and data analysis techniques to solve real-world data science problems. There is a rising demand for people with the skills to work with Big Data sets and this course can start you on your journey through our Big Data MicroMasters program towards a recognised credential in this highly competitive area. Using practical activities you will learn how digital technologies work and will develop your coding skills through engaging and collaborative assignments.

Self Paced

Self-Paced

Programming Big Data Data Analysis

EdX

Universitat Politècnica de València,UPValenciaX

Excel: fundamentos y herramientas (edX)

CS: Software Engineering CS: Information & Technology

En este curso de Excel aprenderás las herramientas más habituales, desde lo más básico a los gráficos, formulas, funciones y tablas de datos. Conoceras cómo beneficiarte de las capacidades de este programa de Microsoft. Este es un curso de Excel basico en el que aprenderas a trabajar con este programa informatico de Microsoft, el componente para hojas de cálculo de la suite ofimática de Microsoft, MS-Office.

Self Paced

Self-Paced

Excel Microsoft Microsoft Excel

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

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

EdX

IBM

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

Statistics & Data Analysis

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

Spreadsheets Excel Analytics

Data Processing and Analysis with Excel (edX)

EdX

Rochester Institute of Technology,RITx

Data Processing and Analysis with Excel (edX)

Statistics & Data Analysis

Learn to use Excel to organize and clean data so it can be manipulated and analyzed. In this course, you will learn how to organize your data within the Microsoft Office Excel software tool. Once organized, we will discuss data cleaning. You will learn how to identify outliers and anomalies in the data, and how to identify and change data-types. Together we will develop a data analysis plan, after which we will apply analysis methods and tools, including exploratory analysis, evaluation of results, and comparison with other findings.

Self Paced

Self-Paced

Excel Data Analysis Microsoft Excel

EdX

HarvardX,Harvard University

High-Dimensional Data Analysis (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

A focus on several techniques that are widely used in the analysis of high-dimensional data. If you’re interested in data analysis and interpretation, then this is the data science course for you. We start by learning the mathematical definition of distance and use this to motivate the use of the singular value decomposition (SVD) for dimension reduction and multi-dimensional scaling and its connection to principle component analysis.

Self Paced

Self-Paced

Machine Learning Clustering Data Analysis