Hi Excellers, welcome to another #macromonday blog post. I want to discuss and share my top five reasons to use Excel Macros. So, why use Excel macros?. Here are my reasons. Macros,...
Category: Blog
Turn Off Rounding In Excel And Use The TRUNC Function – Formula Friday
Hello, welcome to another #formulafriday blog post for some more formula fun on a Friday - why not?. Today let's take a look and explore the issue of Excel rounding or not rounding numbers. You...
Pivot Table Tip- Assign The Correct Row And Column Labels Quickly
Hello Excellers, today I want to share with you a really good Excel Pivot Table Tip with you. Do you ever quickly create a Pivot Table, then end up with really naff labels on them. A bit like...
Learn How To Create Your First Macro In Five Easy Steps – Macro Mondays
Hi Excellers. It is good to go back to basics now and again. So, that is what we are going to do today. Today we are going to get back to where it all begins on that Excel Macro journey. We...
Why Is My Formula Not Auto- Completing When I Type The Equals =Sign – Formula Friday
Hello Excellers, and welcome to another #formulafriday blog post. I want to share with you an issue one of my subscribers had. Their Excel was not behaving as 'normal'. When they began to...
Hello Excellers, today let's look at a really quick way to hide an Excel worksheet if a specific word appears in another worksheet. I find this really useful when I am working on an Excel solution,...