Hello Excellers and welcome back to another #formulafriday #exceltip in my Excel tip series. Today I want to share with you a question I was asked by a subscriber. They need to generate unique ID...

Have you ever wished there was an easier way to work with formulas in Excel? Well, there is. With Excel manual mode, you can control when formulas are recalculated, making it much easier to work...

Macro Monday time and that means some more Excel macros and VBA.  Today let's look at a tiny Macro that pulls a punch. Are you a Microsoft Excel user who stares in frustration at your workbook,...

Are you regularly transferring files from one folder to another? Things can quickly become tedious and time-consuming - but not anymore! Excel VBA Macros enable an easy yet efficient way of copying...

In this blog post, I will show you how to easily remove multiple hyperlinks from an Excel workbook. I recently had this question submitted via email from a subscriber. They had a LOT of hyperlinks...

Hello, Excellers. Welcome to another instalment of #formulafriday.   Today let's look at here a handy Excel Tip if you want to highlight today's date in your Excel data set.  I have...