Advanced Microsoft Excel tutorials

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.

Correct data imported into Excel from a database

When you import data into Excel from a database, often dates and numbers will import as text. The issue is you can't analyze the data.

Create a break even analysis chart in Excel by Chris Menard

Break Even is when you making neither a profit nor a loss. This was a question from one of my MBA students. We will use the contribution margin

Conditional Formatting with two criteria using AND function in Excel

If you need to select an entire row using two conditions with Conditional Formatting in Excel, you need to write a formula using the AND function.

Use Conditional Formatting with groups in Excel

Can you use conditional formatting with groups of data in Excel by creating a helper column and using the IsOdd and IsEven function.

Protect a worksheet range in Excel

Need to make sure your formula or functions don't get deleted along with other information? You can protect a cell range in Excel.

Use Icon Set in Excel - just two arrows by Chris Menard

Present data in three categories using icon sets in excel. Each icon represents a range of values. I show how to use two arrows in this blog post.

Using Array Formulas in Excel by Chris Menard

Array formulas make checking your work and doing complex functions easier. If you constantly do countif functions, use the Array Frequency function instead.