Analyze data in Microsoft Excel will provide you with immediate insights about your data. It uses artificial intelligence to quickly create summary reports and high-level visualizations. You can even directly ask it questions about your data using "normal" conversational language. Analyze data, is the new artificial intelligence feature built into Excel. It does a really good job in analyzing your data and giving you a summary.
Analyze data/Ideas feature is available in Excel for Office 365.
Simply click a cell inside your data range, and then click the Ideas button on the Home tab. Ideas in Excel will analyze your data, and return interesting visuals about it in a separate task pane.
Save time and narrow down your Ideas by selecting only the fields you want to see. You can also provide feedback about which fields are helpful to you and which are not. This way the system learns and will present fewer, more targeted suggestions in the future.
