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

RShiny for Everyone (edX) 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
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
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
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
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
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
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
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
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
Details
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
Details
Datos para la efectividad de las políticas públicas (edX) EdX
Inter-American Development Bank - IDB,IDBx

Datos para la efectividad de las políticas públicas (edX)

Management & Leadership Economics & Finance

Este curso te ayudará a tomar el control de los datos y familiarizarte con las herramientas para utilizarlos en la planificación, gestión y evaluación de políticas publicas. En esta era de la información, los datos están disponibles en todos lados y crecen a una tasa exponencial. ¿Cómo podemos darles sentido a todos los datos y aprovecharlos en el momento de tomar decisiones?, ¿cómo los utilizamos para que nos ayuden a guiar la gestión y planificación de nuestras políticas? Tanto si eres ciudadano como planificador de políticas, deberías poder responder a estas preguntas.

Self Paced
Self-Paced
Data Data Analysis Datalogy
Details