![](/wp-content/uploads/2022/09/course-header.jpg.webp)
News & Tips
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…
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…
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…
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 highlighting duplicate values to advanced filters, the methods are many. However, laboring about the same old conventional methods and functions is…
Mastering VBA Special Cells In Excel
In this post, we are going to review the VBA Special Cells method in Excel. You can use the VBA Special Cells Method to select cells of a specific type or that match a certain criterion. In addition, the VBA…
10 Tips For Delivering Professional Presentations
Many people describe presenting and public speaking as their greatest fears. Like most things in life presenting is a skill. It has to be practised and developed over time, no-one is born a great presenter. To help you learn…
SEQUENCE Function – Breakdown
SEQUENCE function is one of the most advanced and modern functions of Excel. It was introduced as a part of the dynamic array tools and is only accessible to Microsoft 365 users. To learn more about this intelligent array tool,…
Making A Gantt Chart In Excel (Quick & Easy!)
In this article, we will look at how to create a Gantt chart in Microsoft Excel. Gantt charts assist with project planning since they allow you to schedule and plan project activities. If you would like to learn more about…
Excel Facts & Statistics: Original Research
To inform how we teach our Excel training courses and find out more about how people are using Microsoft Excel in 2022 we have conducted some new, original research. In January & February 2022 we polled 1,000 office workers who…