Coursera

Power Query Fundamentals (Coursera)

Offered by Corporate Finance Institute,

In this online Power Query Fundamentals course, we’ll explore the world of data transformation and automation. You’ll learn to extract data from multiple different sources, and transform it into layouts more suited to analysis. We will show you how to automate data connections and transformations, as well as how to extract and consolidate data from multiple files. Finally, we’ll end by looking at how to deal with common errors.

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

Power Query is absolutely essential for any Excel focused analyst, and is a powerful asset to any Business Intelligence analyst. These skills will help you spend less time on data manipulation, and more time on your analysis projects.
By the end of this course, you will be able to:

Identify the characteristics of good and bad data using the principles of data normalization
Extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot
Extract information from fields that combine two or more values
Transform datasets by grouping or combining data from different tables, or even multiple files from the same folder
Avoid, interpret, and fix errors and exceptions that you experience in Power Query
Load transformed data into Excel for use as automated data feeds

This course is part of the Data Skills for Excel Professionals Specialization.

Syllabus

Getting Started
Basic Transformations
Extracting Information
Consolidating Data
Dealing with Errors
Qualified Assessment

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 Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 3 (Projects) (Coursera)

Computer Science

In this course, learners will complete several VBA projects. This is a project-based course. Therefore, the projects are quite open-ended and there are multiple ways to solve the problems. Through the use of Peer Review, other learners will grade learners' projects based on a grading rubric.

Sep 28th 2026

5-12 Weeks

Excel Monte Carlo Method VBA

Coursera

University of California, Irvine

Salesforce Integration (Coursera)

Business

Salesforce Integration explores why data management is so important, how Salesforce can help organize and display reported data to gain insight into trends and patterns, and how to automate manual business procedures. Learners will specifically practice creating custom automation process, building work flows, and performing data modeling. The course includes in-depth readings and practical application activities within Salesforce's Trailhead education platform, peer discussion opportunities, demonstration videos, and peer review assignments.

Sep 14th 2026

3 Weeks

Business Data Management Cloud Computing

Coursera

IBM

Continuous Integration and Continuous Delivery (CI/CD) (Coursera)

CS: Software Engineering

A principle of DevOps is to replace manual processes with automation to improve efficiency, reduce human error, and accelerate software delivery. This requires automation that continuously integrates code changes and continuously delivers those changes to a production environment. This course introduces you to Continuous Integration and Continuous Delivery (CI/CD), an automated approach to software development. You’ll discover the benefits of CI/CD for creating a DevOps pipeline and explore popular CI/CD tools.

Sep 14th 2026

4 Weeks

Automation Continuous Integration Continuous Delivery

Coursera

University of California, Irvine

Salesforce Capstone: Organization Integration (Coursera)

Business

In Salesforce Capstone: Organization Integration, the final course of the Salesforce Fundamentals Specialization, learners will complete the Business Administration Specialist Superbadge as their main project. This project asks learners to combine all the skills and knowledge areas that they have collected from the previous three courses. Skill areas to be demonstrated include cleaning and importing account data, adding users and managing access, building email templates for new marketing needs, configuring UI tools for a new product type, generating reports and dashboards, managing and applying Chatter tools, and participating in the deployment of Salesforce within an organization.

Sep 14th 2026

1 Week

Business Data Management Cloud Computing

Coursera

University of California, Irvine

Salesforce Reporting (Coursera)

Business

Salesforce Reporting focuses on how the micro-level changes in Salesforce affect the macro level of the user experience. In this course, you will focus on creating custom objects, field dependencies, and work flows to track accounts or services. It is also important that you maintain data clean for your organization and you will work with creating reports, managing data, and creating full reports and dashboards. Lastly, you will focus on your customer base with Salesforce Service Cloud to maintain engagement through your services. The course includes in-depth readings and practical application activities within Salesforce's Trailhead education platform, peer discussion opportunities, demonstration videos, and peer review assignments.

Sep 14th 2026

3 Weeks

Business Interface Data Management

Coursera

PwC

Problem Solving with Excel (Coursera)

Statistics & Data Analysis Data Science

This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you’ve learned. Finally, you will have a chance to put your knowledge to work in a final project. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

Sep 14th 2026

4 Weeks

Excel Data Analysis Microsoft Excel

Coursera

Tufts University

Hypothesis Testing with Python and Excel (Coursera)

Statistics & Data Analysis Data Science

In today's job market, leaders need to understand the fundamentals of data to be competitive. An essential procedure to understand business and analytics is hypothesis testing. This short course, designed by Tufts University expert faculty, will teach the fundamentals of hypothesis testing of a population mean and a population proportion, using Excel and Python for calculations. You'll also discover the central limit theorem, which is essential for hypothesis testing. To conclude the course, you will apply your newfound skills by creating a plan for an experiment in your own workplace that uses hypothesis testing.

Sep 15th 2026

1 Week

Python Excel Python Programming

Coursera

Corporate Finance Institute

Fundamentals of Data Analysis in Excel (Coursera)

Economics & Finance Statistics & Data Analysis

Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis. In this course, you’ll apply Excel’s native tools to structure your data into spreadsheets and tables. You’ll then analyze and produce insights from that data using pivot tables. Finally, you’ll visualize those insights by building a dashboard in Excel. You’ll apply these skills using modern functionality like dynamic array formulas, linked data types, and Ideas in Excel. You’ll work hands-on with real-world scenarios, using datasets pulled from financial statements and retail sales.

Sep 21st 2026

5-12 Weeks

Excel Data Analysis Microsoft Excel

Coursera

Rice University

Introduction to Data Analysis Using Excel (Coursera)

Statistics & Data Analysis

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This course is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills.

Sep 14th 2026

4 Weeks

Spreadsheets Excel Data Analysis

Coursera

University of California, Irvine

Salesforce Basics (Coursera)

Business

In this course, you will learn about what the world’s number one Customer Relationship Manager (CRM) system has to offer. You will begin this course by understanding the components that Salesforce leverages to make it an optimal system. You will learn about the basics in Lightning for Sales, Community Cloud and Marketing, and understanding how to secure your Salesforce Organization and Manage Permissions. These tools will serve as building blocks to implementing Salesforce into any organization. The course includes in-depth readings and practical application activities within Salesforce's Trailhead education platform, peer discussion opportunities, demonstration videos, and peer review assignments.

Sep 14th 2026

3 Weeks

Business Data Management Cloud Computing

Coursera

University of Colorado Boulder

Statistics and Data Analysis with Excel, Part 2 (Coursera)

Statistics & Data Analysis Data Science

This course is meant to be a direct continuation of "Statistics and Data Analysis with Excel, Part 1." Therefore, it is not recommended to take Part 2 unless you've also taken Part 1. Building on the topics learned in Part 1 of the course (probability, probability mass and density functions, the normal and standard normal distributions), this course dives into a more applied side of statistics.

Sep 21st 2026

5-12 Weeks

Statistics Excel Data Analysis

Coursera

Blue Prism

Blue Prism Foundation Training (Coursera)

CS: Information & Technology

Blue Prism is the global leader in intelligent automation for the enterprise, transforming the way work is done by empowering businesses to automate time-intensive, mundane tasks and to help free-up their employees to be more creative and innovative. In this course, Blue Prism Foundation Training provides a comprehensive introduction to all of the key concepts and activities associated with configuring a Blue Prism Process Solution.

Sep 14th 2026

5-12 Weeks

Automation Robotic Process Automation RPA