Hello Excellers, welcome back to another #Excel tip in my 2021 series. Today I will show you how to unprotect multiple Excel worksheets quickly. Have you created an Excel workbook with...
Archives: Blog
Hello Excellers, welcome back to another #MacroMonday blog post in my 2021 series. Today I will show you how to create your very own Excel Function. This Excel function will allow you to extract...
Find The First And Last Occurrence Of A Value With MINIFS and MAXIFS Functions.
Hello, Excellers. Today's blog post will show you how to find the first and last occurrence of a value. I recently used this method to query the first and last dates that a product appeared in my...
Hello, Excellers. Welcome to another blog post in my Excel series. Today I will show you how to create a fun Excel Waffle Chart. Unfortunately, Excel does not have a Waffle chart in the charting...
Use The Status Bar To Find The Maximum Value In Your Excel Data Set WITHOUT a Formula.
So, Hello Excellers, and welcome back to another #formulafriday blog post. Today is a little different as this blog post centers in the Excel status bar. That is correct, We will not be...
Hello Excellers, welcome back to another blog post in my #Excel #MacroMonday series. Today let's write our own Excel macro function that will generate a random string of characters. This random...