Power Query Courses and Certifications

ExcelIsFun

Power Query Complete M Code Introduction - Values, Let, Lookup, Functions, Parameters, More

Comprehensive introduction to M Code in Power Query, covering values, expressions, functions, and advanced techniques for efficient data manipulation and analysis.

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

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

ExcelIsFun

Introduction to Power Query & Power Pivot Data Model in Excel 2016

Learn to clean data, create PivotTables, and use Power Query and Power Pivot in Excel 2016. Master data transformation, import large datasets, and build efficient data models for advanced analysis.

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

ExcelIsFun

Excel for Accountants - Power Query & PivotTables to Import & Clean Data and Build Reports

Learn to import, clean, and analyze data using Power Query and PivotTables. Master techniques for efficient data management, creating insightful reports, and optimizing file size in Excel for accounting purposes.

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

ExcelIsFun

Excel for Accountants - PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts Seminar

Comprehensive Excel seminar for accountants covering essential functions, PivotTables, data analysis, and Power Query. Enhance your skills with practical examples and real-world applications.

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

ExcelIsFun

Import Multiple Excel Files & Sheets into Excel - Power Query Get & Transform

Learn to import and combine multiple Excel files and sheets using Power Query, create PivotTables, and automate data updates for efficient analysis and reporting.

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

ExcelIsFun

Data Analysis Fundamentals - PivotTables, Power Query & Data Model

Master Excel data analysis with PivotTables, Power Query, and Data Model. Learn sorting, filtering, and advanced techniques to handle large datasets efficiently and create insightful reports.

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

ExcelIsFun

Power BI Desktop Comprehensive Introduction - Power Query, DAX, Dashboards, Publishing

Comprehensive Power BI Desktop tutorial covering data import, DAX formulas, dashboard creation, and report publishing. Master essential skills for effective data analysis and visualization.

• YouTube
• 1 hour 20 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

Introduction to Power BI

416 ratings at DataCamp

Master the Power BI basics and learn to use the data visualization software to build impactful reports.

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

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 - 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