Coursera

Preparing Data for Analysis with Microsoft Excel (Coursera)

Offered by Microsoft,

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis. 

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel and take you one step closer to becoming a Microsoft Power BI Analyst. 
After completing this course, you’ll be able to: 
• Create data in Microsoft Excel and prepare it for data analysis. 
• Make use of common formulas and functions in a worksheet. 
• Prepare Excel data for analysis in Power BI using functions.
This course is part of the Microsoft Power BI Data Analyst Professional Certificate.

Syllabus

Excel fundamentals
Module 1
This module introduces essential Excel elements and techniques begininning with the creation and formatting of worksheets. It explores the Excel features that are useful when viewing large data blocks and explains how to create accurate calculations.

Formulas and functions
Module 2
This module introduces formulas and functions in Excel. It explores how these are important to data analysis and how these are used in business scenarios.

Preparing data for analysis using functions
Module 3
The module introduces common functions that help prepare Excel data for analysis in tools such as PowerBI.

Final project and assessment: Preparing data for analysis with Microsoft Excel
Module 4
In this module, you will be assessed on the key skills covered in the Course.

Go to Class

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Coursera

University of Washington

Data Manipulation at Scale: Systems and Algorithms (Coursera)

Statistics & Data Analysis Data Science

Data analysis has replaced data acquisition as the bottleneck to evidence-based decision making --- we are drowning in it. Extracting knowledge from large, heterogeneous, and noisy datasets requires not only powerful computing resources, but the programming abstractions to use them effectively. The abstractions that emerged in the last decade blend ideas from parallel databases, distributed systems, and programming languages to create a new class of scalable data analytics platforms that form the foundation for data science at realistic scales.

Jun 22nd 2026

4 Weeks

Algebra Algorithms Databases

Coursera

University of Cape Town

Julia Scientific Programming (Coursera)

Statistics & Data Analysis Data Science

This four-module course introduces users to Julia as a first language. Julia is a high-level, high-performance dynamic programming language developed specifically for scientific computing. This language will be particularly useful for applications in physics, chemistry, astronomy, engineering, data science, bioinformatics and many more.

Jun 22nd 2026

4 Weeks

IPython Data Analysis Computer Programming

Coursera

Johns Hopkins University

Bioconductor for Genomic Data Science (Coursera)

Statistics & Data Analysis Data Science

Learn to use tools from the Bioconductor project to perform analysis of genomic data. This is the fifth course in the Genomic Big Data Specialization from Johns Hopkins University.

Jun 22nd 2026

4 Weeks

Bioinformatics Data Analysis Data Science

Coursera

Johns Hopkins University

Principles of fMRI 1 (Coursera)

Statistics & Data Analysis

Functional Magnetic Resonance Imaging (fMRI) is the most widely used technique for investigating the living, functioning human brain as people perform tasks and experience mental states. It is a convergence point for multidisciplinary work from many disciplines. Psychologists, statisticians, physicists, computer scientists, neuroscientists, medical researchers, behavioral scientists, engineers, public health researchers, biologists, and others are coming together to advance our understanding of the human mind and brain. This course covers the design, acquisition, and analysis of Functional Magnetic Resonance Imaging (fMRI) data, including psychological inference, MR Physics, K Space, experimental design, pre-processing of fMRI data, as well as Generalized Linear Models (GLM’s).

Jun 22nd 2026

4 Weeks

Medicine Statistics Data Analysis

Coursera

Duke University

Introduction to Probability and Data with R (Coursera)

Statistics & Data Analysis Data Science

This course introduces you to sampling and exploring data, as well as basic probability theory and Bayes' rule. You will examine various types of sampling methods, and discuss how such methods can impact the scope of inference. A variety of exploratory data analysis techniques will be covered, including numeric summary statistics and basic data visualization.

Jun 22nd 2026

5-12 Weeks

Statistics Probability Inference

Coursera

University of California, Davis

Fundamentals of GIS (Coursera)

CS: Information & Technology Sci: Physical & Earth Sciences

Explore the world of spatial analysis and cartography with geographic information systems (GIS). What you will learn: define core geospatial concepts; practice with subset data using selections and feature attributes; create map books using advanced mapping techniques; create layer and map packages.

Jun 22nd 2026

4 Weeks

Data Analysis Geographic Information Systems GIS

Coursera

University of Illinois at Urbana-Champaign

Exploring and Producing Data for Business Decision Making (Coursera)

Management & Leadership

This course provides an analytical framework to help you evaluate key problems in a structured fashion and will equip you with tools to better manage the uncertainties that pervade and complicate business processes. Specifically, you will be introduced to statistics and how to summarize data and learn concepts of frequency, normal distribution, statistical studies, sampling, and confidence intervals.

Jun 22nd 2026

4 Weeks

Probability Excel Inference

Coursera

University of Minnesota

Interprofessional Healthcare Informatics (Coursera)

Statistics & Data Analysis Data Science

Interprofessional Healthcare Informatics is a graduate-level, hands-on interactive exploration of real informatics tools and techniques offered by the University of Minnesota and the University of Minnesota's National Center for Interprofessional Practice and Education. We will be incorporating technology-enabled educational innovations to bring the subject matter to life. Over the 10 modules, we will create a vital online learning community and a working healthcare informatics network.

Jun 22nd 2026

5-12 Weeks

Healthcare Informatics Telehealth

Coursera

University of Washington

Practical Predictive Analytics: Models and Methods (Coursera)

Statistics & Data Analysis Data Science

Statistical experiment design and analytics are at the heart of data science. In this course you will design statistical experiments and analyze the results using modern methods. You will also explore the common pitfalls in interpreting statistical arguments, especially those associated with big data. Collectively, this course will help you internalize a core set of practical and effective machine learning methods and concepts, and apply them to solve some real world problems.

Jun 22nd 2026

4 Weeks

Machine Learning Models Methods

Coursera

Johns Hopkins University

Python for Genomic Data Science (Coursera)

Statistics & Data Analysis Data Science

This class provides an introduction to the Python programming language and the iPython notebook. This is the third course in the Genomic Big Data Science Specialization from Johns Hopkins University.

Jun 22nd 2026

4 Weeks

Programming Python Big Data

Coursera

Johns Hopkins University

The Data Scientist's Toolbox (Coursera)

Statistics & Data Analysis Data Science

In this course you will get an introduction to the main tools and ideas in the data scientist's toolbox. The course gives an overview of the data, questions, and tools that data analysts and data scientists work with. There are two components to this course. The first is a conceptual introduction to the ideas behind turning data into actionable knowledge. The second is a practical introduction to the tools that will be used in the program like version control, markdown, git, GitHub, R, and RStudio.

Jun 22nd 2026

4 Weeks

Data Github Data Analysis

Coursera

Johns Hopkins University

Reproducible Research (Coursera)

Statistics & Data Analysis Data Science

This course focuses on the concepts and tools behind reporting modern data analyses in a reproducible manner. Reproducible research is the idea that data analyses, and more generally, scientific claims, are published with their data and software code so that others may verify the findings and build upon them. The need for reproducibility is increasing dramatically as data analyses become more complex, involving larger datasets and more sophisticated computations.

Jun 22nd 2026

4 Weeks

Data Analysis Data Science Reproducible Research