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...
Recent Posts
Macro Mondays – How To Write A Macro To Delete Rows If A Cell Is Blank
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...
Formula Friday- Excel Tip- Generate Random Numbers With Excel.
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...
Macro Mondays – Limit The Scroll Area Or Range Movement In An Excel Worksheet
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...
Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel
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...