Webinar of Insights in Excel – Recording of live webinar

Posted on:  03/15/2018
Webinar of Insights in Excel – Recording of live webinar
  • Webinar Date: 3/15/2018
  • Host: Chris Menard – Microsoft Trainer in Atlanta, GA

Prep until 3:31 – Live Webinar on Insights in Excel from March 15, 2018. Insights in Excel came out in December 2017 and is slowing rolling out to Office 365 subscribers. I received it in March 2018.

TimeStamps of the video

  • 03:21 Webinar Starts
  • 04:06 Insert / Insights / Task Pane
  • 05:29 Blue line chart becomes PivotChart on a new worksheet! Really cool.
  • 07:34 Bug in Insights. The chart does not update if you add records.
  • 09:39 – Insights test on a lot of data with only 4 columns. It didn’t pick up the months.
  • 10:20 Two PivotCharts created with Insights.
  • 11:45 Added two functions, Year and Month, to data since Insights isn’t picking up months.

Insights uses your data and immediately shows you Charts and PivotCharts you can use. To use a Chart / PivotChart, simply click on Insert. An Internet connection is required for Insights to work.

Per Microsoft’s blog – Insights in Excel

Dec 2017 – Insights is a new service that automatically highlights patterns it detects, which makes it easier for everyone to explore and analyze their data. Powered by machine learning, Insights helps identify trends, outliers, and other useful visualizations, providing new and useful perspectives on data.

********

I’ll be doing another live Webinar in April 2018 on Insights again. I’ll add some new material to that webinar. Feel free to email me if you have any questions.

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 https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories