If you're new to Excel, you may be wondering what the NOT function is and how it can help you. The NOT function in Excel is one of Excel's logical functions.  This function helps check if one value...

Hello Excellers.  If you're an Excel user, you know that one of the most tedious tasks is deleting rows if a cell is blank. Well, worry no more! With a simple macro, you can delete any number of...

Do you need to generate random numbers for a project? Excel can help. This guide will show you how to use the RAND and RANDBETWEEN functions to create random numbers in Excel. You can also learn some...

It's Macro Mondays time again. Have you ever been working on an Excel spreadsheet and had the scroll bar just go crazy, making it hard to navigate to the cells you need? Well, there is a way to...

Hey All, it's Formula Friday again. Today let's look at a handy little formula called DATEDIF.  DATEDIF is a function in Excel that calculates the difference between two dates. It can be used to...

Adding a drop down list to your Excel sheet is a really great and convenient way to allow data entry to your Excel worksheets whilst maintaining good quality consistent data and reducing the amount...