Power Query: Combine Excel Files with Different Sheet Names (5 Dynamic Methods)
15:33
YouTubeBen Jones Explains
Power Query: Combine Excel Files with Different Sheet Names (5 Dynamic Methods)
Struggling with inconsistent sheet names when combining Excel workbooks in Power Query? If your queries are hard-coded, the whole process can break. In this advanced tutorial, I’ll show you 5 dynamic methods to reliably pull the right sheet every time — no matter what the sheet is called. What you’ll learn in this video: ️ How to spot ...
231 views4 months ago
Power Query Basics
Power Query Overview: An Introduction to Excel's Most Powerful Data Tool - Excel Campus
Power Query Overview: An Introduction to Excel's Most Powerful Data Tool - Excel Campus
excelcampus.com
May 13, 2020
Beginner's Guide to Excel Get & Transform / Power Query
8:50
Beginner's Guide to Excel Get & Transform / Power Query
YouTubeTechnology for Teachers and
194.9K viewsJun 8, 2020
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
28:07
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
YouTubeJosh Aharonoff (Your CFO
249.6K viewsJan 15, 2025
Top videos
Dynamic Column Names in Power Query - Goodly
9:23
Dynamic Column Names in Power Query - Goodly
goodly.co.in
Dec 9, 2019
How to Use a Named Range to Dynamically Switch Power Query Data Sources in Excel
19:34
How to Use a Named Range to Dynamically Switch Power Query Data Sources in Excel
YouTubeKeith Aul
1 views1 month ago
Power Query - Dynamically transform column names
8:13
Power Query - Dynamically transform column names
YouTubeBA Sensei
4.5K viewsFeb 29, 2024
Power Query Advanced Techniques
Advanced Power Query techniques - Advanced Power Query Video Tutorial | LinkedIn Learning, formerly Lynda.com
Advanced Power Query techniques - Advanced Power Query Video Tutorial | LinkedIn Learning, formerly Lynda.com
linkedin.com
Mar 7, 2025
IF Statements in Power Query M (Incl Nested IFs, OR, AND)
IF Statements in Power Query M (Incl Nested IFs, OR, AND)
gorilla.bi
3 viewsJan 1, 2021
Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel
10:40
Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel
YouTubeLeila Gharani
793.3K viewsOct 29, 2020
Dynamic Column Names in Power Query - Goodly
9:23
Dynamic Column Names in Power Query - Goodly
Dec 9, 2019
goodly.co.in
How to Use a Named Range to Dynamically Switch Power Query Data Sources in Excel
19:34
How to Use a Named Range to Dynamically Switch Power Query Data Sources in Excel
1 views1 month ago
YouTubeKeith Aul
Power Query - Dynamically transform column names
8:13
Power Query - Dynamically transform column names
4.5K viewsFeb 29, 2024
YouTubeBA Sensei
Dynamically Extract All Excel Table Names In A Workbook With Power Query - Master The Art!
4:27
Dynamically Extract All Excel Table Names In A Workbook With Power Query - Master The Art!
5.1K viewsJan 17, 2024
YouTubeOffice Universe
Using M to dynamically change column names in Power Query
18:46
Using M to dynamically change column names in Power Query
14.3K viewsOct 14, 2020
YouTubeExceed Learning
How to Use Named Ranges in Power Query - HowtoExcel.net
How to Use Named Ranges in Power Query - HowtoExcel.net
May 4, 2022
howtoexcel.net
Sheet Names in Excel | Cell Function | Power Query
8:46
Sheet Names in Excel | Cell Function | Power Query
3.3K viewsNov 11, 2020
YouTubeDatacense
7:12
Importing Data with Changing Column Names in Power Query
28.3K viewsFeb 5, 2019
YouTubeHow to Excel
12:29
Combine Data from Multiple Excel Files | Most Dynamic Method (Dynamic Columns & Sheets)
82.8K viewsAug 15, 2023
YouTubeGoodly
Dynamically List Excel Sheet Names • My Online Training Hub
Jul 16, 2020
myonlinetraininghub.com
Power Query Parameters: 3 methods 1 simple example
Sep 26, 2022
exceloffthegrid.com
1:45
Power Query - Combine Excel files with different sheet names
37K viewsMay 30, 2023
YouTubeAccess Analytic Learn
9:57
Create a List of Sheet Names using Power Query... With 2 ways Navigation
15.6K viewsApr 12, 2019
YouTubeOfficeinstructor
10:21
Create a Dynamic File Path - Change the Power Query Source Based on a Cell Value
73K viewsApr 2, 2022
YouTubeMiss Microsoft
Dynamic worksheet reference
May 12, 2024
exceljet.net
Change the Power Query source based on a cell value
May 9, 2020
exceloffthegrid.com
31:13
How to rename columns in Power Query that change the name on each data updating - T0029
24K viewsJan 7, 2022
YouTubeCelia Alves - Solve & Excel
How to get data from the Current Workbook with Power Query
Oct 6, 2022
exceloffthegrid.com
20:25
Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)
69.1K viewsSep 8, 2022
YouTubeLearn Google Sheets & Excel Spreadsheets
7:31
Power Query - Rename Column by Position
10.8K viewsSep 29, 2023
YouTubeBCTI
10:18
Rename columns in Power Query when names change | Excel Off The Grid
26.8K viewsJan 13, 2022
YouTubeExcel Off The Grid
12:13
3 ways of filtering data using dynamic lists - Power Query (Excel and Power BI)
18.5K viewsFeb 4, 2021
YouTubeGraciela @ Power GI
12:00
Selecting all Columns of a spreadsheet with Power Query does not get dynamic
3.2K viewsSep 16, 2018
YouTubeCelia Alves - Solve & Excel
11:56
How To Combine Excel Tables And Worksheets With Power Query
445.3K viewsMay 21, 2020
YouTubeExcel Campus - Jon
12:45
Expand columns dynamically in Power Query (THE RIGHT WAY!) | Excel Off The Grid
40.8K viewsMay 18, 2023
YouTubeExcel Off The Grid
4:30
Combine Worksheets & Keep Worksheet Names in Column in Power Query
12.8K viewsApr 25, 2021
YouTubeDoug H
6:53
Change the Power Query source based on a cell value | Data refresh automation | Excel Off The Grid
106.3K viewsJul 4, 2020
YouTubeExcel Off The Grid
14:23
Power Query Combine Files with Different Column Names - Super EASY!
104.4K viewsMar 3, 2022
YouTubeMyOnlineTrainingHub
1:08:38
Making queries dynamic in Power Query with Rick de Groot
9.5K viewsJun 22, 2024
YouTubeData BI
See more