Excel is eventually going to recognize over 100 new data types. Microsoft has not yet said what all of those new data types will be, but it did confirm that one of the data types will be food.

You can access all the data type’s information just like you would traditionally write a formula in Excel. If you type A1.population into the cell B2, it would output 2,731,571.

Microsoft is bringing more than 100 new data types into Excel for Microsoft 365 Personal or Family subscribers. Excel users will be able to track stocks, pull in nutritional information for ...

This created data type can then be used for further analysis in Excel. Microsoft included a very good in-depth demo on how Power Query custom data types are created, and how they can get used, in ...

Microsoft adds a new Copilot function to Excel, letting users generate, analyze, and summarize data directly in spreadsheet ...

The Knowledge Graph already powering Bing and Excel data types. It's this cloud-connected/Knowledge Graph connection that is behind Microsoft describing these new datatypes as AI-infused.

These types of data can create complex spreadsheets, but they do have limits. Now, Microsoft has added a third dimension to Excel, allowing any cell to include a rich set of structured data.

Microsoft Excel used to only allow two types of data: text and numbers. After overhauling Excel with its own live custom data types last year, Microsoft is opening up Excel to give developers the ...

The geography and stocks data types allow users to pull information from Microsoft’s extensive Knowledge Graph and insert it inside their spreadsheets. The general idea is to make Excel smart ...

Microsoft Lists assumes that the leftmost column is a Title data type — it’s the default column. Depending on how you use your Excel sheet, its structure might not reconcile with Lists ...