Power Query Courses and Certifications

Power Query Fundamentals

302 ratings at Corporate Finance Institute

Dive into the World of Power Query: Master the art of extracting data from multiple sources and automating the transformation of even the dirtiest data into clean, actionable insights

• Corporate Finance Institute
• 2 hours 41 minutes
• Self-Paced
• Paid Course

Power Query Fundamentals Case Study

58 ratings at Corporate Finance Institute

Put your Power Query skills to test with these seven different quick challenges

• Corporate Finance Institute
• 46 minutes
• Self-Paced
• Paid Course

Intermediate Power Query in Excel

Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Power Query Bootcamp

Master Power Query's essential features for streamlined data preparation in Excel and Power BI through hands-on practice with cleaning, transforming, and combining datasets.

• Noble Desktop
• Self-Paced
• $299.00

Coursera

Automate Excel Data with Power Query and Lookups

Master Power Query and advanced lookup formulas to build automated, scalable Excel reporting systems that clean data and create dynamic financial templates.

• Coursera
• 1 hour 30 minutes
• Self-Paced
• Paid Course

Advanced Excel Power Query-M language, troubleshoot, Pattern

665 ratings at Udemy

Learn more about Power Query M Language, ready-made patterns, advanced real life case studies, solution to PQ limitation

• Udemy
• 4 hours 21 minutes
• Self-Paced
• Paid Course

Master Microsoft POWER QUERY in POWER BI & Excel (ETL Tool)

572 ratings at Udemy

Learn how to import, transform and prepare data using the Query Editor in Microsoft Power BI

• Udemy
• 5 hours 5 minutes
• Self-Paced
• Paid Course

Advanced Excel: Power Query, Power Pivot and DAX

342 ratings at Udemy

Master Data Import, Cleaning, Modeling, and Analysis Using Power Query, Power Pivot, and DAX in Excel

• Udemy
• 4 hours 24 minutes
• Self-Paced
• Paid Course

ExcelIsFun

Allocate from Header Fact Table to Line Item Fact Table - Excel, DAX, Power Query or Power BI

Master allocation techniques from header to line item fact tables using Excel formulas, DAX, Power Query, and Power BI through comprehensive hands-on examples and comparisons.

• YouTube
• 2 hours 31 minutes
• Self-Paced
• Free Video

ExcelIsFun

Build Power Query Custom Function - Convert Multiple CSV Cross Tab Tables into Single Table

Master Power Query custom functions to transform multiple cross-tabulated CSV files into a unified table using M Code and advanced data transformation techniques.

• YouTube
• 18 minutes
• Self-Paced
• Free Video

Power BI Certification Program

132 ratings at Noble Desktop

Master data analysis and visualization with hands-on Power BI training, from connecting data sources to creating interactive reports and earning Data Analyst Associate certification.

• Noble Desktop
• 18 hours
• Self-Paced
• $1,899.00

Power BI Financial Statements

92 ratings at Corporate Finance Institute

A Scenario-Based Deep Dive into Power BI for Financial Statement Automation and Analysis Master the integration of SQL, Power Query, Power BI, Excel, and DAX for comprehensive financial data analysis

• Corporate Finance Institute
• 3 hours 20 minutes
• Self-Paced
• Paid Course

Case Study: Ecommerce Analysis in Power BI

In ecommerce, increasing sales and reducing costs are key. Analyze data from an online pet supply company using Power BI.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

ExcelIsFun

Approximate Match Lookup in Power Query - Amazing Functions for Power BI and Excel

Discover powerful approximate match lookup techniques in Power Query using custom functions. Learn to create efficient solutions with Table.SelectRows and List.Accumulate for Excel and Power BI data analysis.

• YouTube
• 14 minutes
• Self-Paced
• Free Video

ExcelIsFun

Master Power Query M Code and Data Shaping for Data Analysis

Master Power Query M Code for advanced data shaping and analysis. Learn M Code values, expressions, data types, operations, custom functions, and key functions like Table.AddColumn and Table.Group.

• YouTube
• 1 hour 50 minutes
• Self-Paced
• Free Video