Scribd
Upload
779 views1 page

56 Power Query Tutorials

This document provides a list of 56 tutorials related to using Power Query in Excel and Power BI. The tutorials cover a wide range of topics including removing text between delimiters, handling errors, using variables, pivoting rows to columns, extracting data from lists and records, combining files with different column names, sorting columns, creating running totals, importing data from PDFs and web pages, and more. Many of the tutorials provide tips for using the Power Query advanced editor, custom functions, and accessing data sources like OneDrive, SharePoint, and APIs.

Uploaded by

mnry0627
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
779 views1 page

56 Power Query Tutorials

This document provides a list of 56 tutorials related to using Power Query in Excel and Power BI. The tutorials cover a wide range of topics including removing text between delimiters, handling errors, using variables, pivoting rows to columns, extracting data from lists and records, combining files with different column names, sorting columns, creating running totals, importing data from PDFs and web pages, and more. Many of the tutorials provide tips for using the Power Query advanced editor, custom functions, and accessing data sources like OneDrive, SharePoint, and APIs.

Uploaded by

mnry0627
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

56 FREE Power Query Tutorials

View in full screen to download and get links

Get Started with Power Query Remove Text Between Delimiters Fuzzy Matching in Power Query

Power Query if Statements incl. Nested Tips for Using The Power Query Handling HTTP Errors in Power Query and
ifs, if or, if and Advanced Editor Power BI

Power Query Variables 3 Ways Pivot an Unknown Number of Rows Extract Letters, Numbers, Symbols from
into Columns Strings with Text.Select and Text.Remove

Remove Blank Rows and Columns from IFERROR in Power Query Using TRY Static Tables in Power Query, Power Pivot
Tables in Power Query OTHERWISE and Power BI

Extracting Data from Nested Lists and Easily Compare Multiple Tables in Change Type Using Locale with Power
Records in Power Query Power Query Query

Combine Files With Different Column VLOOKUP in Power Query Using List Get Data from OneDrive or SharePoint with
Names in Power Query Functions Power Query

Power Query Keyboard Shortcuts to Secret Power Query Function List Sort-By Columns in Power BI
Save Time

Table Statistics from Table.Profile in Power Query Custom Data Types Extract Start and End Dates with Power
Power Query Query

Changing Data Source Location in Power Quickly Create Running Totals in Power
Query Query Referencing the Next Row in Power Query

Dense Ranking in Power Query Power Query Custom Functions Scrape Data from Multiple Web Pages with
Power Query

Create a List of Matching Words When Import Data from a PDF to Excel Power Query Get Data from Web by
Searching Text in Power Query Example

Searching for Text Strings in Power Connecting to an OAuth API Like PayPal
Query With Power Query Power Query Approximate Match VLOOKUP

Introduction to Power Query Getting Started with API’s in Power


Query Get Data from the Web with Power Query

Grouped Running Totals in Power Query Import Multiple Files Containing


Multiple Sheets with Power Query Numbering Grouped Data in Power Query

Power Query Consolidate Excel Sheets Excel Power Query VLOOKUP


I help you STAND OUT from the
crowd with my courses
Excel Power Query Add Column from Power Query and Power Pivot Definitive
Example Guide
Follow me for tips and tutorials

Power Query Get Files from a Folder Excel Compare Two Lists

Power Query Unpivot Scenarios Power Query Reformats Ugliest Report


Ever

Power Query Date Formats Power Query Version Compatibility and


Installation

Combine Excel Worksheets with Power


Power Query Unpivot
Query Mynda Treacy
Microsoft MVP
Transpose Data in Excel
Power Query Lists

You might also like