We’ve all been there – working on an Excel file, only to have it disappear after a crash! Panic sets in, and you start to worry everything is gone. But you still have options. These methods are very important…
There is often a need to execute certain actions or instructions repeatedly. This can be achieved by using loops in Power Automate. A loop in Power Automate is a control that can automate actions. In this article, we look in…
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…
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…
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…
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…
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…
The GROWTH function in Excel is one of the most powerful and is very underused! Excel GROWTH Function The Excel GROWTH function is also known as the exponential GROWTH function. It is a statistical function that returns predictive values…
