Advanced Microsoft Excel tutorials

Protect a worksheet range in Excel

Protect a worksheet range in Excel
Posted by Chris Menard on 02/14/2017

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

Use Icon Set in Excel - just two arrows by Chris Menard
Posted by Chris Menard on 02/11/2017

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

Using Array Formulas in Excel by Chris Menard
Posted by Chris Menard on 12/28/2016

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