Microsoft Excel & Power Query - Dynamic Plain Table Ranges (Using TRIMRANGE - Dot Operator)

Learn how to create a Dynamic Named Range, using the TRIMRANGE (dot operator), when working with plain tables. This will aid in detecting added or removed rows from the data.

File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_DynPlainTbl.zip

"Microsoft Excel Modes - F2 Key" (video link):
https://youtu.be/JWiCHQJ9x9c

00:18 Bringing the Data Into Power Query
00:42 Demonstrating the Issue with Plain Tables and Added Data
01:07 Dealing With the Unrequested Table Upgrade
02:13 The "Failure" When Adding New Data
02:39 The "Old Way" of Creating a Dynamic Named Range
03:26 Understanding TRIMRANGEs (Dot Operator)
04:57 Adding a Dot-Operated Name Range
05:48 Navigating Through References
06:37 Losing the Name Box Dropdown Entry
07:05 Brining a Dynamic Named Range into Power Query
08:05 Testing for Newly Added Rows
08:39 Process Recap

Видео Microsoft Excel & Power Query - Dynamic Plain Table Ranges (Using TRIMRANGE - Dot Operator) канала BCTI