Microsoft Excel Blog: Tutorials and How-Tos

Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.

Posted by Chris Menard on 10/14/2018

Merge & Center in Excel is evil. I recommend you never use it. Merge & Center causes issues with sorting, removing duplicates, and selecting.

Posted by Chris Menard on 07/04/2018

One of Excel 2016's best features is Get and Transform data using the Power Query Editor on the Data tab. It changes crosstab data to flat data.

Posted by Chris Menard on 06/09/2018

The sunburst chart or multi-level pie chart is ideal for displaying hierarchical data. This short tutorial shows you how to create one.

Posted by Chris Menard on 03/25/2018

Need to group numbers in Excel? Shown are three methods for grouping numbers.

Posted by Chris Menard on 03/19/2018

Posted by Chris Menard on 03/15/2018

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

Posted by Chris Menard on 03/11/2018

Posted by Chris Menard on 03/05/2018

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.

Posted by Chris Menard on 03/01/2018

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

Posted by Chris Menard on 02/25/2018

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

Posted by Chris Menard on 02/19/2018

Posted by Chris Menard on 02/09/2018