Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know...
Hello Excellers and welcome back another #FormulaFriday #Excel blog post in my 2020 Excel series. I will share a solution to a question asked recently. How to find how many numbers in your list...
Formula Friday – Quickly Switch From Cell Values To View Formulas – An Excel Shortcut
Happy Friday Excellers!. Welcome to another #FormulaFriday #Excel blog post in my 2020 Excel series. I have a great tip for you. It is really short, but it allows you to quickly toggle...
Formula Friday – Copy Formula Down When Formula Is Not Directly Next To Your Data Set
Hello Excellers, and welcome another #FormulaFriday in my #Excel 2020 series. I just love this Excel formula trick, It is a really quick way to copy a formula down a column when the formula is not...
Macro Mondays – How To Run An Excel Macro Automatically When You Open Your Excel Workbook
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. So, today I will show you a number of different ways to automatically run a VBA macro when you open...
Formula Friday – Flag Multiple Matches In Your VLOOKUP Formula
Hello Excellers, yes it is #FormulaFriday again. Time for some more #Excel formula fun. The VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in larger data...