File Download: https://www.exceluniversity.com/yt_9...

This video shows how to use Power Query to generate a list of files in a folder and any sub folders. It shows how you can filter that list if you only want to include certain files or file types. Then it shows how to use the full file path with the HYPERLINK function to create a unique hyperlink to open each file in the list.
Power Query
Merge Column
HYPERLINK



Chapters in this video
00:00 Introduction
00:15 Power Query
01:26 Merge Columns
02:40 HYPERLINK

Unlock hidden Excel tricks and hacks, and become a timesaving Excel pro exceluniversity.com/challenge⚡ Say goodbye to late nights and spreadsheet struggles!

Subscribe here https://www.youtube.com/c/ExcelUniver... and turn on all notifications for MS Excel time hacks that will make you more productive!

Also, check out these videos with time saving Excel Hacks:

Excel PivotTables for Beginners (2023)    • Excel PivotTables for Beginners (2024)  

Watch VLOOKUP Hacks Playlist here    • VLOOKUP Hacks Series  

Watch VLOOKUP vs SUMIFS Playlist here    • VLOOKUP vs SUMIFS Series  

Watch Dynamic Arrays playlist here    • Dynamic Arrays Series  

Watch Treasure Maps playlist here    • Treasure Maps Series  

Watch Slow to Fast playlist here    • Slow to Fast Series