Hello Excellers, a warm welcome back to #macromondays. I want to share with you a VBA or macro solution to an Excel process that you probably think already saves you a tonne of time. Do you...
Recent Posts
Count How Often A Value Occurs In A Data Set – Using The COUNTIF Formula – Formula Friday
Hello Excellers, today lets look at an Excel question that a twitter follower sent to me. Their question was 'how do I count how many times a certain word was used or appears in data set'?. ...
How To Apply Conditional Formatting To An Excel Pivot Table – Correctly – Excel Tip
This next tip I know causes a bit of frustration with Excel users, based on the number of times I have been asked about it. It is applying conditional formatting to a Pivot Table. The method of...
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,...
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...