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

Introduction to Computers and Office Productivity Software (Coursera) 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.

Aug 3rd 2026
5-12 Weeks
Computer Software Hardware
Details
AWS Database Specialty Certification (Coursera) Coursera
EDUCBA

AWS Database Specialty Certification (Coursera)

CS: Information & Technology

This course offers a comprehensive journey through the world of databases and their management on the AWS cloud platform. From understanding the core concepts of databases to mastering advanced topics like migration, automation, and security, participants will gain a solid foundation in database design, deployment, and management using AWS services.

Aug 3rd 2026
5-12 Weeks
Security Databases Migration
Details
Exploration et production de données pour les entreprises (Coursera) Coursera
University of Illinois at Urbana-Champaign

Exploration et production de données pour les entreprises (Coursera)

Business

Ce cours fournit un cadre analytique afin de vous aider à évaluer les problèmes clés de manière structurée. Il vous procurera également des outils afin de mieux gérer les incertitudes qui envahissent et compliquent les processus des entreprises. Plus précisément, vous serez initié(e) aux statistiques et à la manière de résumer les données. Vous découvrirez les concepts de fréquence, de loi normale, d’études statistiques, de l’échantillonnage et des intervalles de confiance.

Jul 20th 2026
4 Weeks
Probability Excel Inference
Details
Statistics and Data Analysis with Excel, Part 2 (Coursera) 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.

Jul 27th 2026
5-12 Weeks
Statistics Excel Data Analysis
Details
Introduction to Data Analysis Using Excel (Coursera) 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.

Jul 20th 2026
4 Weeks
Spreadsheets Excel Data Analysis
Details
Business Analytics with Excel: Elementary to Advanced (Coursera) 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.

Jul 27th 2026
5-12 Weeks
Spreadsheets Excel Linear Programming
Details
Blue Prism Foundation Training (Coursera) 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.

Jul 20th 2026
5-12 Weeks
Automation Robotic Process Automation RPA
Details
Salesforce Reporting (Coursera) 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.

Jul 20th 2026
3 Weeks
Business Interface Data Management
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.

Jul 20th 2026
5-12 Weeks
Spreadsheets Excel Microsoft Excel
Details
Fundamentos de Excel para Negocios (Coursera) Coursera
Universidad Austral

Fundamentos de Excel para Negocios (Coursera)

Statistics & Data Analysis Data Science

Cuando finalices este curso habrás logrado un gran número de habilidades como introducir información, ordenarla, manipularla, realizar cálculos de diversa índole (matemáticos, trigonométricos, estadísticos, financieros, ingenieriles, probabilísticos), extraer conclusiones, trabajar con fechas y horas, construir gráficos, imprimir reportes y muchas más.

Jul 20th 2026
5-12 Weeks
Business Excel Data Analysis
Details