Microsoft Office Blog by Chris Menard

Webinar of Insights in Excel – Recording of live webinar

Insights in Excel: Insights will analyze your data and return interesting visuals about it in a task pane.

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

Insights in Excel is a new feature of Excel 2016 with an Office 365 subscription that give you fast, automated, insightful analysis of your data.

Excel – lose subtotal within subtotals in a PivotTable

Excel’s PivotTables are great, but sometimes we get subtotals within subtotals and you want to lose only the 2nd subtotal.

Extract email addresses from a text string in Excel

Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses.

Ten reasons to use Tables in Excel

There are over 10 reasons to use Tables in Excel instead of a data range. Here are five reasons along with a training video. There is part of the free course I created for the GSCPAs.

Deselect with the CTRL key in Excel

The CTRL key is used to select non-adjacent ranges which is a handy feature for charts and summing ranges. You can now deselect with the CTRL key. Huge improvement in Excel.

Excel Functions for HR Professionals

HR Professionals have a lot going on. Recruitment, benefits, compensation, and retention just to name a few. Here are Excel functions you should know. SHRM