Microsoft has announced the evolution of Excel. New data types can be defined

Microsoft has announced the evolution of Excel. New data types can be defined

Microsoft has announced the launch of new features for Excel, an office spreadsheet application.

According to the developers, this is a real evolution of Excel – it allows you to turn Excel from a tool for working with data into an even “smarter” service that “understands” information.

New types of data are available in Excel that users can create from their own information. For example, you can import a structured array into a program and classify its type as “client”. To do this, you will need to publish your data to Power BI or use the Power Query add-in.

Until now, only a formula or a specific value could be entered in one cell. Now in one cell a much larger amount of information is placed, connected to various sources, which will change in real time. In order to work with this data, you do not need to constantly return to the source. For example, you can import data for Seattle and use a formula that contains information about the city’s population. If it changes, the value in the cell will also change. Thus, the user sees not just a number, but knows where it came from.

In addition, Microsoft is expanding its collaboration with the Wolfram Alpha Question Answering Service to give users access to previews of hundreds of new types of external data. Plus, new smart templates will help you get started quickly with these types of data. This allows users to add useful information to their analytics, such as chemistry, zip codes, nutrition, historical events, and even genetics.

Microsoft has announced the evolution of Excel. New data types can be defined

Leave a Comment