Microsoft Excel
Our Excel articles below show clearly and simply how to use specific aspects of Microsoft Excel. We also cover these in our Excel training courses.
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…
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…
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…
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…