Coursera

Power Query Fundamentals (Coursera)

Offered by Corporate Finance Institute,
Power Query Fundamentals (Coursera)

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

Competencias digitales. Herramientas de ofimática (Microsoft Word, Excel, Power Point) (Coursera) Coursera
Universitat Autònoma de Barcelona

Competencias digitales. Herramientas de ofimática (Microsoft Word, Excel, Power Point) (Coursera)

CS: Information & Technology Personal and Professional Development

Los continuos cambios tecnológicos, sobre todo en aquellos aspectos vinculados a las tecnologías de la información y la comunicación (TIC) hacen que las personas tengan la necesidad de actualizarse de forma continua para que sus conocimientos no queden obsoletos. En este contexto, para las empresas se convierte en algo imprescindible disponer de profesionales que tengan las competencias necesarias para ejercer con éxito las actividades que requieren en su lugar de trabajo.

Jun 8th 2026
5-12 Weeks
Excel Digital Skills Microsoft Excel
Details
Statistics and Data Analysis with Excel, Part 1 (Coursera) Coursera
University of Colorado Boulder

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

Statistics & Data Analysis Data Science

Designed for students with no prior statistics knowledge, this course will provide a foundation for further study in data science, data analytics, or machine learning. Topics include descriptive statistics, probability, and discrete and continuous probability distributions. Assignments are conducted in Microsoft Excel (Windows or Mac versions). Designed to be taken with the follow-up course, “Statistics and Data Analysis with Excel, Part 2.”

Jun 8th 2026
5-12 Weeks
Statistics Probability Excel
Details
Salesforce Integration (Coursera) 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.

Jun 8th 2026
3 Weeks
Business Data Management Cloud Computing
Details
Introduction to Spreadsheets and Models (Coursera) Coursera
University of Pennsylvania

Introduction to Spreadsheets and Models (Coursera)

Management & Leadership Business

The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future.

Jun 8th 2026
4 Weeks
Business Models Spreadsheets
Details
Configuration Management and the Cloud (Coursera) Coursera
Google

Configuration Management and the Cloud (Coursera)

CS: Information & Technology Computer Science

In this course, you’ll learn how to apply automation to manage fleets of computers. You’ll understand how to automate the process for deploying new computers, keeping those machines updated, managing large-scale changes, and a lot more. We'll discuss managing both physical machines running in our offices and virtual machines running in the Cloud.

Jun 9th 2026
4 Weeks
Cloud Cloud Computing Automation
Details
Exploring and Producing Data for Business Decision Making (Coursera) 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 8th 2026
4 Weeks
Probability Excel Inference
Details
Problem Solving with Excel (Coursera) 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.

Jun 8th 2026
4 Weeks
Excel Data Analysis Microsoft Excel
Details
Work Smarter with Microsoft Excel (Coursera) Coursera
Microsoft

Work Smarter with Microsoft Excel (Coursera)

CS: Information & Technology

This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required.

Jun 8th 2026
5-12 Weeks
Spreadsheets Excel Microsoft Excel
Details
Python Basics: Automation and Bots (Coursera) Coursera
University of California, Davis

Python Basics: Automation and Bots (Coursera)

Computer Science

Manipulating the flow of how your code runs is the major part of coding and learning to think in code. We'll experience turning logic into useful work by automatically reading all of Shakespeare, and by setting Python up to give you a call on the phone. In technical terms, the parts of Python you will learn are for loops, list comprehensions, and conditional statements, while at a higher level we'll get a lot on code style and other common ideas and practices that surround the specifics of how to code.

Jun 8th 2026
4 Weeks
Programming Python Coding
Details
A Comprehensive Excel Masterclass (Coursera) Coursera
Illinois Tech

A Comprehensive Excel Masterclass (Coursera)

Business

The Comprehensive Excel Masterclass is an advanced course designed to empower students with the skills and knowledge needed to maximize the potential of Microsoft Excel in a business environment. This course goes beyond the basics and explores advanced functions, and features that will enable students to perform complex calculations, retrieve and manipulate data from multiple sources, and gain valuable insights from data. The course combines theoretical concepts with practical exercises and examples to reinforce learning.

Jun 8th 2026
4 Weeks
Excel Microsoft Excel Financial Analysis
Details
Forecasting Models for Marketing Decisions (Coursera) 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.

Jun 8th 2026
4 Weeks
Marketing Excel Microsoft Excel
Details