Major innovations are coming to Microsoft Excel 2019.  It will add new more highly functional & richer data types and machine learning capabilities as documented below:

Microsoft Excel is about to get a lot smarter

Microsoft Excel users rejoice. Your favorite spreadsheet is about to get a lot smarter, thanks to the help of machine learning and a better connection to the outside world. Excel will soon be able to understand more about your inputs and then pull additional information from the internet as necessary.

“We’re pleased to introduce new data types,” Spataro explained. “That doesn’t sound all that interesting.  However, Spataro showed me how you will soon be able to tag a list of company names as — well — company names, for example. Once you’ve done that, Excel can pull in more information about the company from Microsoft’s Bing API, including stock data and market cap, for example. Excel can even automatically detect that a list of names is indeed a list of company names or a list of cities, for example, which then allows you to pull in population data, among other things.

“Historically, Excel has always been good at numbers and you can enter in text and use conditional formatting and things like that,” Spataro said. “We are adding the idea that Excel can now recognize data types that are richer than those two.”

In addition, the Office team is also launching a new built-in tool for Excel that will automatically try to pull the most interesting data from a spreadsheet and visualize it. The “Insight Service,” as the company is currently calling it, is modeled on a very similar feature in the Power BI data visualization and analysis tool, and it’s worth noting that Google Sheets also offers a comparable tool. “It is meant to take any list of data and then start to generate insights,” Spataro said. “It will look at combinations, charts, pivot tables and it will recognize those that are most interesting by looking at outliers, looking at trends in the data, looking at things that represent changes.” If you like one of the graphs the service generates, you can easily import those into your Excel sheets and manipulate them to your heart’s content.