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.
Everything we know about 'Xbox Series S' Lockhart
The Xbox Series X is getting a baby brother in the form of a console codenamed Lockhart, most likely to be called Xbox Series S. Here's what we know so far.
Amazon Prime Video for Windows 10 is now live and working
Last week, we reported that Amazon Prive Video was coming to the Microsoft Store. While the app could be downloaded, it did not yet work for customers. Today's app update, however, fixes that, and you can now stream (or download) all your Amazon Prive Video content to your Windows 10 PCs.
Grab one of these great CPUs for your custom PC
No matter what level of performance you're looking for, there's no doubt a processor (CPU) out there for your custom PC. And we've rounded up the best options right here.
10 must-have apps for any new PC
You just purchased a new PC and set it up, and now you're looking for some great apps. Look no further. These are the best apps for your new Windows 10 PC.