Equally important, this tool cannot be used on data that has been converted into a Pivot table. It is important to realize that Insights works best with clean, well-organized data that is free of nesting and blank rows and columns. In our simple example, the choices are fairly basic and not really all that enlightening.Īssuming you find a graph that meets your needs, you can click the Insert Chart link and the chart will be inserted into your workbook already formatted in presentable, albeit rudimentary, form ( Figure C). The quality and quantity of those choices will depend on the data being analyzed, of course.

When you click the Insights button, Excel will take a moment to analyze the data set and then present you with several graphical choices ( Figure B). Click the Insights button, which is defaulted to lie in the middle of the Ribbon ( Figure A). To apply Insights, highlight your data set in Excel (give it a label if you prefer) and then navigate to the Insert tab on your Office Ribbon. SEE: Artificial intelligence: Trends, obstacles, and potential wins (Tech Pro Research) Excel Insights This brief tutorial article shows you how to implement Insights and explains some of the difficulties you may encounter when trying to apply artificial intelligence to real-world data sets. Insights demonstrates both the promise of artificial intelligence and the elusiveness of its effective practical application.

However, getting the tool to actually provide useful information is a bit more problematic. Once Insights is installed, accessing it is as simple as clicking a specific button on the Office Ribbon. Must-read Windows coverageĭefend your network with Microsoft outside-in security services The tool promises to apply the power of cloud-based artificial intelligence and machine learning to your Excel data sets to reveal new patterns and hidden information that you may have overlooked. This new tool has been in preview for participants in the Office Insiders program for a few months but has now been released to everyone.

Microsoft is gradually rolling out a new feature for Office 365 subscribers called Insights in Excel.

Quick analysis button in excel 2016