Time for some more #formulafriday fun.  Today let's look at 2 ways to create a name range in Excel.  If you want to read more about using named ranges in your Excel formulas then you can read my...

Hi Excellers today let's flex our formula muscles and tackle a VLOOKUP question, how to carry out a VLOOKUP over multiple worksheets in the same workbook. Suppose I have three worksheets with data...

Hey Excellers, one of my favorite times of the week, #formulafriday time!.  Today let's look at avoiding Excel displaying a negative number after a calculation of stock items in an...

Hello and welcome again to #formulafriday.  Time for some more formula fun on a Friday.  Today we will be looking at using the NETWORKDAYS Function to work out how many days are left in a month...

Hi Excellers, welcome back to another blog post in my #formulafriday series. Today let's look at locating circular references in Excel really easily. Why would we need to do that?. Well, chances...

Hi Excellers, time for some more #formulafriday fun. Again this week 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...