Power Query Courses and Certifications

ExcelIsFun

Power Query - Import Multiple Excel Files and Combine into Proper Data Set

Learn to import and combine multiple Excel files using Power Query, create a unified dataset, and build dynamic PivotTable reports with automated updates when new files are added.

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

ExcelIsFun

Power Query Introduction - Importing & Transformation Data in Excel & Power BI Desktop

Comprehensive introduction to Power Query for data importing, cleaning, and transformation in Excel and Power BI Desktop, with practical examples and hands-on exercises.

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

SQLBits

Power BI - Creating a Magical Date Table Using M Language

Explore M language techniques to create and manipulate columns in Power BI, building a date table from scratch for enhanced report design.

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

SQLBits

Managing Blanks and Nulls in Power BI

Master techniques for managing missing data in Power BI, from handling null values in Power Query to understanding blank propagation in DAX for optimized performance and accurate analysis.

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

ExcelIsFun

Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set

Learn to use Power Query in Excel for data cleaning, transformation, and analysis. Master importing, combining, and refreshing data from various sources to create proper datasets and pivot tables.

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

ExcelIsFun

Power Query Count & Extract Customer Names for 8 Sales Coupon Groups

Learn advanced Power Query techniques to analyze customer coupon usage across multiple stores, including counting and extracting customer names for various coupon groups.

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

ExcelIsFun

Standard Deviation with Criteria - Power Query, PivotTable, or Array Formula

Learn advanced Excel techniques for calculating standard deviation using Power Query, PivotTables, and array formulas. Master data analysis with practical examples and step-by-step guidance.

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

ExcelIsFun

Backwards One to Many Relationship Report - Excel, Power Query or SQL?

Learn advanced Excel techniques for calculating average GPA across related tables using array formulas, DAX, Power Query, and SQL. Master data analysis skills for complex relationships.

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

ExcelIsFun

Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns

Aprenda técnicas avançadas para limpar e transformar dados no Excel, incluindo fórmulas, Flash Fill, Power Query e Text to Columns, preparando-os eficientemente para análise.

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

ExcelIsFun

Text Formulas & Functions in Excel Worksheet and Power Query

Comprehensive tutorial on Excel text functions and Power Query, covering formulas, data extraction, error handling, and data cleaning techniques for efficient spreadsheet management.

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

ExcelIsFun

Date & Time Formulas & Functions in Excel Worksheet and Power Query

Aprenda fórmulas e funções avançadas de data e hora no Excel e Power Query, incluindo cálculos de dias úteis, atributos fiscais e manipulação de períodos para análises eficientes.

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

ExcelIsFun

Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas

Aprenda a criar análises estatísticas avançadas no Excel usando Power Query, fórmulas de matriz e gráficos Box & Whiskers para visualizar e interpretar conjuntos de dados complexos.

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

ExcelIsFun

Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions

Master PivotTables and Power Query for creating frequency distributions from various data types. Learn efficient techniques for data import, transformation, and analysis in Excel.

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

ExcelIsFun

Excel Data Analysis - PivotTables, Power Query, Formulas and Charts

Learn essential Excel data analysis techniques using PivotTables, Power Query, formulas, and charts. Master importing data, creating reports, and visualizing trends for effective business insights.

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

ExcelIsFun

Running Total in Column - Power Query, DAX or Worksheet Formula?

Learn to create running totals in Excel using worksheet formulas, Power Query, and DAX. Master expandable ranges and cumulative calculations for overall and monthly totals.

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