Formula Friday- Don’t Update My Calculations…..Just Yet. Using Manual Mode In Excel
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...
Hello Excellers, welcome to another #Excel #FormulaFriday blog post in my Excel series. Today let's explore the UNIQUE function in Excel. This newly released function is part of the...
Macro Mondays – Unlock ALL Cells In An Excel Workbook With VBA
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,...
Formula Friday – Find The Date Of The Fourth Business Day Of The Next Month.
Do you find yourself trying to figure out the date of the a specific business day of a future month? If so, you’re not alone. It’s a question that can stump even the most experienced Excel users...
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...