Formula Friday – Need To Test Your Formulas? It’s Easy Just Hit F9!
Hello Excellers, time for some more formula fun. If you're an Excel user, you know that formulas are the key working smart with Excel. But what happens when you're not sure if your formula is...
First of all, hello, Excellers. A warm welcome back today for another #Excel Tip in my #FormulaFriday series. I share today a neat way to use the conditional SUM function with a...
Formula Friday – Use Concatenate Or & To Create Usernames In Excel
If you need to create a username in Excel for an account or login, here's a quick and easy way to do it in Excel. Simply use the concatenate In Excel function, or the & operator, to combine two...
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...
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...