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

Statistical Thinking for Data Science and Analytics (edX)

EdX

Columbia University,ColumbiaX

Statistical Thinking for Data Science and Analytics (edX)

Management & Leadership CS: Software Engineering

Learn how statistics plays a central role in the data science approach. This statistics and data analysis course will pave the statistical foundation for our discussion on data science. You will learn how data scientists exercise statistical thinking in designing data collection, derive insights from visualizing data, obtain supporting evidence for data-based decisions and construct models for predicting future trends from data.

Self Paced

Self-Paced

Statistics Data Analysis Data Science

EdX

Indiana University,IUx

Platform-Based Analytics (edX)

Statistics & Data Analysis Business

Gain hands-on experience extracting, preparing, exploring, and analyzing data statistically and visually using features and tools native to Microsoft Excel. In an ever-growing digital world, the need for strong data analysis skills is at the forefront of every business function, along with the ability to accurately describe and interpret analytical findings.

Nov 7th 2023

5-12 Weeks

Excel Data Analysis Microsoft Excel

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

EdX

MIT,MITx

Quantitative Biology Workshop (edX)

Sci: Biology & Life Sciences

A workshop-style introduction to tools used in biological research. Discover how to analyze data using computational methods. Do you have an interest in biology and quantitative tools? Do you know computational methods but do not realize how they apply to biological problems? Do you know biology but do not understand how scientists really analyze complicated data? 7.QBWx: Quantitative Biology Workshop is designed to give learners exposure to the application of quantitative tools to analyze biological data at an introductory level.

Self Paced

Self-Paced

Biology Quantitative Computational Methods

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

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

Imperial College Business School,Imperial College London

Data Analysis Essentials (edX)

Statistics & Data Analysis Business

Discover and acquire the quantitative data analysis skills that you will typically need to succeed on an MBA program. This course will cover the fundamentals of collecting, presenting, describing and making inferences from sets of data. Want to study for an MBA but unsure of the basic data analysis still required? This online course prepares you for studying in an MBA program.

Self Paced

Self-Paced

Data Analysis Decision Making Collecting

EdX

University of Toronto,University of TorontoX

Behavioural Economics in Action (edX)

Management & Leadership

Learn to use principles and methods of behavioural economics to change behaviours, improve welfare and make better products and policy. How can we get people to save more money, eat healthy foods, engage in healthy behaviors, and make better choices in general? There has been a lot written about the fact that human beings do not process information and make decisions in an optimal fashion.

Self Paced

Self-Paced

Economics Regression Behavior

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

Probability: Basic Concepts & Discrete Random Variables (edX)

EdX

Purdue University,PurdueX

Probability: Basic Concepts & Discrete Random Variables (edX)

Sci: Mathematics Statistics & Data Analysis

Learn fundamental concepts of mathematical probability to prepare for a career in the growing field of information and data science. Our capacity to collect and store data has exponentially increased, but deriving information from data from a scientific perspective requires a foundational knowledge of probability. Are you interested in a career in the emerging data science field, or as an actuarial scientist? Or want better to understand statistical theory and mathematical modeling?

No sessions available

5-12 Weeks

Statistics Probability Data Analysis

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