News & Tips
5 Assertiveness Tips For Managers (+ Special Tips For Female Managers)
Assertiveness is a brilliant trait to have as a manager. When you are being assertive, you are communicating your needs in a way that is also respectful of others. This means that they feel that they understand where they stand…
Challenge yourself to solve this tricky office puzzle!
Brain teasers and puzzles are a great way for you to utilise your cognitive skills, helping you to learn, by improving your problem-solving skills, and memory as you use specific neural networks. What’s more, when solving a puzzle, you’re required…
Create And Personalise Your Excel Dashboard!
In this tutorial, we will take you through the steps needed to create an Excel Dashboard. We will also review some best practices when it comes to dashboard creation and visualization. An Excel Dashboard is a powerful visualization tool that…
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…