News & Tips
The Seinfeld Strategy: Become Consistent At Anything
Consistency is the key to success. Being consistent is incredibly difficult, as you will know if you’ve tried to form a new habit. In fact a large amount of the population struggle with consistency! Check our Time Management Statistics for…
The EFFECT Function – Master Excels Financial Tools!
Lets say you are signing up for a loan – it is crucial to know the real interest rate! Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations can get…
The PMT Function – Master Excels Financial Tools!
Only a basic sense of the financial functions of Excel will help you get through most of your daily-life financial calculations. Excel offers multiple financial functions including PMT, IPMT, and PPMT, all of which are designed to cater to the…
Collections In VBA – The Ultimate Guide
In this tutorial, we will provide a comprehensive overview of Excel VBA Collections. You will frequently need to work with Collections in your VBA code. If you would like to learn more about VBA, then please consider joining our top-rated…
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 using VBA class modules. This allows you to take advantage of concepts, associated with object-oriented programming in your VBA code.…
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 use many of the built-in worksheet functions in VBA. This means that you don’t have to write the code for…
[TOP 12] Best Time Management Techniques
Time is your most valuable resource. You only get a set amount of time each day, week, and year. What you do with it determines your success, or lack thereof, at work and in your personal life. Learn the…
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 of Excel. How would you typically filter data in Excel? Using data filters. Or, if the situation takes a more…
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 function was needed as it is not a mere random number generator but far more advanced and powerful. It allows…
The Pareto Principle
While listing out tasks to be done in order of priority, the question is: “how do you identify the most important task?” There are many different ways to prioritise your tasks and improve your time management. One excellent technique…
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 operate in foreign countries and having the chance to build relationships with international peers creates lasting rewards. Working abroad also…
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 is a successor to the MATCH function of Excel. It helps you look out for values and identify their position…