Insights in Excel - Get automated, fast, accurate analysis of your data

Posted on:  03/05/2018
Insights in Excel - Get automated, fast, accurate analysis of your data

Insights in Excel – Game Changer for Data Analysis

What if I told you in Excel 2016 for Office 365, you can click on one cell and with two more clicks, have data analysis you would never dream of having? It’s here! Microsoft has updated Excel 2016 for Office 365 with Insights for Excel. Insight is discussed in the December 13, 2017, blog post from Microsoft. I’ve been waiting to get this since then and I received the update on Saturday, March 3, 2018. I spent two days testing Insights. It is incredible!

Insights relies on machine learning to help seek out patterns. In my test, it identified outliers, and quickly gave me other useful visualizations. It even took some of my data and automatically created a PivotTable and PivotChart. I simply clicked on Insights.

Steps to see Insights in Excel:

  1. Simply click a cell in a data range
  2. Click the Insights button on the Insert tab.
  3. Insight Services will analyze your data and return interesting visuals about it in a task pane on the right-hand side of your screen.

Menard tip: Make your data range a table first using CTRL + T. My free course on Ten reasons to use Tables in Excel.

Video On using Insights in Excel

The video above shows three test in Excel and one error message during the testing.

Photo Gallery of Screenshots

Below are 5 screenshots. The 1st image shows what Version and Build of Excel 2016 I have. I’m using Version 1803 (Build 9127.2004) on an Office 365 subscription. If you have a stand-alone (perpetual) version of Office 2016, you will unfortunately not have Insights and there are no plans for perpetual users to have Insights with Office 2016 as a stand-alone. I’m not sure if Office 2019, purchased with a perpetual license, will have Insights. Office 2019 is coming out H2 of this year.

To use Insights you need the following:

  1. Internet Connection
  2. Enough Data for Insights to Work. If you click Insights, you may get this message “We couldn’t find any significant patterns in your data to show as an Insight. Try using a larger dataset with more variation in it.” See the photo gallery above. From my three test, this is due to not enough columns. I had plenty of records. In fact, in the Video below you can see I had 576 records. I had to add some column data.
Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at chrismenardtraining.com/linked or watch his videos on YouTube at chrismenardtraining.com/youtube.

Categories