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.
These are the best 27-inch monitors money can buy
A 27-inch monitor is just about the perfect size without having to sit too far away or whip your head back and forth to follow things across the screen. If you’re in the market for a new monitor, check out our top picks.
Add or upgrade the RAM in your MSI GE66 Raider with this guide
Have an MSI GE66 Raider without enough memory for your needs? Our guide walks you through what's needed to upgrade the RAM in your laptop.
The Razer Tomahawk is small in stature, but mighty in power
Razer has a new gaming PC on the scene, and this time it's a compact desktop. The Razer Tomahawk Gaming Desktop uses a variation of the Tomahawk case to bring a modular, powerful PC that's designed to take up very little of your desk space.
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.