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
Excel/VBA for Creative Problem Solving, Part 1 (Coursera) Coursera
University of Colorado Boulder

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

CS: Software Engineering CS: Theory

Excel/VBA for Creative Problem Solving, Part 1" is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Jul 27th 2026
5-12 Weeks
Debugging Spreadsheets Excel
Details
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Statistics & Data Analysis Data Science

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Aug 10th 2026
5-12 Weeks
Excel Accounting Data Analysis
Details
Data Visualization in Excel (Coursera) Coursera
Macquarie University

Data Visualization in Excel (Coursera)

Business

In an age now driven by "big data", we need to cut through the noise and present key information in a way that can be quickly consumed and acted upon making data visualization an increasingly important skill. Visualizations need to not only present data in an easy to understand and attractive way, but they must also provide context for the data, tell a story, achieving that fine balance between form and function. Excel has many rivals in this space, but it is still an excellent choice, particularly if it's where your data resides. It offers a wealth of tools for creating visualizations other than charts and the chart options available are constantly increasing and improving, so the newer versions now include waterfall charts, sunburst diagrams and even map charts. But what sets Excel apart is its flexibility, it gives us total creative control over our designs so if needed we could produce our own animated custom chart to tell the right story for our data.

Jul 27th 2026
5-12 Weeks
Excel Big Data Microsoft Excel
Details
Excel Regression Models for Business Forecasting (Coursera) Coursera
Macquarie University

Excel Regression Models for Business Forecasting (Coursera)

Business

This course allows learners to explore Regression Models in order to utilise these models for business forecasting. Unlike Time Series Models, Regression Models are causal models, where we identify certain variables in our business that influence other variables. Regressions model this causality, and then we can use these models in order to forecast, and then plan for our business' needs.

Jul 27th 2026
4 Weeks
Excel Business Strategy Regression Models
Details
Everyday Excel, Part 3 (Projects) (Coursera) Coursera
University of Colorado Boulder

Everyday Excel, Part 3 (Projects) (Coursera)

Computer Science

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, [Parts 1](https://www.mooc-list.com/course/everyday-excel-part-1-coursera) and [Parts 2](https://www.mooc-list.com/course/everyday-excel-part-2-coursera)". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways). Each learner must complete two easy projects (chosen from four), two intermediate projects (chosen from 4), and three main (more difficult) projects (chosen from 7).

Jul 27th 2026
5-12 Weeks
Computing Algorithms Spreadsheets
Details
Excel Basics for Data Analysis (Coursera) Coursera
IBM

Excel Basics for Data Analysis (Coursera)

Statistics & Data Analysis Data Science

This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. It includes plenty of videos, demos, and examples for you to learn, followed by step-by-step instructions for you to apply and practice on a live spreadsheet.

Jul 27th 2026
5-12 Weeks
Spreadsheets Excel Data Analysis
Details
From Excel to Power BI (Coursera) Coursera
Knowledge Accelerators

From Excel to Power BI (Coursera)

CS: Information & Technology

Are you using Excel to manage, analyze, and visualize your data? Would you like to do more? Perhaps you've considered Power BI as an alternative, but have been intimidated by the idea of working in an advanced environment. The fact is, many of the same tools and mechanisms exist across both these Microsoft products. This means Excel users are actually uniquely positioned to transition to data modeling and visualization in Power BI! Using methods that will feel familiar, you can learn to use Power BI to make data-driven business decisions using large volumes of data.

Aug 10th 2026
1 Week
Excel Data Analysis Microsoft Excel
Details
Foundations of Computer Science (Coursera) Coursera
LearnQuest

Foundations of Computer Science (Coursera)

CS: Software Engineering Computer Science

Welcome to Introduction to Programming: Visual Basic. In the course sequence you will learn to write programs that utilize both procedural and object oriented techniques to solve business problems. In the first course in the sequence we will provide you with a solid foundation in the computer science topics that are important to understand when programming Visual Basic. In courses two through four, we will role up our sleeves and start coding in Visual Basic. In these courses you need to have access to a computer that is running Windows, macOS or Linux with the .NET 5 installed. We will show you how to install .NET 5.

Jul 27th 2026
4 Weeks
Computing Algorithms Databases
Details