But just seeing which pieces of data don't fit with the rest can help you to quickly spot anything unusually good or worryingly bad. These are some of the basic features from Power BI - they use the same AI, but because your Excel spreadsheet probably doesn't have a complex data model defined, which most Power BI data sources do, the results won't be as in-depth. You'll then see a task pane with all the suggested charts for trends, outliers, correlations and PivotCharts for what's interesting in your data, with the chart type automatically chosen and the axes, labels and titles all filled in.
In theory, all you have to do is select one or more cells and then click the Ideas button on the Home tab of the ribbon. The new Ideas button in the Office 365 subscription versions of Excel will actually make the visualisations and charts for you, and show trends and outliers in your data.
