Microsoft announced a major update to Excel that brings the option to create your own data types. These data types can include live information that can greatly expand the functionality and relevance of data within spreadsheets. Excel can also work with Power BI and richly structured data within spreadsheets.
Microsoft shares context about data types in a new post. Previously, data was «two dimensional,» meaning that people could place numbers, text, and formulas within a grid. 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. In other words, single cells can now include structured data that can be referenced by other parts of the spreadsheet.
In this context, «rich» means that a single cell can have references to other data types, images, intelligent actions, and a collection of hierarchical data. Microsoft explains the value of this new functionality:
Now a cell can contain a vibrant data type; one cell, a world of possibilities. Data types allow you to bring the data you care about into the grid, in its most natural form and unleash the power of Excel to gain critical insights. With data types, a single cell value can have a live connected set of information you can quickly pull into your decision-making process, without needing to constantly go back to the original source to find more information. Leverage the card view to see more information on that data type, and navigate through to related information.
Microsoft shares an example of a spreadsheet that relies on population data for the city of Seattle. You could import a data type for the population of Seattle and then have formulas that utilize that information.
Excel can also work with business data powered by Power BI. You can connect Power BI data in Excel as data types.
People can also have data within Excel transformed into a data type with Power Query. This feature allows you to add information from websites, databases, and files.
Microsoft also announced a partnership with Wolfram, which allows hundreds of new data types to be used within Excel, though this is in preview at the moment.
Power BI data types are available in Excel for Windows for Microsoft 365/Office 365 subscribers that have a Power BI Pro service plan. Power Query data types will roll out over the coming weeks for Microsoft 365/Office 365 subscribers. The Wolfram Alpha data type functionality is available in preview for Office Insiders.
We may earn a commission for purchases using our links. Learn more.
Want the latest GPUs from NVIDIA? Here’s where to find them.
NVIDIA new Ampere-powered GeForce RTX 30-series GPUs are here, and as expected they’re selling fast. Here’s where you can find the new hardware.
Watch Dogs: Legion beginner tips and tricks for hacking London
Watch Dogs: Legion is the third entry into the open-world hacker game created by Ubisoft that engages the player in near-future London. Between all the bars, back alleys, side missions, and people to recruit, it can seem a little daunting on how to start out. Here is a handy run-down of some tips that will make your life a little more tolerable.
The Medium Interview: How the Xbox Series X|S made this title possible
Looking for some inside information on the upcoming psychological horror game The Medium? Well, here’s everything you need to know about the gameplay mechanics, haunting storytelling, and performance on Xbox Series X/S, straight from the team responsible.
Make the most of your Surface Pen and Slim Pen with these awesome apps
To really maximize the ability of the Surface Pen and Slim Pen, there are some essential apps you should check out. We’ve rounded up the best right here for a variety of purposes.
Vía Windows Central – Apps https://ift.tt/3oLkb5B