VBA Class Modules: A Step By Step Guide

In this tutorial, we will provide an introduction to VBA class modules. You can create your own custom objects by […]

The COUNTA Function – Use It In Your Own VBA Code!

In this post, we will review how to use the COUNTA Function in your VBA code. Excel allows you to […]

12 Best Time Management Techniques

  Time is your most valuable resource.  You only get a set amount of time each day, week, and year.  […]

FILTER Function – Master Excels Array Tools!

The FILTER function from the Dynamic Array Tools of Excel is the very long-awaited substitute for the conventional filtering functions […]

The RANDARRAY Function – Master Excel Array Tools!

While Excel already had RAND and RANDBETWEEN functions, what was the need for another random number generating function? The RANDARRAY […]

The Pareto Principle

  While listing out tasks to be done in order of priority, the question is: “how do you identify the […]

Ranking the Countries with the Best Work Environments around the World

  Few experiences enhance your professional expertise and strengthen your cultural awareness like living and working abroad. Learning how businesses […]

XMATCH Functions – Master Excels Array Tools!

Most people using Excel, have used the very important MATCH function. However, with more features and flexibility, the XMATCH function […]

UNIQUE Function – Mastering Excels Array Tools

There are a number of functions to Excel that enable users to extract a list of distinct values. Ranging from […]