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, it is time for some more formula fun on #formulafriday.  Today I want to share with you my Top 3 Reasons Not To Use Hard Coding In Excel Formulas If you want see see all of the blog...

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 Excellers.  I am excited to share with you some more Formula Fun, and in particular a checklist to double check your Excel formulas are on point!. Let's face it, formulas are awesome, but...

Hi Excellers, welcome to another Formula Friday.  Today I want to share with you a really quick way to tidy up your data and get rid of those pieces of data or indeed swap out pieces of data you do...

Hello Excellers, time for another Formula Friday.  Today let's look at calculating the percentage of the year that is completed and that is remaining really easily using the YEARFRAC function in...