Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations can get super challenging. However you are all covered as long as you can use the EFFECT function in Excel.…
Excel’s financial functions are here to help you with your daily finances. The PMT function is all about calculating payments for a loan. People on our Excel courses always want to know how their skills can apply to real…
If you have ever used VBA, you’ve used Collections. They are an object that can store multiple values. If you need a crash course on VBA from the ground up – check out our VBA Excel courses! Starting Off…
VBA Class Modules let you create your own custom objects. You can then combine this with object-oriented programming tools. This is one of the most advanced concepts we teach on our Excel courses, so take it step-by-step! What Is…
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, which are on the syllabus of our Excel VBA courses. This…
The FILTER function enables Excel users to filter data ranges. You can set your own criteria, and pull out only the information you need! The FILTER Function Learning to use filters is a basic Excel skill and covered during…
Excel already had the RAND and RANDBETWEEN functions – so why make another? RANDARRAY is special, as it generates random numbers in an array. It allows users to specify the minimum and maximum values, the number of rows and columns,…
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…
Most people using Excel, have used the MATCH function. However, with more features and flexibility, the XMATCH function is much more powerful. It helps you look out for values and identify their position from a given range or array. Learn…
The UNIQUE function is used to extract a range or array of unique values from a given array. The article below must help you learn all that you need to know about it. Using array functions can be a…
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. It is also…
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. We always keep our software up to…
