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 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.

Jul 6th 2026

4 Weeks

Probability Excel Inference

Coursera

University of Michigan

Introduction to Data Science in Python (Coursera)

CS: Software Engineering Statistics & Data Analysis

This course will introduce the learner to the basics of the python programming environment, including fundamental python programming techniques such as lambdas, reading and manipulating csv files, and the numpy library. The course will introduce data manipulation and cleaning techniques using the popular python pandas data science library and introduce the abstraction of the Series and DataFrame as the central data structures for data analysis, along with tutorials on how to use functions such as groupby, merge, and pivot tables effectively. By the end of this course, students will be able to take tabular data, clean it, manipulate it, and run basic inferential statistical analyses.

Jul 6th 2026

4 Weeks

Python Data Analysis Data Science

Coursera

University of California, San Diego

Big Data Modeling and Management Systems (Coursera)

Statistics & Data Analysis Data Science

Once you’ve identified a big data issue to analyze, how do you collect, store and organize your data using Big Data solutions? In this course, you will experience various data genres and management tools appropriate for each. You will be able to describe the reasons behind the evolving plethora of new big data platforms from the perspective of big data management systems and analytical tools.

Jul 6th 2026

5-12 Weeks

Big Data Data Management Data Modeling

Coursera

University System of Georgia

Six Sigma Tools for Analyze (Coursera)

Management & Leadership

This course will cover the Measure phase and portions of the Analyze phase of the Six Sigma DMAIC (Define, Measure, Analyze, Improve, and Control) process. You will learn about lean tools for process analysis, failure mode and effects analysis (FMEA), measurement system analysis (MSA) and gauge repeatability and reproducibility (GR&R), and you will be introduced to basic statistics. This course will outline useful measure and analysis phase tools and will give you an overview of statistics as they are related to the Six Sigma process.

Jul 6th 2026

4 Weeks

Statistics Data Analysis Lean Six Sigma

Coursera

University of Colorado Boulder

Communicating Business Analytics Results (Coursera)

Statistics & Data Analysis Data Science

The analytical process does not end with models than can predict with accuracy or prescribe the best solution to business problems. Developing these models and gaining insights from data do not necessarily lead to successful implementations. This depends on the ability to communicate results to those who make decisions.

Jul 6th 2026

4 Weeks

Business Data Selling

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.

Jul 6th 2026

4 Weeks

Algebra Algorithms Databases

Coursera

Nanjing University

Data Processing Using Python (Coursera)

CS: Software Engineering Statistics & Data Analysis

This course is mainly for non-computer majors. It starts with the basic syntax of Python, to how to acquire data in Python locally and from network, to how to present data, then to how to conduct basic and advanced statistic analysis and visualization of data, and finally to how to design a simple GUI to present and process data, advancing level by level.

Jul 6th 2026

5-12 Weeks

Python Data Structures Data Analysis

Coursera

University of Illinois at Urbana-Champaign

Pattern Discovery in Data Mining (Coursera)

Statistics & Data Analysis Data Science

Learn the general concepts of data mining along with basic methodologies and applications. Then dive into one subfield in data mining: pattern discovery. Learn in-depth concepts, methods, and applications of pattern discovery in data mining. We will also introduce methods for data-driven phrase mining and some interesting applications of pattern discovery. This course provides you the opportunity to learn skills and content to practice and engage in scalable pattern discovery methods on massive transactional data, discuss pattern evaluation measures, and study methods for mining diverse kinds of patterns, sequential patterns, and sub-graph patterns.

Jul 6th 2026

4 Weeks

Algorithms Data Mining Data Analysis

Coursera

University of Illinois at Urbana-Champaign

Text Retrieval and Search Engines (Coursera)

Statistics & Data Analysis Data Science

Recent years have seen a dramatic growth of natural language text data, including web pages, news articles, scientific literature, emails, enterprise documents, and social media such as blog articles, forum posts, product reviews, and tweets. Text data are unique in that they are usually generated directly by humans rather than a computer system or sensors, and are thus especially valuable for discovering knowledge about people’s opinions and preferences, in addition to many other kinds of knowledge that we encode in text.

Jul 6th 2026

5-12 Weeks

Machine Learning Search Data Mining

Coursera

University of Colorado Boulder

Business Analytics for Decision Making (Coursera)

Statistics & Data Analysis Data Science

In this course you will learn how to create models for decision making. We will start with cluster analysis, a technique for data reduction that is very useful in market segmentation. You will then learn the basics of Monte Carlo simulation that will help you model the uncertainty that is prevalent in many business decisions.

Jul 6th 2026

4 Weeks

Monte Carlo Method Data Analysis Decision Making

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.

Jul 6th 2026

4 Weeks

Machine Learning Models Methods

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.

Jul 6th 2026

4 Weeks

Data Analysis Data Science Reproducible Research