Seems that Microsoft’s integration with AI seems to be never-ending. Recently, Microsoft has added the new AI-powered data types to Excel, to provide customers a quick access to extensive information about companies and places. However, this is still in the beta stage. So, with the Stocks and Geography data permits users to draw information from the Microsoft Knowledge Graph by simply referencing the entities by their name.
Like, for example, with this, customers could write out a list of cities, then press the Geography button. After this, users would be able to see those names associated with all of the data Microsoft has made available on the location inside Excel, without changing the apps.
Further, these new data types provide customers with more information other than just the names of stocks and places. In fact, it’s also possible to query other information about those entities inside Excel in order to build more detailed reports. For example, users can also create a spreadsheet that lays out a list of places, complete with their area, population, and median income, without leaving the program.
This is, in particular, would be extremely beneficial to Stock investment ventures, like the Share Khan in India, whose work becomes much easy now.
Also, Microsoft’s new features help it compete against Google, which is using its own AI expertise to make G Suite more appealing.
AI also helps Excel parse users’ input, reducing ambiguity in messy inputs. For example, including “Portland” in a list of cities would either lead the software to refer the city in Maine or the one in Oregon, depending on the context of its neighbors. In case Excel is unsure, it would also ask a user to choose from a list of places.
Again, to access all the information about a particular entity that’s stored in the Microsoft Knowledge Graph, users type a cell number, add a dot, and then choose from a drop-down list of attributes, similar to the way they’d select a function. Customers can also invoke those attributes for filters, charts, and pivot tables.
Other than these, users can also use a refresh function to pull the latest data, which is particularly important for data about stocks that can change frequently.
Latest update states that Microsoft would start rolling the feature out to members of the Office Insider Program and then start rolling the features out to Office 365 subscribers, starting with those with Commercial accounts and U.S. English, over the next few months. To this, Rob Howard, Director of Office 365 Ecosystem Marketing, added that “We’re starting to add concepts inside cells, which will allow new things to be done with spreadsheets”.