Microsoft is launching a few more features in Excel 2019 that make all our favorite spreadsheet software a bit more powerful. For the first time, Excel will include capabilities that let teams work with machine learning algorithms inside the legendary spreadsheet software. Machine learning simply put, is the brains behind artificial intelligence and within Excel is a powerful method of data processing that lets algorithms find patterns in large datasets (aka Big Data). Combining the data visualizations from Power BI (Business Intelligence) app with the large audience of Excel, our students can start their first journey using machine learning as routinely as they learn about pivot tables.
Let’s dig into the first feature called “Insights”. Microsoft touts their new Insights feature to automatically and graphically presenting interesting trends information in their data. Imagine that you have a satellite business spreadsheet open to an Excel table of your fiscal year. By clicking the Insert tab and the Insights tool, a new panel appears on the right with four charts. The first four charts look like the first four from the Excel Recommended Pivot Tables. But there are 26 charts. If you scroll down, you start to see some detailed trends in the charts. These automated trend insights are powered by PowerBI visualizations and display changes that break away from normal trends (see image).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.