Microsoft has added support for custom data types to Excel. Thus, from now on, users are not limited to text, numbers, promotions or geodata. Now, for example, you can insert country-specific data into a cell and create a formula that extracts the most recent population figure from it.
Each cell can have references to other types of data, images, actions, and hierarchical data sets. Microsoft has added over 100 new data types to Excel using the Wolfram Alpha service. This allows users to track stock quotes, use food information to make diet plans, search for the right college, study chemistry, and more. This functionality is currently available to Office beta testers who are subscribed to the Insiders program.
Custom data types will be most effective for corporate clients who work in Excel on a daily basis. Microsoft uses the Power BI service for their tasks. It works as a connector for porting data sources to Excel data types on the commercial side. This allows businesses to import various data into tables. What’s more, they can convert existing cells to related data types, making data analysis much easier.
However, Power BI isn’t the only way to migrate data. Now when you import data into Excel, you can convert it to a data type using Power Query. This can include information from files, databases, websites, etc. The imported data can be cleaned up and then converted to a data type for use in spreadsheets. If you retrieved the data using Power Query, you can easily refresh it from the original source.
Power BI data types are available to Microsoft 365 / Office 365 users who use the Power BI Pro service. Power Query tool and data types will be available to all Microsoft 365 / Office 365 users in the coming weeks. Wolfram Alpha datatypes are already available to Office beta testers.