Advanced Microsoft Excel tutorials

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.