Power Query - 7 Methods to Get Data From Excel Files
Learn 7 ways to extract data from Excel files. This comprehensive video demonstrates techniques for extracting data from plain tables, data tables, named ranges, print areas, file scanning. You also learn how to combine data spread across multiple sheets in a single file, as well as when spread across multiple files.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
Link to "Rename Columns by Position" video:
• Power Query - Rename Column by Position
Link to "Avoid Helper Queries" video:
• Power Query - Avoid "Helper Queries" (+10 ...
01:18 Get Data From a Plain Table
02:10 A Quirk of the Plain Table Import Process
02:54 Get Data From a Data Table
03:54 Get Data From a Named Range
04:44 Preventing an Unwanted Table Upgrade
05:13 Get Data From Print Areas
06:05 Get Data by Scanning a File
08:25 Get Data From Multiple Sheets (Same File)
15:08 Creating Dynamically Named Columns
18:43 Get Data From Multiple Sheets (Many Files)
21:30 Extract Binary's Content Without Using Helper Queries