Hello Excellers, welcome to another #MacroMonday #Exceltip in my 2021 Excel series to use . Today's Excel Macro tip is a really simple but very effective time saver to trim extra spaces in Excel. I...
Posts by Barbara
Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function
Happy Friday, Excellers. Today let's look at how to generate a unique username in Excel using the COUNTIF function, even when you have duplicates! Welcome back for another #FormulaFriday in...
Macro Mondays – How To Assign Or Change A Macro Shortcut Key
Hello Excellers, time for some back to basics today with Excel Macros. Let's take a look at assigning or changing a shortcut key with a Macro. Yes, welcome back to another #MacroMonday blog...
Hello Excellers, Welcome to another blog post in my #FormulaFriday #ExcelTips series. Today I will show you how to create a Month to Year calculator in Excel. I have a sample file below to work...
Hello Excellers, welcome back to another #Exceltip blog post in my 2021 series. Today I will show you how to use flash fill to split your cells into separate columns. Yes, that is correct....
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...