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

Duke University

Business Metrics for Data-Driven Companies (Coursera)

Management & Leadership Statistics & Data Analysis

In this course, you will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data. You’ll get a clear picture of the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies. And you’ll know exactly what skills are required to be hired for, and succeed at, these high-demand jobs.

Sep 21st 2026

4 Weeks

Excel Data Analysis Microsoft Excel

Coursera

University of California, Irvine

Business Intelligence and Visual Analytics (Coursera)

CS: Information & Technology

Building on “Data Warehousing and Business Intelligence,” this course focuses on data visualization and visual analytics. Starting with a thorough coverage of what data visualization is and what type of visualization is good for a given purpose, the course quickly dives into development of practical skills and knowledge about visual analytics by way of using one of the most popular visual analytics tools: SAS Viya, a cloud-based analytics platform. An overview of cloud architecture, automation, and machine learning is also provided.

Sep 21st 2026

4 Weeks

Machine Learning Business Intelligence Data Visualization

Coursera

Whizlabs

AWS: Task Automation and Network Integration (Coursera)

Security & Networking

AWS:Task Automation and Network Integration is the second course of "Exam Prep ANS-C01: AWS Certified Advanced Networking Specialty" specialization. This ANS-C01 course will help in evaluating automation alternatives within AWS for network deployments. Learners will also have chance to configure network integration with application services.

Sep 21st 2026

2 Weeks

Integration Automation Network Security

Coursera

Duke University

Data Visualization and Communication with Tableau (Coursera)

Statistics & Data Analysis Data Science

One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand. In this course you will learn how to become a master at communicating business-relevant implications of data analyses.

Sep 21st 2026

5-12 Weeks

Excel Communication Computer Graphics

Coursera

University of Colorado Boulder

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

CS: Theory CS: Programming

Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and 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).

Oct 5th 2026

4 Weeks

Algorithms Spreadsheets Excel

Coursera

Duke University

Mastering Data Analysis in Excel (Coursera)

Statistics & Data Analysis Data Science

Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel for its own sake. We use Excel to do our calculations, and all math formulas are given as Excel Spreadsheets, but we do not attempt to cover Excel Macros, Visual Basic, Pivot Tables, or other intermediate-to-advanced Excel functionality. This course will prepare you to design and implement realistic predictive models based on data. In the Final Project (module 6) you will assume the role of a business data analyst for a bank, and develop two different predictive models to determine which applicants for credit cards should be accepted and which rejected. Your first model will focus on minimizing default risk, and your second on maximizing bank profits.

Sep 21st 2026

5-12 Weeks

Business Excel Data Analysis

Coursera

Starweaver

Supply Chain Management for E-commerce (Coursera)

Business

Immerse yourself in the dynamic realm of e-commerce supply chains with our course, "Supply Chain Management for E-commerce." Designed for emerging entrepreneurs, small business owners, and career switchers, this immersive journey equips learners with comprehensive insights. From foundational supply chain components to the strategic integration of technology and sustainability, participants will gain practical knowledge to navigate challenges and optimize operations in the e-commerce realm.

Sep 28th 2026

1 Week

Sustainability Logistics Supply Chain Management

Coursera

Macquarie University

Excel Skills for Business: Advanced (Coursera)

Business

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.

Sep 21st 2026

5-12 Weeks

Spreadsheets Excel Microsoft Excel

Coursera

Universidad Austral

Excel aplicado a los negocios (Nivel Avanzado) (Coursera)

Statistics & Data Analysis Data Science

Objetivos Generales: Al finalizar el curso, podrás: 1.- ENTENDER y profundizar convenientemente aspectos específicos de diferentes formas de trabajo (individual o grupal), 2.- EVALUAR el uso de funciones avanzadas para manipular datos y CREAR tus propios análisis utilizando técnicas específicas tales como tablas dinámicas, análisis de hipótesis, administración de escenarios, tablas de simple y doble entrada, análisis de optimización de recursos. 3.- ANALIZAR cómo vincular Excel con otras aplicaciones importando información desde archivos de texto y bases de datos, exportando información a archivos de texto de diversas formas. 4.- ENTENDER el uso de macros lo que te permitirá vislumbrar otro universo de aplicaciones que harán mucho más productiva tu labor.

Oct 5th 2026

5-12 Weeks

Business Hypothesis Excel

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.

Sep 21st 2026

5-12 Weeks

Spreadsheets Excel Data Analysis

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

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.

Sep 21st 2026

5-12 Weeks

Excel Big Data Microsoft Excel