Hello Excellers. Welcome to another blog post in my #Excel tips Excel series. Today's subject using Flash Fill in Excel. If you work with data in Excel, you know that you often need to...
Category: Blog
Formula Friday – Easily Calculate The Number Of Days Between Dates with the DAYS() Function
Hello Excellers. Welcome to another blog post in my #Exceltip blog post series. Do you ever need to know how many days are between two dates? If so, you can use the DAYS() function in Excel to make...
Count How Many Cells Have Negative Or Positive Numbers. (COUNTIF).
Hello Excellers and welcome back to another #FormulaFriday #Excel blog post in my Excel series. So, today I show you how to count how many cells have negative and positive numbers. In Excel, the...
Macro Mondays – Save An Excel Workbook When A Specific Cell Or Cells Change
Hello Excellers, welcome to another blog post in my #MacroMonday series. Today let's look at getting Excel to save our workbook as soon as a specific cell or range of cells is changed by a...
Formula Friday – Use The Search Function To Create A Search Bar In An Excel Cell.
Happy Friday Excellers Welcome to another blog post in my Excel #formulafriday series. . Today let's look at creating a search bar right in an Excel cell in our workbook. Yes, you can use the...
Macro Mondays – An Excel Macro To Count How Many Worksheets (Hidden And Visible) An Excel Workbook
Hello Excellers, time for some more #macromonday fun. I am excited to share with you some more Excel VBA code. Have you ever needed to know how many worksheets are in a workbook, specifically how...