Hello Excellers.  I have decided to go Back To Basics today for today's #formulafriday blog post and take a look at relative and absolute references in Excel.  Why would I do that?. Well, a...

Excel formulas can be daunting, I know that - even if you have been been using excel for years, the formula part can be scary. The many text books on offer or courses really do get complicated...

Hello Excellers and welcome to another #formulafriday.  Today let's look at a an Excel function that can return a value from a range (a row or a column).  LOOKUP is one of Excel's lookup and...

Happy #formulafriday Excellers. Today we are going a little left of field, and looking at the really useful LEFT Function in Excel.  This a a really useful function to have in your Excel toolbox...

Hello Excellers, and welcome back to another blog post in my #Excel series. So, something a little different for today's #formulafriday blog. Instead of showing our Excel formulas, I...

  Hello Excellers time for some handy #formulafriday tips.  This week let's take a look at using the SUBTOTAL Function to easily number our rows in an Excel Table. You may want to number...