Advanced Microsoft Excel tutorials

Sunburst Chart in Microsoft Excel

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

Group Numbers in Excel and IFS and FormulaText functions

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

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.

Break-even analysis in Excel with multiple products

Create a break-even analysis with multiple products in Excel. Create a contribution margin income statement using a product mix.

Vlookup vs Index and Match in Excel

Vlookup is a powerful function but even better but less frequently used is Index and Match. Explained are two reasons to use Index and Match over Vlookup.

Calculate weekly revenue using PivotTables or Vlookup

Need to calculate weekly revenue or orders in Excel? You either Vlookup or PivotTables. PivotTables have a grouping features that will calculate it.