Happy Formula Friday, Excellers. Formulas are a huge part of Excel, and they can be very helpful in organizing and analyzing data. However, sometimes you may need to hide them from view so that your...

Hello Excellers. Welcome to another blog post article in my #Excel series. When you create a formula in Excel, you may expect to see the result of that formula immediately show up in the cell where...

Hello Excellers,  it is time for some more cool code in the #macromondays series. It can be a pain to remember to protect your worksheets every time you close your Excel workbook. But with a few...

Happy Friday Excellers.  Today I want to share with you how to RANK a data set with the rank formula in Excel, but ignore zero values.  I use RANK a LOT, and sometimes you just do not want to...

Do you have a column of data in Excel where the spaces at the beginning of each row are causing problems? For example, that space is causing your text to wrap to the next line and making it difficult...

Happy Friday Excellers time for more #formulafriday fun.  Today let's look at using the DAY() function. In Excel, the DAY function calculates the day of the month for a given date. This function is...