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 Minnesota

Optimization for Decision Making (Coursera)

Statistics & Data Analysis Data Science

In this data-driven world, companies are often interested in knowing what is the "best" course of action, given the data. For example, manufacturers need to decide how many units of a product to produce given the estimated demand and raw material availability? Should they make all the products in-house or buy some from a third-party to meet the demand? Prescriptive Analytics is the branch of analytics that can provide answers to these questions. It is used for prescribing data-based decisions.

Sep 14th 2026

4 Weeks

Spreadsheets Excel Linear Programming

Coursera

Macquarie University

Habilidades de Excel para el negocio: Conceptos básicos (Coursera)

Business

En este primer curso de la especialización de habilidades de Excel para el negocio, aprenderá los conceptos básicos de Microsoft Excel. En seis semanas, podrá navegar, de forma experta, a través de la interfaz de usuario de Excel, realizar cálculos básicos con fórmulas y funciones, dar formato profesional a hojas de cálculo y crear visualizaciones de datos a través de gráficos y cuadros.

Sep 14th 2026

5-12 Weeks

Spreadsheets Excel 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

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

Northeastern University

Machine Learning in Healthcare: Fundamentals & Applications (Coursera)

Health & Society Data Science

Examines data mining perspectives and methods in a healthcare context. Introduces the theoretical foundations for major data mining methods and studies how to select and use the appropriate data mining method and the major advantages for each. Students are exposed to contemporary data mining software applications and basic programming skills. Focuses on solving real-world problems, which require data cleaning, data transformation, and data modeling.

Sep 28th 2026

4 Weeks

Healthcare Artificial Intelligence Machine Learning

Coursera

University of Michigan

People, Technology and the Future of Mobility (Coursera)

Health & Society

Welcome to the People Technology & Future of Mobility course! This course provides a lay-person’s introduction to some of the major technological innovations currently underway in the mobility space and asks learners to apply a variety of social science concepts to understand the likely social impacts of these technologies. The course is appropriate for learners from all backgrounds and does not require prior training in engineering or social science.

Sep 14th 2026

5-12 Weeks

Technological Innovations Autonomous Vehicles Mobility

Coursera

Emory University

Forecasting Models for Marketing Decisions (Coursera)

Management & Leadership Marketing & Communication

How will customers act in the future? What will demand for our products and services be? How much inventory should we order for the next season? Beyond simply forecasting what customers will do, marketers need to understand how their actions can shape future behavior. In Developing Forecasting Tools with Excel, learners will develop an understanding of the basic components of a forecasting model, how to build their own forecasting models, and how to evaluate the performance of forecasting models.

Sep 14th 2026

4 Weeks

Marketing Excel Microsoft Excel

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

Macquarie University

Judgmental Business Forecasting in Excel (Coursera)

Business

In this course, we extend your business forecasting expertise from the first two courses of our Business Forecasting Specialisation on Time Series Models and Regression Models. We will explore the role of judgmental forecasting, when more quantitative forecasting methods have limitations, and we need to generate further business insights.

Sep 14th 2026

4 Weeks

Excel Coursera Plus Excel Skills for Business Forecasting Specialization

Coursera

Johns Hopkins University

Business Analytics with Excel: Elementary to Advanced (Coursera)

Business

A leader in a data driven world requires the knowledge of both data-related (statistical) methods and of appropriate models to use that data. This Business Analytics class focuses on the latter: it introduces students to analytical frameworks used for decision making though Excel modeling. These include Linear and Integer Optimization, Decision Analysis, and Risk modeling. For each methodology students are first exposed to the basic mechanics, and then apply the methodology to real-world business problems using Excel.

Sep 21st 2026

5-12 Weeks

Spreadsheets Excel Linear Programming

Coursera

The Hong Kong University of Science and Technology - HKUST

Introduction to Computers and Office Productivity Software (Coursera)

CS: Design & Product

In this course, you will learn the following essential computer skills for the digital age: major hardware components of a computer system; different types of software on a computer system; photo Editing using GIMP; and word processing applications, including MS Word, MS Excel, and MS PowerPoint.

Sep 28th 2026

5-12 Weeks

Computer Software Hardware