Excel is the most frequently used tool for storing and working with the world's data. We are amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the grid and formulas to capture, analyze, and collaborate on data.
Until recently, Excel has only had a couple of base types of data you can work with, such as text and numbers. We have been on a multi-year journey to up-level the types of data you can work with natively in Excel, and you may have seen examples of this already. The first was the introduction of the Stocks and Geography “data types.” These linked data types meant for the first time, a single cell in the grid could contain a live, connected, and rich set of information about objects like stocks, currencies, cities, and countries.
Using one simple function that references the identifier you are looking for; you no longer need to decide what dimensions you want up front.
These more flexible structures give you the ability to organize complex data as objects and expose this data to users in more natural ways, while still providing easy access to the full information users care about for their analysis or reporting.
with Data Types, all the information related to a given item is stored with it allowing developers the freedom to re-imagine their experiences. This gives you all the data at your fingertips and puts you in control of your analysis so you can do it how you want when you want to.
Additionally, customers will be able to create their own add-ins, or extend previously existing ones to utilize the power of data types, resulting in a more integrated and next-generation experience within Excel. You can share the power of data types across your entire organizations and create add-ins or solutions which can connect data types to your own service or data.
with Data Types and custom functions, you can easily alter your query and see even more details than are shown in the immediate analysis. Additionally, rich images can be contained within the image and extracted at the click of a button.
With this new API, we are giving the ultimate power to end users and developers, allowing them to better organize, access, and work with their data. We hope you will try it out and share with us the unique solutions and applications you create!