Microsoft announced today that it is using AI to bring new, richer data types to Excel. The first two of these data types, stocks and geography, will allow Excel to recognize automatically recognize a place or stock and serve up a rich set of data for it.
The new data types tap into the Microsoft Knowledge Graph, which is the same tech used to power Bing answers. "For example, Excel recognizes that "France" is a country and automatically associates it with additional attributes such as population and gross domestic product," Microsoft says. Once you have the extra attributes, they can then be used to populate other cells or implemented into formulas.
In addition to the new data types, Microsoft has updated Excel Online with some highly requested features from Excel desktop. Excel Online will now allow you to insert Pivot Tables and delete rows and columns to analyze and format data. Images can also now be inserted from local storage, existing worksheets can now be duplicated, and you can now change the color of tabs.
Elsewhere in Office 365 updates for March, Microsoft has started rolling out new features for Sharepoint. Personalized search, which was first announced last year, is now rolling out to all Office 365 users. Similarly, Office 365 users who are enrolled in Targeted Release can now check out SharePoint hub sites and Yammer feeds can now be added to any SharePoint or webpage.
The big deal here is the addition of the new data types in Excel, and, given Microsoft's current focus on AI, it's likely we'll see even more AI-powered features hit Office 365 apps in the future. The new data types are rolling out this month in preview for Office 365 commercial subscribers as part of the Office Insiders program.
We may earn a commission for purchases using our links. Learn more.
Why Daniel Rubino doesn't care if the Surface Duo's camera is terrible
Some of us live on the edge of tech, and that often means giving something up to gain something new. In the case of Surface Duo, that may mean living with a less-than-ideal camera.
Xbox Series X vs. PlayStation 5: Everything We Know So Far
A game-changing year lies ahead, with two of the world's biggest next-generation consoles expected to hit store shelves in late 2020. Here's what we know about Xbox Series X, in relation to the Sony PlayStation 5.
These great desktop PCs won't cost you more than $500
Need a pre-built PC and have about five bills in your pocket? Finding the right device can be tough, but we've rounded up the best options out there right now to help you decide.
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.