Download Excel File: https://excelisfun.net/files/EMT1734.xlsx
Learn how to:
1. (00:00) Introduction
2. (00:19) Power Query Create Data Types
3. (01:46) Records in Cell. View Car. Add Column
4. (02:07) Data Validation to select a full record in a cell!
5. (02:33) Lookup element from records using Dot Operator.
6. (03:02) SUM a fully collapsed column with Dot Operator.
7. (03:35) Lookup a Column with the Dot Operator.
8. (03:52) Summary, Closing and Video Links