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

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
Data Science: Capstone (edX) EdX
HarvardX,Harvard University

Data Science: Capstone (edX)

Statistics & Data Analysis Data Science

Show what you’ve learned from the Professional Certificate Program in Data Science. To become an expert data scientist you need practice and experience. By completing this capstone project you will get an opportunity to apply the knowledge and skills in R data analysis that you have gained throughout the series. This final project will test your skills in data visualization, probability, inference and modeling, data wrangling, data organization, regression, and machine learning.

Self Paced
Self-Paced
Probability Machine Learning Regression
Details
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
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
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
Excel for Beginners (edX) EdX
Davidson College,DavidsonX

Excel for Beginners (edX)

Statistics & Data Analysis Data Science

No knowledge of Excel? No problem! Mastering a few basic skills in Excel will open the door to new opportunities, jobs, and more advanced skills that can help you be more efficient in your work or advance your career in your current or a future position. If you’re hoping to move from knowing almost nothing about spreadsheets to basic comfort and competence in Excel, then this is a perfect course for you. The goal of this course is to give you a foundation on which you can build more advanced skills in the future.

Self Paced
Self-Paced
Spreadsheets Excel Microsoft Excel
Details
Data Science: Wrangling (edX) EdX
HarvardX,Harvard University

Data Science: Wrangling (edX)

Statistics & Data Analysis Data Science

Learn to process and convert raw data into formats needed for analysis. In this course, we cover several standard steps of the data wrangling process like importing data into R, tidying data, string processing, HTML parsing, working with dates and times, and text mining. Rarely are all these wrangling steps necessary in a single analysis, but a data scientist will likely face them all at some point.

Self Paced
Self-Paced
Data Science Data Wrangling Text Mining
Details
Introduction to Bayesian Statistics Using R (edX) EdX
University of Canterbury,UCx

Introduction to Bayesian Statistics Using R (edX)

Statistics & Data Analysis Data Science

Learn the fundamentals of Bayesian approach to data analysis, and practice answering real life questions using R. Basics of Bayesian Data Analysis Using R is part one of the Bayesian Data Analysis in R professional certificate. Bayesian approach is becoming increasingly popular in all fields of data analysis, including but not limited to epidemiology, ecology, economics, and political sciences. It also plays an increasingly important role in data mining and deep learning. Let this course be your first step into Bayesian statistics.

Self Paced
Self-Paced
Data Mining Data Analysis ANOVA
Details
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
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
Visualizing Data with R (edX) EdX
IBM

Visualizing Data with R (edX)

Statistics & Data Analysis

Learn about the ggplot2 data visualization package for R, creating map plots with geolocation data using Leaflet, and interactive dashboards to display your work on the web using the R Shiny package! In this course, you will learn about the Grammar of Graphics, a system for describing and building graphs, and how the ggplot2 data visualization package for R applies this concept to basic bar charts, histograms, pie charts, scatter plots, line plots, and box plots.

Self Paced
Self-Paced
Data Visualization R Programming ggplot2
Details