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

Everyday Excel, Part 2 (Coursera) Coursera
University of Colorado Boulder

Everyday Excel, Part 2 (Coursera)

CS: Information & Technology

"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, [Parts 1](https://www.mooc-list.com/course/everyday-excel-part-1-coursera)". Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)".

Nov 9th 2026
5-12 Weeks
Spreadsheets Excel Data Management
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.

Nov 9th 2026
4 Weeks
Programming Python Coding
Details
Salesforce Capstone: Organization Integration (Coursera) 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.

Nov 9th 2026
1 Week
Business Data Management Cloud Computing
Details
Habilidades de Excel para el negocio: Conceptos básicos (Coursera) 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.

Nov 9th 2026
5-12 Weeks
Spreadsheets Excel Microsoft Excel
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.

Nov 9th 2026
4 Weeks
Excel Data Analysis Microsoft Excel
Details
Data Visualization with Advanced Excel (Coursera) Coursera
PwC

Data Visualization with Advanced Excel (Coursera)

Statistics & Data Analysis Data Science

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek.

Nov 9th 2026
4 Weeks
Databases Excel Data Analysis
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.

Nov 9th 2026
5-12 Weeks
Spreadsheets Excel Microsoft Excel
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.

Nov 16th 2026
5-12 Weeks
Spreadsheets Excel Linear Programming
Details
Excel Modeling for Professionals: Best Practices & Pitfalls (Coursera) Coursera
Delft University of Technology,Erasmus University Rotterdam

Excel Modeling for Professionals: Best Practices & Pitfalls (Coursera)

Business

Through this course learners will gain the tools to decide whether or not Excel is the right software to use. They will learn how to set up good input data, format correctly, and the importance of good documentation. Learners will gain the ability to discern between different functions, to understand the pitfalls and strengths of commonly used functions, and to apply correct functions to their excel models. Those that follow the course will also gain understanding of logical spreadsheet structure, graphs and reporting, and protection and hidden information in Excel, and users will learn how to apply these things to their own models.

Nov 9th 2026
4 Weeks
Business Spreadsheets Excel
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.

Nov 9th 2026
5-12 Weeks
Automation Robotic Process Automation RPA
Details