Happy Friday and time for more FORMULA FUN on #FORMULAFRIDAY. This article will use the COUNTIFS Function in Excel to calculate how many people are working at the same time in a retail store. Use...
Tag: Excel Tips
Convert Positive Numbers To Negative Numbers Using Paste Special Trick
Hello Excellers, welcome back to another #Exceltips blog post in my 2021 series. I wanted to share this Excel tip with you as it really is a fast way of converting a list of positive Excel numbers...
Formula Friday – How To Delete Values From Cells But Keep Your Formulas In Excel
Hello, Excellers. Welcome back to another #ExcelTip blog post in my Excel 2021 series. It is time for a neat Excel trick today in today's #formulafriday blog post. I will demonstrate how to...
Macro Mondays – Convert A Range Of Cells To Upper Case With An Excel Macro
Hello, Excellers. Welcome back to another #MacroMonday blog post in my #ExcelTips series for 2021. You may or may not already know how to convert all text to upper case in Excel by using the UPPER...
Hello, welcome back to another blog post in my 2021 series. I want to share with you a favourite Excel tip of mine. I think you will like this Excel formula bar tip. This Excel tip is...
Formula Friday – How To Highlight All Cells Containing A Formula In Excel
Hello, it is time for some more #formulafridayfun. Today I want to share with you how to highlight all cells containing a formula. It is a question a colleague asked me this week. It was a great...