EdX

Excel for Everyone: Data Analysis Fundamentals (edX)

Offered by The University of British Columbia, UBCx,

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

Storytelling and Persuading using Data and Digital Technologies (edX)

EdX

University of Maryland, College Park,University System of Maryland - USM,USMx,UMD

Storytelling and Persuading using Data and Digital Technologies (edX)

Statistics & Data Analysis

Learn how to gain traction for your digital transformation initiatives with stories based on data that use compelling data visualizations to build a persuasive business case. Decisions made by humans are rarely made by data alone. Human decision-makers have cognitive biases, are affected by emotions, and make conceptual leaps beyond what the data may suggest.

Self Paced

Self-Paced

Data Storytelling Data Analysis

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

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

EdX

HarvardX,Harvard University

Data Science: Productivity Tools (edX)

Statistics & Data Analysis Data Science

Keep your projects organized and produce reproducible reports using GitHub, git, Unix/Linux, and RStudio. A typical data analysis project may involve several parts, each including several data files and different scripts with code. Keeping all this organized can be challenging.

Self Paced

Self-Paced

Unix Linux Github

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

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

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

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

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

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

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

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