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.
PS5 games prices are higher than Xbox — but is that a good thing?
Sony's PlayStation 5 reveal came with some big caveats, and one of the most overlooked ones is the fact that games will be more expensive, seemingly across the board. Should Microsoft and Xbox jump on that train as well?
Review: Gigabyte's Z490 AORUS ULTRA is a gorgeous Intel motherboard
Gigabyte's Z490 AORUS ULTRA is a motherboard you should consider for a 10th or 11th Gen Intel-powered PC. On paper, it has plenty going for it, including amazing power design and cooling, passively cooled M.2 slots and good overclocking support.
You can get the Windows 10 October 2020 update early – here's how
In this guide, we'll show you the steps to upgrade your computer to the final release of the Windows 10 October 2020 Update before it's officially available to everyone.
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.