Power Query

Master Excel Power Query with this collection of step-by-step tutorials covering data import, transformation, cleaning, merging, filtering, automation, and ETL (Extract, Transform, Load) processes.

Learn how to connect to multiple data sources, automate repetitive tasks, reshape datasets, combine files, and refresh reports with a single click. Ideal for Excel users, analysts, accountants, business professionals, and anyone looking to streamline data preparation and build efficient reporting workflows.

Convert cross tab data to tabular data with Power Query tutorial showing data reshaping and unpivoting in Excel

UNPIVOT Columns in Power Query: Convert Cross-Tabs to Tabular Data

Learn how to transform cross tab reports into clean tabular datasets using Excel Power Query. This practical tutorial explains how to reshape data, unpivot columns, organize records into a structured format, and prepare datasets for PivotTables, dashboards, and reporting. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone who needs to clean complex reports and prepare data for efficient analysis.

Merge vs Append in Power Query Excel tutorial showing table joins row combinations and data transformation

Merge vs Append in Power Query: Combining Tables Explained

Understand when to use Merge and Append in Excel Power Query to combine and organize data efficiently. This practical tutorial explains how Merge joins tables using matching columns, while Append combines rows from multiple tables into one dataset. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone working with Power Query for data preparation and reporting.

Power Query Parameters Excel tutorial showing dynamic query inputs data transformation and automated data refresh

Power Query Parameters: Build Dynamic, Reusable Data Connections

Learn how to create and use parameters in Excel Power Query to make data transformation workflows more flexible and reusable. This practical tutorial explains how parameters can control query inputs, filter data, customize file paths, support dynamic transformations, and simplify recurring data refreshes. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone who wants to build more efficient Power Query workflows.

Import data from folder with Power Query Excel tutorial showing file combination data transformation and automated reporting

Import Data from Folder with Power Query: Combine Multiple Files Instantly

Learn how to import and combine data from multiple files stored in a folder using Excel Power Query. This practical tutorial explains how to connect to a folder, combine files, transform imported data, handle consistent file structures, and refresh the query when new files are added. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone who wants to automate repetitive data import and reporting tasks.

Power Query Conditional Columns Excel tutorial showing rules and logic for transforming and categorizing data

Power Query Conditional Columns: IF Logic Without Excel Formulas

Learn how to create and use conditional columns in Excel Power Query to transform and organize data more efficiently. This practical tutorial explains how to apply logical conditions, create custom results, categorize records, handle multiple criteria, and automate repetitive data transformation tasks. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone working with Power Query for data preparation and reporting.

DAX PATH and PATHCONTAINS functions in Excel tutorial for analyzing hierarchical parent child relationships and organizational data

DAX PATH & PATHCONTAINS: Work with Hierarchies (Employee Org Charts)

Work with hierarchical and parent child data more effectively using the DAX PATH and PATHCONTAINS functions in Excel. This practical tutorial explains how PATH creates a text representation of a hierarchy and how PATHCONTAINS checks whether a specific item exists within that hierarchy. Learn how these functions can be used to analyse organizational structures, employee reporting relationships, product categories, account hierarchies, and other parent child datasets. Ideal for Excel power users, data analysts, Power Pivot users, business intelligence professionals, and anyone working with hierarchical data models.

Power Query Pivot and Unpivot in Excel tutorial showing data reshaping table transformation and data preparation

Power Query: Pivot & Unpivot – Reshape Data Like a Pro

Transform messy Excel data into a clean and analysis ready structure with Power Query Pivot and Unpivot. This practical tutorial explains how to pivot rows into columns and unpivot columns into rows, helping you reshape datasets without complex formulas. Learn when to use each transformation, how to handle repeated values, preserve meaningful fields, and prepare data for reporting and dashboards. These techniques are especially useful for cleaning imported data and converting wide or narrow tables into formats that work better for analysis. Ideal for Excel users, analysts, accountants, finance professionals, and anyone working with data transformation and reporting.

Power Query web scraping in Excel tutorial showing website data import HTML tables data transformation and automatic refresh

IMPORTXML (Google Sheets) Equivalent in Excel: Power Query Web Scraping

Turn websites into structured Excel datasets with Power Query web scraping. This practical tutorial shows you how to connect Excel to web pages, identify and import HTML tables, transform and clean the extracted data, and load it into a worksheet for analysis. You’ll also learn how to refresh web data automatically, handle changing page structures, combine imported information with other datasets, and troubleshoot common web-import issues. Ideal for Excel users, analysts, researchers, accountants, business professionals, and anyone who needs to collect web-based data without manually copying and pasting.

Merge and automate Excel workflow tutorial showing Power Query data merging automated reporting dashboards and workflow automation

Merge and Report: Automate Your Whole Excel Workflow With Two Free Tools

Automate your end-to-end Excel reporting process by combining data preparation, transformation, analysis, and reporting into a single workflow. This tutorial explains how to merge data from multiple sources, clean and reshape datasets with Power Query, build relationships in the Data Model, create PivotTables and dashboards, and refresh everything automatically with minimal manual effort. Ideal for analysts, finance teams, operations professionals, business users, and anyone looking to save time and build scalable Excel reporting solutions.

Auto generate formatted Excel reports from raw data tutorial showing Power Query PivotTables automated reporting and formatted dashboards

How to Auto-Generate Formatted Excel Reports From Raw Data (Free Python Tool)

Transform raw data into professional Excel reports automatically with built-in Excel tools and automation techniques. This tutorial explains how to import and clean raw data, apply transformations with Power Query, summarize information using PivotTables and formulas, apply consistent formatting, and refresh reports with a single click. Ideal for analysts, finance teams, managers, operations professionals, and Excel users who want to eliminate repetitive reporting tasks and create reliable, presentation-ready reports.

Read data from SQL Server in Excel tutorial showing database connections Power Query SQL queries and data refresh

Read Data from SQL Server (Database Connection)

Connect Excel directly to SQL Server and work with live database data. This tutorial explains how to create a SQL Server connection, authenticate securely, import tables or custom queries, transform data with Power Query, refresh connections automatically, and build reports from database records. Ideal for analysts, database administrators, developers, finance teams, and business professionals who need to analyse SQL Server data in Excel.

Transform JSON data into Excel tables tutorial showing Power Query JSON import nested data expansion and table transformation

Transform JSON Data into Tables

Convert JSON data into organized Excel tables with Power Query. This tutorial explains how to import JSON files or API responses, expand nested objects and arrays, transform data into tabular format, clean and reshape records, and load the results into Excel for analysis. Ideal for Excel users, analysts, developers, data professionals, and Microsoft 365 users working with web services, APIs, or structured data sources.