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...

Today's blog post was actually a question from one of my colleagues at work earlier this week, they had a list of first and surnames of employees, separated by a comma, with the surname first and the...

Today let's look at how to use Excel keyboard shortcuts to see Precedent or Dependent Excel cells in an Excel workbook.  I use these two commands to easily audit my Excel formulas. Cells that are...

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...

Welcome, Excellers. Almost everyone who has used Excel has had to work with Pivot Tables at some stage. I will show you how to list all the calculated fields and items in your Pivot table in today's...