EdX

Excel for Everyone: Data Analysis Fundamentals (edX)

Offered by The University of British Columbia, UBCx,
Excel for Everyone: Data Analysis Fundamentals (edX)

Perform advanced data wrangling, analysis and dashboard visualization to help drive strategic decision-making. Whether you need to process numbers for personal projects or for organizational purposes like sales, inventory, human resources, or IT, knowing how to make sense of data is critical.

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

You will develop in-demand skills to gain a competitive edge and value to your organization, including how to extract actionable organizational intelligence from raw data, and present it in a visual format to help drive organizational decision-making Learn how to get Excel to do the hard work for you with sophisticated automation, spreadsheet design and powerful dashboards.
This advanced Excel course builds on the teachings of Course 1: Core Foundations and Course 2: Data Management. Designed for experienced Excel users, master the techniques needed to draw insights from vast amounts of data.
This course is part of the Excel for Everyone Professional Certificate

What you'll learn

  • How to apply advanced formulas and conditional logic.
  • How to analyze and report on data frequently.
  • Automating complex or repetitive tasks.
  • How to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
  • Protecting your workbooks.
  • Performing Formula Audits and Data Validation.
  • Creating Macros and usingVisual Basic.
  • How to use Advanced Charting Techniques to build professional dashboards.
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Basics of Statistical Inference and Modelling Using R (edX) EdX
University of Canterbury,UCx

Basics of Statistical Inference and Modelling Using R (edX)

Sci: Mathematics Statistics & Data Analysis

Learn why a statistical method works, how to implement it using R and when to apply it and where to look if the particular statistical method is not applicable in the specific situation. Basics of Statistical Inference and Modelling Using R is part one of the Statistical Analysis in R professional certificate.

Self Paced
Self-Paced
Statistics Modeling Data Analysis
Details
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
Excel avanzado: importación y análisis de datos (edX) EdX
Universitat Politècnica de València,UPValenciaX

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

CS: Information & Technology Statistics & Data Analysis

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).

Self Paced
Self-Paced
Excel Microsoft Big Data
Details
Analyzing Data with R (edX) EdX
IBM

Analyzing Data with R (edX)

Statistics & Data Analysis

R is the key that opens the door between the problems you want to solve with data and the answers you need. This course walks you through the process of answering questions through data. The R programming language is purpose-built for data analysis. R is the key that opens the door between the problems you want to solve with data and the answers you need to meet your objectives.

Self Paced
Self-Paced
Data Data Analysis ANOVA
Details
Excel: Gestión de datos (edX) EdX
Universitat Politècnica de València,UPValenciaX

Excel: Gestión de datos (edX)

CS: Software Engineering CS: Information & Technology

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.

Self Paced
Self-Paced
Spreadsheets Excel Data Management
Details
R Data Science Capstone Project (edX) EdX
IBM

R Data Science Capstone Project (edX)

Statistics & Data Analysis

Apply various data analysis and visualization skills and techniques you have learned by taking on the role of a data scientist working with real-world data sets. In this capstone course, you will apply various data science skills and techniques that you have learned as part of the previous courses in the IBM Data Science with R or IBM Data Analytics with Excel and R Professional Certificate Programs.

Self Paced
Self-Paced
Statistics Data Analysis Linear Regression
Details
Data Science: R Basics (edX) EdX
HarvardX,Harvard University

Data Science: R Basics (edX)

Statistics & Data Analysis Data Science

Build a foundation in R and learn how to wrangle, analyze, and visualize data. This course will introduce you to the basics of R programming. You can better retain R when you learn it to solve a specific problem, so you’ll use a real-world dataset about crime in the United States. You will learn the R skills needed to answer essential questions about differences in crime across the different states.

Self Paced
Self-Paced
Probability Machine Learning Inference
Details
Observation Theory: Estimating the Unknown (edX) EdX
Delft University of Technology,DelftX

Observation Theory: Estimating the Unknown (edX)

Engineering Sci: Mathematics

Learn how to estimate parameters from observational data for real-world engineering applications and assess the quality of the results. Are you an engineer, scientist or technician? Are you dealing with measurements or big data, but are you unsure about how to proceed? This is the course that teaches you how to find the best estimates of the unknown parameters from noisy observations. You will also learn how to assess the quality of your results.

Self Paced
Self-Paced
Data Analysis Mathematical Models Observation Theory
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
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
Details
Ciencia de Datos Aplicada al Marketing (edX) EdX
Universidad Anáhuac,AnahuacX

Ciencia de Datos Aplicada al Marketing (edX)

Statistics & Data Analysis

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
Marketing Excel Análisis Estadístico
Details