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

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
Analyzing and Visualizing Data with Power BI (edX) EdX
Davidson College,DavidsonX

Analyzing and Visualizing Data with Power BI (edX)

Statistics & Data Analysis Computer Science

Step up your analytics game and learn one of the most in-demand job skills in the United States. Power BI is a robust business analytics and visualization tool from Microsoft that helps data professionals bring their data to life and tell more meaningful stores. This four-week course is a beginner's guide to working with data in Power BI and is perfect for professionals. You'll become confident in working with data, creating data visualizations, and preparing reports and dashboards.

Self Paced
Self-Paced
Data Analysis Data Visualization Power BI
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
Data Analytics and Visualization Capstone Project (edX) EdX
IBM

Data Analytics and Visualization Capstone Project (edX)

Statistics & Data Analysis

Accelerate the knowledge you gain from previous courses in the IBM Data Analyst Professional Certificate program. Assume the role of an Associate Data Analyst and use various skills and techniques on real-world datasets to accomplish a task. This course provides students with the opportunity to assume the role of an Associate Data Analyst who has recently joined an organization. In this role, you will use Data Analytics skills and techniques on real-world datasets to complete a business task.

Self Paced
Self-Paced
Data Data Wrangling Data Visualization
Details
Introductory Statistics : Analyzing Data Using Graphs and Statistics (edX) EdX
Seoul National University,SNUx

Introductory Statistics : Analyzing Data Using Graphs and Statistics (edX)

Economics & Finance Statistics & Data Analysis

This course teaches basic statistical concepts and explores many compelling applications of statistical methods using real-life applications of Statistics. Why do we study statistics? The field of statistics provides professionals and scientists withconceptual foundations and useful techniques for evaluating ideas, testing theories, and - ultimately -uncovering the truth in any situation.

Self Paced
Self-Paced
Statistics Regression Data Analysis
Details
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
Excel: fundamentos y herramientas (edX) 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
Details
Introduction to Linear Models and Matrix Algebra (edX) EdX
HarvardX,Harvard University

Introduction to Linear Models and Matrix Algebra (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

Learn to use R programming to apply linear models to analyze data in life sciences. Matrix Algebra underlies many of the current tools for experimental design and the analysis of high-dimensional data. In this introductory data analysis course, we will use matrix algebra to represent the linear models that commonly used to model differences between experimental units. We perform statistical inference on these differences. Throughout the course we will use the R programming language.

Self Paced
Self-Paced
Algebra Linear Algebra Matrix
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
Programming for Data Science (edX) 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
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