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

Data Science: Inference and Modeling (edX) EdX
HarvardX,Harvard University

Data Science: Inference and Modeling (edX)

Statistics & Data Analysis Data Science

Learn inference and modeling, two of the most widely used statistical tools in data analysis. Statistical inference and modeling are indispensable for analyzing data affected by chance, and thus essential for data scientists. In this course, you will learn these key concepts through a motivating case study on election forecasting.

Self Paced
Self-Paced
Statistics Inference Modeling
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
Analytics for Decision Making (edX) 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
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
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
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 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 for Everyone: Core Foundations (edX) EdX
The University of British Columbia,UBCx

Excel for Everyone: Core Foundations (edX)

Statistics & Data Analysis

Learn Excel fundamentals including data wrangling, spreadsheet management, and basic data analysis. This introductory Excel course will equip you with a strong foundational knowledge of Excel to organize, analyze and work with data. You will develop essential Excel skills, such as simple data wrangling and managing spreadsheets, along with a foundational understanding of business data analysis.

Self Paced
Self-Paced
Spreadsheets Excel Data Analysis
Details
Data Processing and Analysis with Excel (edX) EdX
Rochester Institute of Technology,RITx

Data Processing and Analysis with Excel (edX)

Statistics & Data Analysis

Learn to use Excel to organize and clean data so it can be manipulated and analyzed. In this course, you will learn how to organize your data within the Microsoft Office Excel software tool. Once organized, we will discuss data cleaning. You will learn how to identify outliers and anomalies in the data, and how to identify and change data-types. Together we will develop a data analysis plan, after which we will apply analysis methods and tools, including exploratory analysis, evaluation of results, and comparison with other findings.

Self Paced
Self-Paced
Excel Data Analysis Microsoft Excel
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