Use The EXACT Function To Force Upper Case Data Entry Into Excel
Hello Excellers, a warm welcome back to another #formulafriday blog post. in my 2019 series. The Excel formula tip today is a recent favorite of mine at the moment, trying to get users to enter...
Hello Excellers and welcome back to another blog post in this #macromonday series. Today lets look at executing a function procedure in Excel. But first, if you need a reminder of the difference...
Formula Friday- Prevent Duplicate Data Entries With COUNTIF Formula And Data Validation
Happy Friday!...time to Excel with another #formulafriday blog post in this series. Today let's take a look at how to prevent duplicate name or employee ID numbers in a worksheet. So, how do we...
Let’s Explore The Excel VBA Editor Format Tab – Macro Monday
Hello Excellers, welcome back to another blog post in my #macromonday series for 2019. Today we are not writing any Excel VBA code. But let's look at how to customise your Exel VBA environment a...
Macro Monday – List All Links In An Excel Workbook With Simple VBA Code
Hello Excellers and welcome back for another blog post in my #macromonday series. Today's small but very useful Excel macro will list any links that you have in your Excel worksheet. I recently...
Formula Friday – FLOOR Function In Excel- Find Out The Decade That Song Was From
Happy Friday Excellers and welcome to another #formulafriday blog post. I found this little Excel formula out by accident. I was trying to find out what decade a date was from and thought it may...