Hi Excellers, time for some more #formulafriday fun.  This blog post is based on a question I was asked by a subscriber a few weeks ago and I thought it would be a good share it on...

Happy Friday Excellers.  If you use a To Do List in Excel like I do then here is a great way to highlight with some great but easy visualization, the status of your To List Activities. We can use...

It's Friday so that means some more Formula Fun.  Today let's look at calculating the percentage of cells in a range that contain a specific string.  I have used this to as an alternative to a...

Let's get back to basics today in #formulafriday and discuss something I am asked quite frequently about...... What is the difference between a Formula and a Function in Excel? If you use Excel as...

Hello Excellers, Friday again and I have a really quick, easy and really useful way to use  named ranges you have already created into  your formulas.  If you need more details on creating named...

Hello again Exellers, today let's look at 3 ways to remove the Days portion from a date in Excel.  This was an issue one of my collgeaues came across this week.  Let's take a look at the...