Description:
Learn all methods of data selection using tools built into proper Excel Data Tables. Plus, witness real-life use cases with cool data return tricks.
File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_DataTableSelect.zip
Unthinkable Lookup Tricks (video link):
https://www.youtube.com/watch?v=zHqXlu72C1o
00:54 Working with Small Tables
01:23 File Download Instructions
01:29 Selecting Column Data (No Header)
02:23 Selecting Column Data with Header
03:11 Selecting the Heading Row Only
04:03 Selecting a Row of Data
05:00 Selecting All Data (Without Headings)
05:44 Selecting All Data with Headings
06:05 Practicals: Using Table References in Formulas
08:06 Using Table References with XLOOKUP
Share this link via
Or copy link























