Excel 2024: Create Your Own Data Types

Data types sound great, but wouldn't you like to have your own company data as a data type? Imagine if you had your company product list in a data type. You could store the SKU in a column and then extract item information using XLOOKUP or dot formulas such as =A2.Country.

There have been three solutions from Microsoft that allow you to do this. Power Query was first. Then Power BI. Then a Javascript API. I've tried them all. I want these to work just like real data types do. Here is my wish list and how PQ (Power Query), PBI (Power BI), and API (JavaScript API).

So far, the best experience is JavaScript API. Here are three videos, one for each method.