Preview the New Insights Feature in Excel

Calling all Insiders! Have you or has someone you know ever struggled to make sense of the data in a workbook? Analyzing trends and patterns in your data can be a complex task.

The Excel team has been working to make data analysis radically easier with a new feature we're calling Insights, and we're ready to give you a preview! Insights analyzes data and its structure and automatically generates a series of recommendations - useful ways to make sense of the data - including high-level summaries, statistically significant findings, and recommended visualizations. With Insights, users can leverage the full power of Excel PivotTables and PivotCharts.

This is an early peek at a feature that will evolve and improve over time. We are sharing Insights with the community as early as possible to learn from real-world use, hear your feedback, make improvements, and work with this community to meet your needs!


to watch your insider look at Insights

Using Insights
Insights is currently available in EN-US; we're actively working on localization work.

Getting Started is easy:

  1. Open Excel (Win32-only for now!)
  2. Open a spreadsheet with tabular data in the grid
  3. Find the button in the Insert tab
  4. Run Insights!
  5. Use the feedback mechanism on each insight to let us know if it was or wasn’t useful - this is an essential part of us learning from our customers.

To learn more about Insights, check out Insights in Excel

Tips for Using Insights

Insights works best when run on clean, tabular data, such as an Excel Table.

Some tips for getting the most out of Insights:

  • Data with 5 or more columns and 100 or more rows, as well as a mix of numbers and strings, tend to work best with Insights today, but please try it out on any data you'd like to analyze!
  • Insights only works on data in the grid today. We hope to support multi-dimensional data (such as cubes and data models) in the future.
  • Avoid blanks, duplicate names, or nesting in headers.
  • Merged cells, error values, or badly typed data (e.g. numbers or dates stored as text) do not currently agree with Insights.
  • Insights don't work in compatibility mode, so .xls files need an upgrade to work with Insights.

Insights Preview in Excel is rolling out to Office 365 commercial subscribers, enrolled in Office Insiders, in the United States of America. Check out how to become an Office Insider to get the latest updates.

If you want to stay connected to Excel and its community, read Excel blog posts, and send us ideas and suggestions for the next version of Excel through UserVoice. You can also follow Excel on Facebook and Twitter.


Source: Preview Effortlessly discover Insights in your data - Microsoft Community