Advanced Microsoft Excel tutorials

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.